Re: Resource management in new Tomcat JDBC connection pool.

2013-04-10 Thread Bertrand Guay-Paquet
Hi, Have a look at http://markmail.org/thread/iqgvj34347z77tnc for a bug in the current Tomcat version and its workaround. This seems to affect MySQL primarily. Regards, Bertrand On 10/04/2013 4:05 PM, Igor Urisman wrote: Hello, The new Tomcat 7 JDBC pool

Re: Tomcat jdbc-pool not closing statements

2013-03-20 Thread Bertrand Guay-Paquet
19.03.2013 22:20, schrieb Bertrand Guay-Paquet: On 19/03/2013 5:05 PM, Felix Schumacher wrote: Have you looked at http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak ? It seems like your problem. Regards Felix Indeed, this is extremely similar to my issue. Thanks for sharing

Re: Tomcat jdbc-pool not closing statements

2013-03-20 Thread Bertrand Guay-Paquet
19.03.2013 22:20, schrieb Bertrand Guay-Paquet: On 19/03/2013 5:05 PM, Felix Schumacher wrote: Have you looked at http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak ? It seems like your problem. Regards Felix Indeed, this is extremely similar to my issue. Thanks for sharing

Re: Tomcat jdbc-pool not closing statements

2013-03-19 Thread Bertrand Guay-Paquet
On 19/03/2013 5:05 PM, Felix Schumacher wrote: Have you looked at http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak ? It seems like your problem. Regards Felix Indeed, this is extremely similar to my issue. Thanks for sharing this. It does seem however like the S

Re: Tomcat jdbc-pool not closing statements

2013-03-19 Thread Bertrand Guay-Paquet
Can you post some example of your code? Can you also post your pool's configuration? Here is my configuration from tomee.xml. I'm not 100% sure how it maps to Tomcat values though. JdbcDriver=com.mysql.jdbc.Driver JdbcUrl=jdbc:mysql://localhost:3306/DBNAME UserName= Password=

Tomcat jdbc-pool not closing statements

2013-03-19 Thread Bertrand Guay-Paquet
Hello, I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a memory leak in my web application which uses jdbc connection pooling with Tomcat's jdbc-pool. The com.mysql.jdbc.JDBC4Connection class has a field named "openStatements" which holds, as you can imagine, open sql statement