Oracle Database Problem Solving and Troubleshooting Handbook

20. Dealing with XA Distributed Transaction Issues

In today’s complex Oracle database environments, it is not uncommon to encounter database application architectures that leverage Java components that connect to two or more different databases using connection pools and require processing a single transaction in a coordinated fashion. This multiconnection, multidatabase transaction processing method is typically known as a distributed transaction, but it is sometimes also termed a global transaction or XA (short for X/Open XA). The concept of distributed transactions is not particularly new—it was created back in 1991—but as Java has come to the fore as an application language in recent years, the use of distributed transactions has accelerated ...