<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>We are using OpenCMS on a MySQL
database and now we want to test our modules on SQL
Server.</FONT></DIV>
<DIV><FONT face=Arial size=2>Once established the connection parameter to the
database of the module to "jdbc:opencms:mssql". I've downloaded Microsoft SQL
Server 2000 Driver for JDBC; installed it and copied
"msbase.jar", "mssqlserver.jar" and "msutil.jar" to
[tomcat]/webapps/opencms/WEB-INF/lib dir.</FONT></DIV>
<DIV><FONT face=Arial size=2>Finally, I've modified "opencms.properties" file
setting "pool.mssql.driver" param as
"com.microsoft.jdbc.sqlserver.SQLServerDriver" and "pool.mssql.url" as our
jdbc connection string to the db.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But, once I've restarted Tomcat when I open some
JSP file of module appears me the follow error on stdout.log :
</FONT></DIV>
<DIV dir=ltr style="MARGIN-RIGHT: 0px"><FONT face=Arial
size=1>java.lang.NullPointerException<BR> at
java.lang.Class.forName0(Native Method)<BR> at
java.lang.Class.forName(Class.java:140)<BR> at
com.opencms.dbpool.CmsPool.<init>(CmsPool.java:111)<BR>
at
com.opencms.dbpool.CmsPool.<init>(CmsPool.java:149)<BR>
at
com.opencms.dbpool.CmsDriver.createPool(CmsDriver.java:214)<BR>
at
com.opencms.dbpool.CmsDriver.getPool(CmsDriver.java:188)<BR>
at
com.opencms.dbpool.CmsDriver.connect(CmsDriver.java:107)<BR>
at
java.sql.DriverManager.getConnection(DriverManager.java:512)<BR>
at
java.sql.DriverManager.getConnection(DriverManager.java:193)<BR>
at com.mymodule.myclass.mymethod(myclass.java:475)</FONT></DIV>
<DIV dir=ltr style="MARGIN-RIGHT: 0px"><FONT face=Arial
size=1></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can anybody help me??</FONT></DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Bernat</DIV></FONT></BODY></HTML>