Getting this following error when obtaining database connection from the SQLServer datasource defined via mssql-ds.xml :
2004-12-16 18:37:01,617 WARN [org.jboss.tm.TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=patframdqf02//12724, BranchQual=] timed out. status=STATUS_ACTIVE
2004-12-16 18:37:03,117 ERROR [STDERR] org.jboss.util.NestedSQLException: Interrupted while requesting permit! Waited 0 ms, invocation time: 1103240223118; - nested throwable: (javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms, invocation time: 1103240223118)
2004-12-16 18:37:03,132 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
We have the following scenario.
1. Stateless session beans running in a container managed transaction mode.
2. These transactions are Batch transactions that typically performs around 30 inserts to various tables in one transactional method.
This issue occurs sporadically and we are not able to trace the issue. one thing i noticed is that there are some observed locks blocking on some tables when monitored via the locks/processid in the sqlserver management section.
Any clues, how to go about it