Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Performance Tuning Guide

- Previous: Use Lowest Cost Database Locking
- Next: Configure JDBC Resources as One-Phase Commit Resources

### Use XA-Capable Data Sources Only When Needed

When multiple database resources, connector resources or JMS resources are involved in one transaction, a distributed or global transaction needs to be performed. This requires XA capable resource managers and data sources. Use XA capable data sources, only when two or more data source are going to be involved in a transaction. If a database participates in some distributed transactions, but mostly in local or single database transactions, it is advisable to register two separate JDBC resources and use the appropriate resource in the application.

- Previous: Use Lowest Cost Database Locking
- Next: Configure JDBC Resources as One-Phase Commit Resources

- © 2010, Oracle Corporation and/or its affiliates