1 Reply Latest reply on Mar 21, 2006 1:30 PM by adrian.brock

    Oracle10g + XA + Serializable

    slobo

      I try to configure an XA datasource with Oracle10g
      but if I put
      <transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation>
      into the <xa-datasource>
      then I get the following error on JBoss startup:

      2006-03-15 13:17:49,938 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=egistir/2, BranchQual=, localId=2] errorCode=XAER_PROTO
      oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:131)
      etc.

      (if I comment out the transaction-isolation, then it starts up without problem)

      how can I use serializable transactions with Oracle10g XA datasource?

      I use the Oracle 10g thin driver with JBoss Application Server 4.0.3 SP1 + JBoss EJB3 RC5, JDK1.5

      I read something about the OracleXAResource.ORATMSERIALIZABLE constant, I wonder if it has anything to do with this problem...