[TechNote] How to interpret SQLException due to "The application server rejected establishment of the connection."

How to interpret SQLException due to "The application server rejected establishment of the connection."

Technote (troubleshooting)

Problem(Abstract)

This technote describes how to address the cause of the error described below.

Symptom

When testing the connection to a database server, you get the following error:

Test connection failed for data source TMTPDataSource on server server1 at node mercutioNode01 with the following exception:
java.lang.Exception: java.sql.SQLException:
The application server rejected establishment of the connection.
An attempt was made to access a database, tmtp, which was not found.
DB2ConnectionCorrelator: nullDSRA0010E: SQL State = 08004, Error Code = -4,499. View JVM logs for further details.

Cause

This means that the connection could not be established due to the SQLState and Error Code. SQLState = 80004 and Error Code = -4,499 means that the database name is not a database name recognized by the database server. The fully qualified database name on the server is schemaName.tableName where the schemaName is the schema that the table was created with.

Diagnosing the problem

Check the schema name and database name of the table that is specified in the data source configuration. If no schema name is specified, the userid for the database connection will be used as the schema name. The combination of the schema name and table name must match what was used on the DB2® server to create the table.

Resolving the problem

The solution for this problem is to correct the database name in the IBM® WebSphere® Application Server data source configuration.