Apache Tomcat 5.5.x
SQL Server 2008
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.
How do I resolve this problem?
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:
- Download the JDBC 4.0 driver from the Microsoft website and extract the file to a local directory.
- Rename the original sqljdbc.jar file inside that folder to sqljdbc2.jar
- Rename the sqljdbc4.jar file inside that folder to sqljdbc.jar
- Copy the sqljdbc.jar file to the %CATALINAHOME%\webapps\harweb\WEB-INF\lib folder REPLACING the copy that was originally there.
- Restart Tomcat.