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