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]
