Hi!

We are using JayBird JCA driver with JBoss and have a problem.
We have some code that performs some actions on database (inserts
updates, deletes, selects). Once this code executed after about 20
minutes we are starting to get exceptions. Any suggestions?

Vesions: Jaybird 1.5 RC4, Firebird 1.5.1, Jboss 3.2.5

--
Thanks,

Dmitry Shohov


Exception:

2004-08-18 17:28:41,066 INFO [org.jboss.resource.connectionmanager.TxConnectionManager] Could not enlist in transaction on entering meta-aware object!
javax.transaction.SystemException: Could not register synchronization with tx: javax.transaction.RollbackException: Already marked for rollback
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:469)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:502)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:85)
at lv.epasaule.eagentintegraII.core.FirebirdDAO.getDbConnection(FirebirdDAO.java:35)
...
2004-08-18 17:28:41,066 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=shohou//341, BranchQual=] errorCode=XAER_NOTA
org.firebirdsql.jca.FBXAException: Unrecognized transaction
at org.firebirdsql.jca.FBManagedConnection.internalEnd(FBManagedConnection.java:441)
at org.firebirdsql.jca.FBManagedConnection.end(FBManagedConnection.java:413)
at org.jboss.tm.TransactionImpl.endResource(TransactionImpl.java:1253)
at org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:549)
at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.delist(TxConnectionManager.java:486)
at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionDisconnected(TxConnectionManager.java:352)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:506)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:887)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:85)
at lv.epasaule.eagentintegraII.core.FirebirdDAO.getDbConnection(FirebirdDAO.java:35)
...
This two stacktraces logged by JBoss

2004-08-18 17:28:41,082 FATAL [EPLOG]
org.firebirdsql.jdbc.FBSQLException: Problem getting connection: javax.resource.ResourceException: Failure to delist resource
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:88)
at lv.epasaule.eagentintegraII.core.FirebirdDAO.getDbConnection(FirebirdDAO.java:35)
...

This is stacktrace from exception we get.