<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4712.0">
<TITLE>ClassNotFoundException: OpenCms and the MS SQL JDBC driver</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=1 FACE="Courier New">Hi,</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">I’ve got a problem with OpenCms and the MS SQL JDBC driver. I changed the opencms.properties file to use the Microsoft JDBC driver, but I still get an exception:</FONT></P>
<P><FONT SIZE=1 FACE="Courier New">Error while loading driver: [com.microsoft.jdbc.sqlserver.SQLServerDriver, com.microsoft.jdbc.sqlserver.SQLServerDriver]</FONT></P>
<P><FONT SIZE=1 FACE="Courier New">java.lang.ClassNotFoundException: [com/microsoft/jdbc/sqlserver/SQLServerDriver, com/microsoft/jdbc/sqlserver/SQLServerDriver]</FONT></P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
<BR><FONT SIZE=1 FACE="Courier New">java.lang.NullPointerException</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
<BR><FONT SIZE=1 FACE="Courier New">java.lang.NullPointerException</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
<BR><FONT SIZE=1 FACE="Courier New">java.lang.NullPointerException</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
<BR><FONT SIZE=1 FACE="Courier New">java.lang.NullPointerException</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
<BR><FONT SIZE=1 FACE="Courier New">java.lang.NullPointerException</FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">-------------------------------------------</FONT>
</P>
<BR>
<P><FONT SIZE=1 FACE="Courier New">I've tried a couple of different ways to get OpenCMS to find the Microsoft driver, e.g. placed the jar files in JAVA_HOME/jre/lib/ext/ directory and altered the environment variable CLASSPATH to include the jar files. I modified the Tomcat shortcut to include the classpath (-Djava.class.path), but nothing worked.</FONT></P>
<P><FONT SIZE=1 FACE="Courier New">In one article I read, that the query.property file could be the troublemaker. </FONT>
</P>
<P><FONT SIZE=1 FACE="Courier New">Any suggestions? </FONT>
</P>
<BR>
<P><FONT SIZE=1 FACE="Courier New">Thanks,</FONT>
<BR><FONT SIZE=1 FACE="Courier New">Tom</FONT>
</P>
<BR>
<P><FONT SIZE=1 FACE="Courier New">PS: Beside that, I used MySQL with my first test installation and it was fine!</FONT>
</P>
<BR>
<CODE><FONT SIZE=3><BR>
<BR>
**********************************************************************<BR>
IMPORTANT<BR>
<BR>
This email and any attachments transmitted with it are confidential. If you are not the intended recipient or person responsible for delivering the email to the intended recipient, you are prohibited from disclosing, copying or using the information contained in it. If you have received this email in error, please inform us by email reply and delete the message and attachments. <BR>
<BR>
Before opening or using attachments, check them for viruses and defects.<BR>
<BR>
**********************************************************************<BR>
</FONT></CODE>
</BODY>
</HTML>