Uploaded image for project: 'JBoss Transaction Manager'
  1. JBoss Transaction Manager
  2. JBTM-619

Cannot enlist two Oracle XAConnection resources in one transaction

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • 4.15.0
    • 4.7.0
    • JTA

      An attempt to enlist two Oracle connections causes the second enlistResource to fail with an exception similar to:

      oracle.jdbc.xa.OracleXAException
      at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)
      at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:902)
      at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:513)

      Note the line number changes a bit depending on version of Oracle JDBC etc. However, the affect is always the same.

      There are others who noted this problem on the forum with no resolution or reply (except my own concurring with the observation).

      In particular two connections to same server using different user id's and passwords. I will test whether two completely separate oracle instances have this issue and update the bug.

              rhn-engineering-jhallida Jonathan Halliday
              wpoziombka Wade Poziombka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: