Re: Share my experience and Thank you ! - Mailing list pgsql-general

I use Debian Wheezy and PostgreSQL 9.1 is the default package.

On Fri, May 13, 2016 at 3:13 PM, JingYuan Chen <phil.cyc@gmail.com> wrote:

I use Debian Wheezy and PostgreSQL 9.1 is the default package.

On Fri, May 13, 2016 at 3:06 PM, Arthur Silva <arthurprs@gmail.com> wrote:

Any specific reason for choosing this old version of postgres?

On May 13, 2016 8:46 AM, "JingYuan Chen" <phil.cyc@gmail.com> wrote:

Hello,

I want to share my experience about one of my projects and say thank you to the community.

Scenario :
My company's ERP system is SAP and rent a procurement system for bid. It's architecture bases on Webshpere5 and Oracle and IBM Java 1.4. The provider informed us that they decide to close this bid platform on 2016/03/31 about 3 month ago.

The good news is that they can give us the complete source code. But we don't have Webshpere and another Oracle License for this system. Fortunately, I found that there is a PostgreSQL wiki site providing useful information about tools and migration tips. After doing some analysis, I decide to use Jetty 9 and PostgreSQL 9.1 and Oracle Java 1.7 to replace them. Transferring data is another problem. I decide to use Pentaho Data Integration tool. It is an ETL tool. I can learn about the status of transferring until the job was done. It helps me to keep the consistency of data in Oracle and PostgreSQL.

After modifying many SQL commands to be suitable for PostgreSQL and setting  web.xml for Jetty, our procurement system can be active successfully without Webshpere and Oracle. However, its performance is poorly. I found that there are two problems to result in this situation. One is that JVM will crash accidentally. The other is that sometimes JDBC could not connect to PostgreSQL.

Fortunately, Jetty is flexible and Java's garbage collection log provides useful information. I can tune JVM with different parameters while initiating Jetty. The last problem is JDBC. It use DBCP 1.3 as default to connect database. According to our new architecture, I replace DBCP with PGConnectionPoolDataSource.

Now our system is running smoothly with this kind of architecture. I also use some PERL scripts to transfer data and JCO RFC to perform SAP's transaction.

Thank You All !

Regards,

Chingyuan