This article will guide you through the necessary steps to add SQL 2008 support to eHD

In order to user eHD with SQL 2008 you must change out your JDBC driver jar files manually. Attached to this article are the SQL Server 2008 JDBC driver .jar files for both Java 1.5 and Java 1.6.

Here are the steps to manually switch to the new version:

 

1. Shutdown Tomcat.

 

2. Remove the previous SQL Server jar file from the ehelpdesk webapp. In the WEB-INF/lib directory, remove the filed named "mssql-2005.jar".

 

3. Copy the new SQL Server jar file to the WEB-INF/lib directory. The file to copy depends on the Java version that will be used. The file names for the different Java versions are:

Java 1.5:

sqljdbc-2.0.1803.100_enu.jar

Java 1.6+:

sqljdbc4-2.0.1803.100_enu.jar

4. Start Tomcat.