It's not a secret anymore!
The moose likes JBoss/WildFly and the fly likes JBoss / Oracle Rollback Problem - XARessource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "JBoss / Oracle Rollback Problem - XARessource" Watch "JBoss / Oracle Rollback Problem - XARessource" New topic

JBoss / Oracle Rollback Problem - XARessource

igor abalam

Joined: Jun 01, 2006
Posts: 2

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(
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(
at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(

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

igor abalam

Joined: Jun 01, 2006
Posts: 2
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.
I agree. Here's the link:
subject: JBoss / Oracle Rollback Problem - XARessource
jQuery in Action, 3rd edition