1 Reply Latest reply on Jul 29, 2005 3:48 AM by Ulf Schroeter

    XA versus non-XA datasource

    Baba Booey Newbie

      Hi,
      I am not sure what the difference is between, say, the oracle-ds.xml versus the oracle-xa-ds.xml datasource. Which one should I use? What are the benefits?

      Thanks!

        • 1. Re: XA versus non-XA datasource
          Ulf Schroeter Novice

          The XA version supports the 2-phase-commit protocol for multi-resource transaction handling. Multiple resources (e.g. JMS-Provider and your database) can be enlisted to the same transaction. A commit failure on one resource will rollback the whole transaction for ALL enlisted resources (all or nothing).

          Usage of the XA-datasource connection provides the maximum flexibility and reliability without introducing overhead for single-resource-only transactions (where no 2-phase commit is required)

          Regards
          Ulf