Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# Configure testing options for a JDBC data source

You can set database connection testing options in a data source to make sure that the database connections remain healthy, which helps keep your applications running properly. For more information, see Configuring JDBC Data Sources

To configure testing options for a JDBC data source:

1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
2. In the Domain Structure tree, expand Services > JDBC, then select Data Sources.
3. On the Summary of Data Sources page, click the data source name.
4. Select the Configuration: Connection Pool tab.
5. Scroll down and click Advanced to show the advanced connection pool options.
6. Select one or more of the following options:
   - Test Frequency - Enable periodic background connection testing by entering the number of seconds between periodic tests.
   - Test Reserved Connections - Select this check box to test the database connection before giving it to your application when your application requests a connection form the data source.

   You can use these options to get the right mix of performance and fault tolerance for your system. Read more about these options in Advanced Configuration Options

7. In Test Table Name enter the name of a small table to use in a query to test database connections. The standard query is `select 1 from table_name`. If you prefer to use a different query as a connection test, enter `SQL` followed by a space and the SQL code you want to use to test database connections.
8. Optionally, in Seconds to Trust an Idle Pool Connection, enter the number of seconds within which, if the database connection has been used or tested, WebLogic Server will skip the connection test. This option can help reduce the overhead of connection testing and improve application performance.
9. Click Save.
10. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
    Not all changes take effect immediately—some require a restart (see Use the Change Center).