Getting error in new JDBC adapter connection (IS 8.2 version) using sql server 2005.

Hello Everyone,

My self mahesh here. I am new to webmethods. I am creating the JDBC adapter connection using sql server 2005. I already download the jdbc driver 4.0 jar files from microsoft website and copied to the “C:\SoftwareAG\IntegrationServer\lib\jars” location and I restart the IS server also. Then I try to click on Enable to"Yes" I am getting the below error.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource MySecondTest.SQLServerConnection:SQLServerConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
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.

Kindly help me some one on this issue.

Thanks and Regards
Mahesh

Nope, place the .zip or .jar file containing the
classes in the
Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\co
de\jars directory.

Restart Integration Server.
The server automatically adds the .zip or .jar libraries to its classpath after the restart.

Hi Mahesh C.,

as stated by the error message the driver version does not match the java version.
Can you provide the jar-file-name you have used?

Additionally provide the output of “java -version” for the JDK/JRE being used.
What is the Fix-Level of your JDBC -Adapter 6.5?

There is the possibility to update the java version from 1.6 to 1.7 for wM 8.2.
See UpdateManager under Infrastructure for details.
Read the accomanying readme very carefully to avoid any odd circumstances.
Also check Empower for the related KB-Article.

I agree with Mahesh K. about to where to place the jars.

I have checked the version of the Jars I have downloaded from Microsoft in February 2015:

Package Version from MS Knowledgebase: sqljdbc_4.1.5605.100

  • sqljdbc.jar Classfile Version x31 (Decimal 49)
  • sqljdbc4.jar Classfile Version x32 (Decimal 50)
  • sqljdbc41.jar Classfile Version x33 (Decimal 51)

The classfile version is indicating the Java version being required as minimum.

Regards,
Holger