Advantage of using XA drivers

[Gavi Raaghav]

What is the advantage of using XA drivers? Can a transaction be rolledback by calling setRollBackOnly() even if we are not using XA driver?
What a XA driver does can it be achieved using Stored procedure, if yes what are the disadvantages?

[Ulf Dittmer]

XA means "distributed transactions", i.e. transactions that span more than one database. Whether or not the code inside a transaction is a stored proc or not makes no difference.

[Roger Chung-Wee]

In part, the answer depends on the driver. For instance, using the WebLogic jDriver for Oracle in XA mode does not support DDL operations such as create/drop table or stored procedures. If you want to perform DDL operations, you need to define two different connection pools as follows:

- One non-XA connection pool that can be used for DDL operations.

- One XA connection pool that can be used for DML operations in distributed transactions.