Administration Console Online Help
|
JDBC Connection Pool --> Configuration --> Testing
Tasks Additional Documentation Attributes
Overview
In the JDBC Connection Pool—>Configuration—>Testing tab, you specify options for testing the JDBC connections in a connection pool.
A connection pool contains a group of JDBC connections that are created when the connection pool is registered, usually when starting up WebLogic Server. Your application borrows a connection from the connection pool, uses it, then returns it to the connection pool by closing it.
Tasks
Creating and Configuring a JDBC Connection Pool
Assigning a JDBC Connection Pool to One or More Servers or Clusters
Cloning a JDBC Connection Pool
Monitoring Connections in a JDBC Connection Pool
Deleting a JDBC Connection Pool
Additional Documentation
(Requires an Internet connection.)
Managing JDBC Connectivity in the WebLogic Server Administration Guide
Introduction to WebLogic JDBC in Programming WebLogic JDBC
Configuring WebLogic JDBC Features in Programming WebLogic JDBC
Third-Party Driver Configuration and Performance Requirements in Programming WebLogic JTA
Attributes
Attribute Label
|
Description
|
Value Constraints
|
Test Table Name
|
The name of the table used when testing a physical database connection. The default SQL code used to test a connection is
"select count(*) from TestTableName"
The TestTableName must exist and be accessible to the database user for the connection. Most database servers optimize this SQL to avoid a table scan, but it is still a good idea to set TestTableName to the name of a table that is known to have few rows, or even no rows.
If TestTableName begins with "SQL ", then the rest of the string following that leading token will be taken as a literal sql statement that will be used to test a connection.
MBean: weblogic.management. configuration. JDBCConnectionPoolMBean
Attribute: TestTableName
|
Configurable: yes
Readable: yes
Writable: yes
|
Test Reserved Connections
|
When set to true, WebLogic Server tests a connection before giving it to the client. The test adds a small delay in serving the client's request for a connection from the pool, but ensures that the client receives a working connection (assuming that the DBMS is available and accessible).
MBean: weblogic.management. configuration. JDBCConnectionPoolMBean
Attribute: TestConnectionsOnReserve
|
Default: false
Configurable: yes
Readable: yes
Writable: yes
|
Test Released Connections
|
When set to true, WebLogic Server tests a connection before returning it to the connection pool. If all connections in the pool are already in use and a client is waiting for a connection, the client's wait will be slightly longer while the connection is tested.
MBean: weblogic.management. configuration. JDBCConnectionPoolMBean
Attribute: TestConnectionsOnRelease
|
Default: false
Configurable: yes
Readable: yes
Writable: yes
|