Testing the connection to the database

After you have created a data source and connection pool, and possibly set some custom properties, you can test the connection to your database.

Before you begin

You test the connection to the database from the WebSphere Integrated Solutions Console. Log in to the console as explained in Before you start: Opening the administration console.

In the Websphere Integrated Solutions Console, open Resources > JDBC > Data sources.
Select the check box next to the data source that you want to test and click Test connection.

The status of the connection is indicated at the top. For example:

The test connection operation for data source Rule Execution Server datasource
 on server server1 at node <NodeName> was successful.

Potential connection errors:

Java class ..com.ibm.db2.jcc is not found: Make sure that the jcc drivers class path is correctly set.
Null Userid is not supported — SQL ERRORCODE 4461: Authentication has failed.: Make sure that the JAAS-J2C Authentication credentials are correct.