Hi all,

I made desperate efforts to configure and use xa transaction support to life.

My environment:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
jboss-3.0.4_tomcat-4.1.12

I followed the example and copied 'oracle-xa-service.xml' to the deploy directory and changed the database url, username, password.

A very simple EntityBean that uses the datasource is called by a test client.

TheEntity entity = entityHome.create(...);

I got this Exception:

java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
  java.rmi.ServerException: RuntimeException; nested exception is:
  java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout


The server log shows:

2002-12-13 13:56:39,428 WARN [org.jboss.tm.TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=CMOUTTET//0, BranchQual=] errorCode=XAER_RMERR
oracle.jdbc.xa.OracleXAException
  at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:483)
  at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:190)
  at org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1232)
  at org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:726)
  at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:102)
  at org.jboss.resource.connectionmanager.XATxConnectionManager$XAConnectionEventListener.enlist(XATxConnectionManager.java:262)
  at org.jboss.resource.connectionmanager.XATxConnectionManager.managedConnectionReconnected(XATxConnectionManager.java:202)
  at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:534)
  at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
  at org.jboss.resource.adapter.jdbc.JDBCDataSource.getConnection(JDBCDataSource.java:110)
  at NamedEntityEJB.ejbCreate(NamedEntityEJB.java:43)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceManager.java:220)
  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
  at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:731)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1119)
  at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:206)
  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
  at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
  at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
  at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
  at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
  at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
  at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
  at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
  at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
  at org.jboss.ejb.Container.invoke(Container.java:730)
  at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
  at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
  at sun.rmi.transport.Transport$1.run(Transport.java:148)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
  at java.lang.Thread.run(Thread.java:536)
2002-12-13 13:56:39,490 WARN [org.jboss.tm.TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=CMOUTTET//0, BranchQual=] errorCode=XAER_RMERR
oracle.jdbc.xa.OracleXAException
  at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:483)
  at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:285)
  at org.jboss.tm.TxCapsule.endResource(TxCapsule.java:1289)
  at org.jboss.tm.TxCapsule.delistResource(TxCapsule.java:620)
  at org.jboss.tm.TransactionImpl.delistResource(TransactionImpl.java:92)
  at org.jboss.resource.connectionmanager.XATxConnectionManager$XAConnectionEventListener.delist(XATxConnectionManager.java:284)
  at org.jboss.resource.connectionmanager.XATxConnectionManager$XAConnectionEventListener.connectionClosed(XATxConnectionManager.java:331)
  at org.jboss.resource.adapter.jdbc.BaseManagedConnection.fireConnectionEvent(BaseManagedConnection.java:152)
  at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.fireConnectionEvent(XAManagedConnection.java:215)
  at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection$1.connectionClosed(XAManagedConnection.java:127)
  at oracle.jdbc.pool.OraclePooledConnection.callListener(OraclePooledConnection.java:241)
  at oracle.jdbc.pool.OraclePooledConnection.logicalClose(OraclePooledConnection.java:215)
  at oracle.jdbc.driver.OracleConnection.logicalClose(OracleConnection.java:1955)
  at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:904)
  at NamedEntityEJB.ejbCreate(NamedEntityEJB.java:58)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceManager.java:220)
  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
  at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:731)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1119)
  at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:206)
  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
  at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
  at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
  at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
  at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
  at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
  at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
  at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
  at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
  at org.jboss.ejb.Container.invoke(Container.java:730)
  at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
  at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
  at sun.rmi.transport.Transport$1.run(Transport.java:148)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
  at java.lang.Thread.run(Thread.java:536)
2002-12-13 13:56:39,506 ERROR [org.jboss.ejb.BeanLock] Saw rolled back tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=CMOUTTET//0, BranchQual=]
2002-12-13 13:56:39,521 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException:
java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout
  at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(QueuedPessimisticEJBLock.java:194)
  at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.schedule(QueuedPessimisticEJBLock.java:150)
  at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:220)
  at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
  at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
  at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
  at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
  at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
  at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
  at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
  at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
  at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
  at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
  at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
  at org.jboss.ejb.Container.invoke(Container.java:730)
  at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)
  at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
  at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
  at sun.rmi.transport.Transport$1.run(Transport.java:148)
  at java.security.AccessController.doPrivileged(Native Method)
  at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
  at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
  at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
  at java.lang.Thread.run(Thread.java:536)


I could see that a transaction on the database table is pending (table v$locked_object). I thinks it's NOT rollbacked. After shutting down JBoss process (Ctrl-C) the pending transaction is committed.

I also used non-xa datasources. My little test EJB worked fine. But with my current project application (uses ByApplication criteria) I got ugly exceptions (see http://jboss.org/forums/thread.jsp?forum=136&thread=25672). I thought that using XA would solve that problems.

Please, can someone tell me that's going on? Is there something that has to be installed on the Oracle database?

Thank's for your support

-chris