Re: Share my experience and Thank you !

Any specific reason for choosing this old version of postgres?
On May 13, 2016 8:46 AM, "JingYuan Chen" <phil(dot)cyc(at)gmail(dot)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
>