1 Reply Latest reply on Jun 19, 2003 8:00 AM by sashahunt

    Oracle XA Datasource Problem

    tamtam Newbie

      hi all

      as always! problems with oracle and xa... ;-(

      i'm porting our erp-solution from jboss 2.4.4 to jboss 3.2.x i configured the oracle xa-datasource (using the oracle-xa-ds.xml example). i spent a lot of time but it doesn't work. (with jboss 2.4.4 there is no problem)

      oracle db-server version: oracle 8i
      jboss-version: 3.2.2rc1 (also tested with 3.2.1)
      jdbc-driver: 9.2.0.1 (also tested with the newest driver from oracle 9.2.0.3)

      oracle-xa-ds.xml:

      <xa-datasource>
      <jndi-name>BisonDataSource</jndi-name>
      <track-connection-by-tx>true</track-connection-by-tx>
      <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:@bisdevdb:1521: prod</xa-datasource-property>
      <xa-datasource-property name="User">theUsername</xa-datasource-property>
      <xa-datasource-property name="Password">thePassword</xa-datasource-property>
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      </xa-datasource>


      deploying is ok - no errors.
      first access to the database:

      12:40:08,366 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl [Fo
      rmatId=257, GlobalId=Bisonws1031//33, BranchQual=] errorCode=XAER_RMERR
      oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157
      )
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:29
      5)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManage
      dConnection.java:133)
      at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1137)

      at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:624)

      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnection
      EventListener.enlist(TxConnectionManager.java:460)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConne
      ctionReconnected(TxConnectionManager.java:358)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
      onnection(BaseConnectionManager2.java:491)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
      nManagerProxy.allocateConnection(BaseConnectionManager2.java:799)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
      erDataSource.java:102)
      at CH.obj.Libraries.Session.EJBMasterSessionContext.allocateConnection(E
      .
      .
      .
      12:40:09,277 ERROR [STDERR] org.jboss.util.NestedSQLException: Could not enlist
      in transaction on entering meta-aware object!javax.transaction.SystemException:
      enlistResource failed; - nested throwable: (javax.resource.ResourceException: Co
      uld not enlist in transaction on entering meta-aware object!javax.transaction.Sy
      stemException: enlistResource failed)
      12:40:09,287 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSo
      urce.getConnection(WrapperDataSource.java:106)
      12:40:09,287 ERROR [STDERR] at CH.obj.Libraries.Session.EJBMasterSessionCont
      ext.allocateConnection(EJBMasterSessionContext.java:108)
      .
      .
      .


      hope anyone has an idea!

      thanks

      martin