7 Replies Latest reply: Mar 9, 2012 1:52 AM by Wolf-Dieter Fink RSS

I meet a problem when I use XA Transaction

andy215 Newbie

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