5 Replies Latest reply on Mar 30, 2007 4:31 AM by mm bouallagui

    JBoss + Oracle XA Connection  --> WARN : JBossResourceExcept

    mm bouallagui Newbie

      Hello,

      I'm trying to configure a connection to my Oracle database under JBoss 4.0.4 GA. My application manages to connect to the database and can load the data from it. But I get frequently this error :

      2007-03-29 15:45:38,531 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Error during tidyup org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@476914[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1117cc0 handles=0 lastUse=1175175938468 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@1152c0e context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@ff6348 xaResource=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@1117cc0 txSync=null]
      org.jboss.resource.JBossResourceException: xa tx only!
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.getLocalTransaction(XAManagedConnection.java:80)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.tidyup(TxConnectionManager.java:657)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.java:336)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:623)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:266)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:129)



      I've configured the xa-datasource by following the instructions given in the "start guide" from JBoss website :

      ******* oracle-xa-ds.xml ****

      <xa-datasource>
      <jndi-name>jdbc/MyDS</jndi-name>
      <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:@localhost:1521:dev</xa-datasource-property>
      <xa-datasource-property name="User">dev</xa-datasource-property>
      <xa-datasource-property
      name="Password">dev</xa-datasource-property>

      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <no-tx-separate-pools/>

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
      (optional) -->

      <type-mapping>Oracle9i</type-mapping>

      </xa-datasource>


      <depends
      optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager





      ****** jta-service (adding Pad= true) ***
      <!-- The configurable Xid factory. For use with Oracle, set pad to
      true -->

      true






      Does somebody have encountered this problem ? Please, tell me where i'm wrong.

      Thanks a lot for your answer.