WAS v8.5 > Administer applications and their environment > Welcome to administering Data access resources > Administer data access applications > Configure a JDBC provider and data sourceTesting a connection with the dmgr console
After we have defined and saved a data source, we can click the Test Connection button to ensure the parameters in the data source definition are correct.
For cluster scope, restart the node agent before testing.
We can select multiple data sources on the data source collection page and test them as a group. Be sure the following conditions are met before using the Test Connection button:
- If you are testing a connection using a WebSphere Application Server Version 4.0 type of data source, ensure the user and password information is set.
- Designate variables appropriately.
If we used a WebSphere environment entry for the class path or other fields, such as ${DB2_JDBC_DRIVER_PATH}/db2java.zip, verify you assign it a value in the WebSphere Variables page.
- Restart the application server after you define or edit WebSphere variables.
- Restart the application server after you create or edit an authentication alias for the data source.
- We can now test a connection to the data source. On the data source collection page in the dmgr console, select the data source and click Test Connection .
A Test Connection operation can have three different outcomes, each resulting in a different message being displayed in the messages panel of the page on which you press the Test Connection button.
- The test can complete successfully, meaning that a connection is successfully obtained to the database using the configured data source parameters. The resulting message states: Test Connection for data source DataSourceName on process ProcessName at node NodeName was successful.
- The test can complete successfully with warnings. This means that while a connection is successfully obtained to the database, warnings were issued. The resulting message states: Test Connection for data source DataSourceName on process ProcessName at node NodeName was successful with warnings. View the JVM Logs for more details.
The View the JVM Logs text is a hyperlink that takes you to the JVM Logs console screen for the process.
- The test can fail. A connection to the database with the configured parameters is not obtained. The resulting message states: Test Connection failed for data source DataSourceName on process ProcessName at node NodeName with the following exception: ExceptionText. View the JVM Logs for more details.
Again, the text for View the JVM Logs is a hyperlink to the appropriate logs screen.
Related concepts:
Test connection service
Related
Testing a connection using wsadmin