How to correctly use Microsoft SQL Server JDBC driver for WebSphere JDBC adapter under WebSphere Integration Developer V6.2 and WebSphere Process Server V6.2 environment

Technote (troubleshooting)


Problem(Abstract)

How to correctly use Microsoft SQL Server JDBC driver for WebSphere JDBC adapter under WebSphere Integration Developer V6.2 and WebSphere Process Server V6.2 environment

Symptom

While running external service wizard for WebSphere JDBC adapter to connect to Microsoft SQL Server by using SQL Server JDBC Driver 2.0, the following error is encountered:

The resource adapter named 'IBM WebSphere Adapter for JDBC' returned the following error: 'Failure in connection to EIS Java™ Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.'



Cause

WebSphere Integration Developer V6.2 runs on JRE 6.0 and WebSphere Process Server V6.2 runs on JRE 5.0. In SQL Server JDBC Driver 2.0, these limitations exist:

1. sqljdbc.jar requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 will throw an exception when connecting to a database.
2. sqljdbc4.jar class library requires a Java Runtime Environment (JRE) of version 6.0 or later. Using sqljdbc4.jar on JRE 1.4 or 5.0 will throw an exception.

Because of the above limitations, sqljdbc.jar could not be used in WebSphere Integration Developer environment but it could work well in WebSphere Process Server V6.2 environment. And sqljdbc4.jar could work well in WebSphere Integration Developer environment, but it could not be used in WebSphere Process Server V6.2 environment. So SQL Server JDBC Driver 2.0 could not work well in both WebSphere Integration Developer V6.2 and WebSphere Process Server V6.2 environments.


Resolving the problem

MS SQL Server 2005 JDBC Driver 1.2 does not have the above limitations and could work well in both WebSphere Integration Developer V6.2 and WebSphere Process Server V6.2 environments. Because all existing functions of JDBC adapter are developed based on JDBC 2.0, the JDBC adapter will not lose its function when the adapter does not use SQL Server JDBC Driver 2.0 which is JDBC 4.0 compliant. Please download the JDBC driver from Microsoft download center.

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Adapters
Adapter for JDBC

Software version:

6.2

Operating system(s):

Windows

Software edition:

WebSphere

Reference #:

1408978

Modified date:

2010-09-24

Translate my page

Machine Translation

Content navigation