Skip navigation.

Administration Console Online Help

PreviousNextvertical dots separating previous/next from contents/index/pdfContents

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

Related Topics

 

Skip navigation bar   Back to Top