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