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

Cannot enlist two Oracle XAConnection resources in one transaction

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 4.7.0
    • 4.15.0
    • JTA

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: