Subject Connection failure during managed transaction
Author Rick DeBay
Updating/inserting a large number of records from within a stateless
session bean causes one of the items to randomly fail with the following
messages:

Warning that showed up in JBoss output immediately before exception.
15:41:01,225 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl
[FormatId=257, GlobalId=rick//124, BranchQual=] timed out.
status=STATUS_ACTIVE

Error and State from SQLException:
error code=0 SQL state=HY000

Exception that I threw:
com.rxstrategies.dao.DAOSystemException: Can't connect:Problem getting
connection: javax.resource.ResourceException: Interrupted while
requesting permit! Waited 0 ms, invocation time: 1090525261246
at
com.rxstrategies.dao.AbstractDAOFactory.getConnection(AbstractDAOFactory
.java:42)

Previous exception:
Caused by: org.firebirdsql.jdbc.FBSQLException: Problem getting
connection: javax.resource.ResourceException: Interrupted while
requesting permit! Waited 0 ms, invocation time: 1090525261246
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:82)
at
com.rxstrategies.dao.AbstractDAOFactory.getConnection(AbstractDAOFactory
.java:27)

This is with Jaybird RC3, Firebird 1.5.1, and JBoss 3.2.5. I don't have
a reproducible scenario I can send, but I can cause it to fail
consistently.

Rick DeBay
Senior Software Developer
RxStrategies.net