I use Debian Wheezy and PostgreSQL 9.1 is the default package. On Fri, May 13, 2016 at 3:13 PM, JingYuan Chen <phil....@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 <arthur...@gmail.com> wrote: > >> 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 >>> >> >
