I've looked up the HsqlDB datasource from the default configuration (java:/DefaultDS), and can use it alright. But, when I close() it I get the following exception:
java.lang.IllegalArgumentException: disconnect(ManagedConnection mc, Object c) c
alled with unknown managed connection
at org.jboss.resource.connectionmanager.BaseConnectionManager2.unregiste
rAssociation(BaseConnectionManager2.java:529)
at org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalCo
nnectionEventListener.connectionClosed(LocalTxConnectionManager.java:382)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.closeHan
dle(LocalManagedConnection.java:303)
at org.jboss.resource.adapter.jdbc.local.LocalConnection.close(LocalConn
ection.java:97)
...
And if I don't close it the pool runs out of connections. This is done from a servlet.
Any idea what's wrong? I searched the forums but couldn't find anything on this. Since this is just plain JDBC on the default DS one'd think that it'd crop up for pretty much everyone...
I'm using 3.1.0alpha from a couple of weeks back.
/Rickard
This happens if there is an SQL-exception thrown by the query/update. I guess this is just a bug in the pool manager.
/Rickard