Configuring data source testing
Database connections that are pooled can be configured to be tested by WebLogic as part of the managed-connection lifecycle. This recipe will show you how to configure testing of connections.
Getting ready
For this recipe, 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…
By following the steps given here, we can configure data-source testing:
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 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 in Domain Configurations, select Data Sources
In the...