Tuning database XA timeouts
Database connections that are pooled can be configured to enable distributed transactions, with an associated timeout if other resources in the transaction do not complete in time. This recipe will show you how to set and configure this.
Getting ready
You will need to have Oracle SOA Suite 11g installed on a server as we'll be accessing the default data source used by SOA Suite.
We'll set XA timeouts on the default SOA datasource.
How to do it…
Follow the steps given here to tune XA timeouts:
Open the SOA Suite WebLogic administration console and log in as an administrator. If you have issues locating the console, see steps 1 and 2 in the Tuning global transactions recipe in Chapter 6, Platform Tuning.
Navigate to the Data Sources section by performing either of the following actions:
Click on the Data Sources link under the Services drop-down list in the Domain Structure box located on the left of the screen
In the Home Page box in the center of the screen, under Services...
