andy215 [https://community.jboss.org/people/andy215] created the discussion "I meet a problem when I use XA Transaction" To view the discussion, visit: https://community.jboss.org/message/717372#717372 -------------------------------------------------------------- I deployed oracle-xa-ds.xml, it looks like: <datasources>   <xa-datasource>     <jndi-name>XAOracleDS</jndi-name>     <!-- uncomment to enable interleaving <interleaving/> -->     <isSameRM-override-value>false</isSameRM-override-value>     <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>     <xa-datasource-property name="URL">jdbc:oracle:thin:@ip:port:test</xa-datasource-property>     <xa-datasource-property name="User">test</xa-datasource-property>     <xa-datasource-property name="Password">test</xa-datasource-property>     <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->     <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->     <!-- Checks the Oracle error codes and messages for fatal errors -->     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>     <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->     <no-tx-separate-pools/>       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->       <!--       <metadata>          <type-mapping>Oracle9i</type-mapping>       </metadata>       -->   </xa-datasource>   <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"          name="jboss.jca:service=OracleXAExceptionFormatter">     <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>   </mbean> </datasources> I use EJB,   my code looks like: private EntityManager em;     public void greet(String message) {         GreetingEbo ebo = new GreetingEbo();         ebo.setGreeting(message);         em.persist(ebo);     } When I invoke greet() api, there is a exception: oracle.jdbc.xa.OracleXAException     at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157)     at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295)     at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:213)     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:789)     at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:500)     at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:908)     at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:662)     at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:403)     at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:625)     at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:499)     at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)     at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)     at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:46)     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)     at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:116)     at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:54)     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2186)     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2666)     at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)     at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)     at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)     at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)     at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)     at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:49)     at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)     at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)     at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)     at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:645)     at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:619)     at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:623)     at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:220)     at org.jboss.jpa.tx.TransactionScopedEntityManager.persist(TransactionScopedEntityManager.java:187)     at com.andy.proxy.EjbTestProxyBean.greet(EjbTestProxyBean.java:39) I don't the root cause, anybody can give some help? thanks -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/717372#717372] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]