Re: Tomcat and PostgreeSQL

2013-06-06 Thread Dhaval Jaiswal
Adding to it.. as usual In server.xml, resource need to mentioned the type, driverClassName, url and connectivity parameter of PostgreSql db. as usual In a context.xml, ResourceLink name, global, type and allow the IP of tomcat at db end in pg_hba.conf file to connect the db. On Fri, Jun

Re: Tomcat and PostgreeSQL

2013-06-06 Thread Lutischán Ferenc
Hi, on 2013.06.06. 22:45, Hector Del Mestre wrote: Well, now the fatal question: Tomcat need any special configuration to use PostgreSQL? I have some ideas: - The jdbc driver must be in the {Tomcat home}/lib. - If you use the tomcat pool manager append the testOnBorrow="true" to the Resource

Re: Tomcat and PostgreeSQL

2013-06-06 Thread Hector Del Mestre
ples. Set these in Catalina.sh > CATALINA_OPS. > > Oliver > > > > -Original Message- > From: users-return-242170-OLIVER.TANGLIN=saic@tomcat.apache.org on > behalf of Ilya Kazakevich > Sent: Thu 6/6/2013 5:50 PM > To: 'Tomcat Users List' > S

RE: Tomcat and PostgreeSQL

2013-06-06 Thread Tanglin, Oliver
-Original Message- From: users-return-242170-OLIVER.TANGLIN=saic@tomcat.apache.org on behalf of Ilya Kazakevich Sent: Thu 6/6/2013 5:50 PM To: 'Tomcat Users List' Subject: RE: Tomcat and PostgreeSQL I've never heard about it but looks like JDBC PostgreSQL driver

RE: Tomcat and PostgreeSQL

2013-06-06 Thread Ilya Kazakevich
I've never heard about it but looks like JDBC PostgreSQL driver has memory leak. What version of driver do you use? Try to google "postgre SQL JDBC memory leak" Actually any memory leak should be investigated using profiler tool. Google for "java profile memory leaks" Ilya. >-Original Messag

Re: Tomcat and PostgreeSQL

2013-06-06 Thread Hector Del Mestre
Thank you very much: I will check what you suggested. The Java version is 1.7 regards 2013/6/6 Caldarale, Charles R > > From: Hector Del Mestre [mailto:hectordelmes...@gmail.com] > > Subject: Tomcat and PostgreeSQL > > > The application was done with AppFuse architecture originally utlizando

RE: Tomcat and PostgreeSQL

2013-06-06 Thread Caldarale, Charles R
> From: Hector Del Mestre [mailto:hectordelmes...@gmail.com] > Subject: Tomcat and PostgreeSQL > The application was done with AppFuse architecture originally utlizando > MySQL, but issues like licensing and client wants to use PostgreSQL. > And that is where I'm stuck, because Tomcat (or rather