Thread: Share my experience and Thank you !
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
Any specific reason for choosing this old version of postgres?
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
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
I think that you can safely add the PostgreSQL repository to your system, so that you can get the latest packages for your Debian.
See there how to do it:
https://wiki.postgresql.org/wiki/Apt
Regards,
Pierre
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
--
Envoyé de mon appareil Android avec K-9 Mail. Veuillez excuser ma brièveté.
Chingyuan,
>I also use some PERL scripts to transfer data and JCO RFC to perform SAP's transaction.
FYI. We also "mate" Postgres with SAP.
Our transactions are exposed on the SAP system via a SOAP interface ( some "switches" your SAP people need to throw ).
Tested and developed with bash scripts and cURL the executable to get the headers etc correct, then our own C executable using cURL as a library, then wrapped Postgres C function call around our C code to have Postgres function.
SAP transactions are fully integrated into the "SQL" of the system.
Allan
Arrium Limited and associated entities are currently in Voluntary Administration. A list of all associated entities in Voluntary Administration may be obtained from: "http://www.arrium.com/~/media/Arrium Mining and Materials/Files/Corporate documents/Arrium Administration_Groups List.pdf". The material contained in this email is confidential and may be subject to legal privilege and/or copyright. Please do not re-transmit, distribute, copy or commercialise any of the material in this message unless you are authorised to do so. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. None of Arrium Limited, its related bodies corporate or the sender accept responsibility for any viruses contained in this email or any attachments. All and any rights as to confidentiality, legal professional privilege and copyright are expressly reserved.