Skip navigation.
Downloads | Product Documentation | Support

Administration Console Online Help

# JDBC Data Source: Monitoring: Testing

Buttons Column Display Related Tasks Related Topics

Use this page to test database connections in this JDBC data source.

When you test a database connection, WebLogic Server reserves a connection from the data source, runs the query as defined in Test Table Name, and then returns the connection to the pool in the data source.

Note:
  Connection testing relies on testing options that you configure on the Data Source > Configuration > Connection Pool page. You must select Test Connections on Reserve and specify a table name or SQL query in Test Table Name.

#### Buttons

Name | Description
--- | ---
Test Data Source | Tests a connection from the selected data source instance using the query defined in Test Table Name on the Data Source > Configuration > Connection Pool page. Also requires that Test Connections On Reserve is selected. MBean Attribute: `JDBCDataSourceRuntimeMBean.testPool`

#### Column Display

You can show fewer or additional data points on this page by expanding Customize this table and modifying the Column Display list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

Name | Description
--- | ---
Server | The server on which the data source instance is deployed.
State | The current state of the data source. Possible states are: `Running` - the data source is enabled (deployed and not SUSPENDED). This is the normal state of the data source. `Suspended` - the data source has been manually disabled. `Shutdown` - the data source is shutdown and all database connections have been closed. `Unhealthy` - all connections are unavailable (not because they are in use). This state occurs if the database server is unavailable when the data source is created (creation retry must be enabled) or if all connections have failed connection tests (on creation, on reserve, or periodic testing). `Unknown` - the data source state is unknown. MBean Attribute: `JDBCDataSourceRuntimeMBean.State`

Related Tasks

- Test JDBC data sources
- Configure testing options for a JDBC data source

Related Topics

- Configuring JDBC Data Sources