Re: Share my experience and Thank you !

Hello,

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

Le 13 mai 2016 09:14:28 GMT+02:00, JingYuan Chen <phil(dot)cyc(at)gmail(dot)com> a écrit :
>I use Debian Wheezy and PostgreSQL 9.1 is the default package.
>
>On Fri, May 13, 2016 at 3:13 PM, JingYuan Chen <phil(dot)cyc(at)gmail(dot)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(at)gmail(dot)com>
>wrote:
>>
>>> 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
>>>>
>>>
>>

--
Envoyé de mon appareil Android avec K-9 Mail. Veuillez excuser ma brièveté.