OTN Home > Oracle WebLogic Server 10.3.1 Documentation > Administration Console Online Help > Test JDBC data sources

Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Test JDBC data sources


In the Administration Console, you can manually test individual instances of a data source. When you test a data source, WebLogic Server reserves a connection from the data source, tests it using the standard testing query or the query specified in Test Table Name, and then returns the database connection to the pool of connections. Test results are displayed at the top of the page in the Administration Console.

The manual connection test relies on the Test Reserved Connections and Test Table Name attributes of the data source. Those attributes are set by default. However, if you changed either attribute, the changes will affect the database connection test.

To test a JDBC data source:

  1. If you have not already configured testing options for the data source, see Configure testing options for a JDBC data source and configure options for Test Reserved Connections and Test Table Name.
  2. In the Domain Structure tree, expand Services > JDBC, then select Data Sources.
  3. On the Summary of Data Sources page, click the data source name.
  4. Select the Monitoring: Testing tab.
  5. On the Testing page, select the instance of the data source that you want to test.

    Date source instances are listed by the server on which they are deployed.

  6. Click the Test Table Name button. Test results are displayed at the top of the page.

Back to Top