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
To configure testing options for a JDBC data source:
If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
Domain Structure tree, expand
Services > JDBC, then select Data
Summary of Data Sources page, click the data
Configuration: Connection Pool tab.
Scroll down and
click Advanced to show the advanced connection
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
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.
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
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).