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]