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
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
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
-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
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
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
> 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