JDBC Adapter does not connect to Microsoft SQL Server after database is restarted

Troubleshooting

Problem

When using the inbound process of a JDBC Adapter with a Microsoft SQL Server database, the JDBC Adapter is unable to re-establish connection with the database after Microsoft SQL Server is restarted.

Symptom

If the JDBC Adapter inbound process is configured to use a pre-defined data source to connect to a Microsoft SQL Server database, JDBC Adapter is unable to re-establish the connection with the database after Microsoft SQL Server is restarted. The following error is encountered at runtime:

J2CA0056I: The Connection Manager received a fatal connection error from the Resource
Adapter for resource jdbc/MSSQL. The exception which was received is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

Cause

The problem occurs because a stale connection is used by the data source to establish the database connection.

Resolving The Problem

Use Microsoft SQL Server JDBC Driver 3.0 to connect to the database when configuring JDBC Adapter to use a Microsoft SQL Server:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=21599

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0","Edition":"WebSphere","Line of Business":{"code":"","label":""}}]

Was this topic helpful?

Document Information

More support for:
WebSphere Adapters Family

Software version:
7.0

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
467585

Modified date:
15 June 2018

UID

swg21585540

IBM Support

Tips