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 the
Thank you very much:
I will check what you suggested.
The Java version is 1.7
regards
2013/6/6 Caldarale, Charles R chuck.caldar...@unisys.com
From: Hector Del Mestre [mailto:hectordelmes...@gmail.com]
Subject: Tomcat and PostgreeSQL
The application was done with AppFuse architecture
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
-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 has memory
leak
and examples. 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'
Subject: RE: Tomcat and PostgreeSQL
I've never heard
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
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
ResourceLink name=jdbc/DB_NAME global=jdbc/DB_NAME
type=javax.sql.DataSource/
and allow