Hi All,

What is the Difference between local and XA Transaction.


XA is a standard for distributed transactions used for coordinated a single transaction across multiple systems. Local transaction is the default and what is used for normal transaction processing for single system. Generally speaking in order to use XA transactions the target system must support it.

I generally do not recommend XA transactions because of increased complexity.