bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

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