#61 DefaultQuery may not be closing connections properly

[Shash Chatterjee]

Reported by Nathan Kontny:

Mike, I noticed that Aleks has sent a message a week
ago about a problem with
DefaultQuery. I am seeing the same thing. After using
DefaultQuery in my app,
about 8 times (against Mysql 4), I get the exception:

org.apache.avalon.excalibur.datasource.NoAvailableConnectionException:
Could not
create enough Components to service your request.

And a JDBC connection can no longer be retrieved. At
first I thought maybe this
is a MySQL thing. I went and tried the earlier stable
driver and the newer
3.1.1 alpha driver, and still no success.

Reading some of the avalon newsgroups this might be
solved by increasing the
pool size or increasing wait times. Not sure yet where
this is, but has anyone
had to mess with this before. Makes me worried that
something isn't closing
it's connection, but the DefaultQuery and
DefaultPersistent classes do....

[Shash Chatterjee]

Logged In: YES
user_id=566374

Modified Files:
DefaultQuery.java
Log Message:
Bug ID: [ 929456 ] DefaultQuery may not be closing
connections properly
Patch provided by Aleks

Index: DefaultQuery.java

RCS file:
/cvsroot/keel/svc-query-jdbc/src/java/org/keel/services/query/jdbc/DefaultQuery.java,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- DefaultQuery.java 10 Mar 2004 03:37:28 -0000 1.4
+++ DefaultQuery.java 4 Apr 2004 23:39:16 -0000 1.5