I received a similar (identical?) error when I was first starting up, and
the solution was to be very careful to ALWAYS close ResultSets.

ResultSet rset = stmt.executeQuery("select foo from bar where ID=7");
int foo = rset.getInt(1);
rset.close();

> -----Original Message-----
> From: Khawaja Shams [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, January 12, 2006 4:14 PM
> To: Tomcat Users List
> Subject: connection pooling mysql (Pool Exhausted exception)
> 
> Hello,
>    I am consistently getting exceptions about my connection 
> pool being exhausted in my application.  I am curious where I 
> can configure the number of connections tomcat should 
> maintain in the connection pool.  Lastly, am I right in 
> assuming that the only thing I need to do in order to return 
> a connection to the pool is to return to close the 
> connection? Do I have to do anything about the statements I 
> have created using that connection? Thanks in advance.  for your help.
> 
> 
> Best Regards,
> Khawaja Shams
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to