XA versus non-XA datasource

[fourierxform]

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!

[schrouf]

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