Getting Trying to return an unknown connection2!
gbeutler Apr 27, 2004 6:44 AMHi,
I'm using Apache OJB inside of JBoss-3.2.3.
If I access a jdbc connection from datasource and in the same (or in RequiresNew) transaction access the database via OJB I get a
java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.resource.adapter.jdbc.WrappedConnection@40567be5 at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.java:330) at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:539) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:296) at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:117) at org.apache.ojb.broker.util.WrappedConnection.close(WrappedConnection.java:124) at org.apache.ojb.broker.util.pooling.ByPassConnection.close(ByPassConnection.java:64) at org.apache.ojb.broker.accesslayer.ConnectionFactoryAbstractImpl.releaseConnection(ConnectionFactoryAbstractImpl.java:79) at org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.releaseConnection(ConnectionManagerImpl.java:286) at org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl$PersistenceBrokerSyncImpl.beforeCompletion(PersistenceBrokerFactorySyncImpl.jav a:177) at org.apache.ojb.broker.core.PersistenceBrokerFactorySyncImpl$TransactionBox.beforeCompletion(PersistenceBrokerFactorySyncImpl.java:329) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1308)
I already turned on the trace for tm and resource package. This reports for the above connection:
2004-04-27 11:24:12,468 TRACE [org.jboss.resource.connectionmanager.CachedConnectionManager] registering connection from org.jboss.resource.connection manager.TxConnectionManager@3b48a8e6, connection : org.jboss.resource.adapter.jdbc.WrappedConnection@40567be5, key: org.jboss.resource.connectionmanag er.CachedConnectionManager$KeyConnectionAssociation@31672113
and
2004-04-27 11:24:12,560 TRACE [org.jboss.resource.connectionmanager.TxConnectionManager] connectionClosed called 2004-04-27 11:24:12,560 TRACE [org.jboss.resource.connectionmanager.CachedConnectionManager] unregistering connection from org.jboss.resource.connecti onmanager.TxConnectionManager@3b48a8e6, object: org.jboss.resource.adapter.jdbc.WrappedConnection@40567be5, key: org.jboss.resource.connectionmanager. CachedConnectionManager$KeyConnectionAssociation@b0703dc 2004-04-27 11:24:12,564 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] throwable from unregister connection
I found that the key object is different.
I would like to know what's the problem and what I can do to fix it. The problem does no occur as long as I do not mix JDBC and OJB database access. All EJB's uses container managed transaction.
Thanks in advance, best regards,
Guido