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.
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.
Follow the steps given here to tune XA timeouts: