---

JDBC Connection Pool --> Testing

Tasks     Related Topics     Attributes

 

Overview

In the JDBC Connection Pool - >Testing tab, you can test a JDBC connection in a connection pool on each server on which the connection pool is deployed.

When you test a connection pool, WebLogic Server reserves and releases a connection from the connection pool.

Note: To make the test more meaningful, make sure that Test Reserved Connections or Test Released Connections is selected on the Configuration - >Connections tab (under Advanced Options). If either of these options is selected, WebLogic Server not only reserves and releases a connection, but also tests the physical database connection. See Test Reserved Connections in Attributes.

 

Tasks

Testing a JDBC Connection Pool

Creating and Configuring a JDBC Connection Pool

Deploying a JDBC Connection Pool to One or More Servers or Clusters

Monitoring Connections in a JDBC Connection Pool

 

Related Topics

Configuring JDBC Connection Pools

Managing JDBC Connection Pools

 

Attributes

Server Name - The name of the server on which the connection pool is deployed. Click the Test Pool button for this server to test a connection from this instance of the connection pool.

Pool State - The current state of the instance of the connection pool: RUNNING, SUSPENDED, or UNAVAILABLE. Each instance of the connection is independent and contains its own physical database connections.

Test Pool - Click this button to test a connection from the selected instance of the connection pool. Make sure that Test Reserved Connections or Test Released Connections is selected on the Configuration - >Connections tab (under Advanced Options). Test results are displayed at the top of the pane.

Test pool on all servers - Click this button to test a connection from all instances of the connection pool. Test results are displayed at the top of the pane.