RE: connection pooling mysql (Pool Exhausted exception)

2006-01-14 Thread George Sexton
> -Original Message- > From: Daniel Blumenthal [mailto:[EMAIL PROTECTED] > Sent: Friday, January 13, 2006 8:51 PM > To: 'Tomcat Users List' > Subject: RE: connection pooling mysql (Pool Exhausted exception) > > I received a similar (identical?) error when

RE: connection pooling mysql (Pool Exhausted exception)

2006-01-13 Thread Daniel Blumenthal
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 Sham