I have a JBoss batch that updates an Oracle database and the following error occurs :
javax.resource.ResourceException: Could not enlist in transaction on entering meta-aware object!javax.transaction.SystemException: Could not enlist XAResource!javax.transaction.RollbackException: Already marked for rollback at org.jboss.resource.connectionmanager.LocalTxConnectionManager.managedConnectionReconnected(LocalTxConnectionManager.java:260) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:534) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812) at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)
Every posts I found on forums didn't help me : some of them says to change version, but I can't do that. Some other posts simply don't answers the question.
My config : JBoss 3.0.2 Oracle 8i
posted 9 years ago
I found the solution.
The execution was too long, causing the connection to abort and to rollback. By optimising my sql statement, I reduced the execution time and now everything works fine.