Re: DBCP error

2011-06-01 Thread Dhaval Jaiswal
Hi Martin, We have modified all timeout,buffersize,pool related parameters from mysql server side. However, still we are getting DBCP errors. We have practice to close the database connection in finally block of java , in the std practice order of resultset to conn.close.. What would be other thi

Re: DBCP error

2011-05-11 Thread Dhaval Jaiswal
Yeah, we have some of the SQL statements which are running more than 1 minutes. However, for small queries it's also throwing errors DBCP. -- Regards, Dhaval On Fri, May 6, 2011 at 4:59 PM, Martin Gainty wrote: > Id the execution delivers results in under a minute then adhere to Mr > Woods a

RE: DBCP error

2011-05-06 Thread Martin Gainty
connection leaks will occur because of code maladies did you check your code to ensure: you are closing Statement Handles when you have finished executing the statement? you are closing Connection Handles when you have finished DML and DDL operations with the Database? ? Martin