ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error starting Harweb: JRE 1.6 is not supported by this driver. Use the sqljdbc4.jar class library.

book

Article ID: 49408

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Description:

Environment is:
Java 1.6.x
Apache Tomcat 5.5.x
SQL Server 2008
SCM 12.1.x

Installation of Harweb was successful but when trying to start Tomcat after installation I get this error:

SEVERE: 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. java.lang.UnsupportedOperationException: 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.

at com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304)
...

How do I resolve this problem?

Solution:

During installation of Harweb, the sqljdbc.jar file from your SQL Server JDBC install directory is copied to %CATALINAHOME%\webapps\harweb\WEB-INF\lib. The file that was originally named sqljdbc.jar is the JDBC 2.0 driver. To provide the JDBC 4.0 driver to Harweb, do the following:

  1. Download the JDBC 4.0 driver from the Microsoft website and extract the file to a local directory.
  2. Rename the original sqljdbc.jar file inside that folder to sqljdbc2.jar
  3. Rename the sqljdbc4.jar file inside that folder to sqljdbc.jar
  4. Copy the sqljdbc.jar file to the %CATALINAHOME%\webapps\harweb\WEB-INF\lib folder REPLACING the copy that was originally there.
  5. Restart Tomcat.

Environment

Release: SCMNCR99000-12.1-Harvest-Software Change Manager-Named User-Competitive Replacem
Component:
Powered by Wolken Software