Setting data source connection timeouts
WebLogic data sources' pools can be configured to prevent "leakage"—the process whereby connections are perceived as being in use when in reality the thread has stopped using it. Over time, this will cause the pool to be exhausted. In this case, it is said to have leaked connections!
This recipe will show how to configure WebLogic to mitigate against this scenario and reclaim these leaked connections.
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.
How to do it…
The following steps will allow us to set the data-source connection timeouts:
Open the SOA Suite WebLogic administration console and log in as 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...
