[opencms-dev] SQL Server

[Bernat López]

Hi,

We are using OpenCMS on a MySQL database and now we want to test our modules on SQL Server.
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.
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.

But, once I've restarted Tomcat when I open some JSP file of module appears me the follow error on stdout.log : 
java.lang.NullPointerException
     at java.lang.Class.forName0(Native Method)
     at java.lang.Class.forName(Class.java:140)
     at com.opencms.dbpool.CmsPool.<init>(CmsPool.java:111)
     at com.opencms.dbpool.CmsPool.<init>(CmsPool.java:149)
     at com.opencms.dbpool.CmsDriver.createPool(CmsDriver.java:214)
     at com.opencms.dbpool.CmsDriver.getPool(CmsDriver.java:188)
     at com.opencms.dbpool.CmsDriver.connect(CmsDriver.java:107)
     at java.sql.DriverManager.getConnection(DriverManager.java:512)
     at java.sql.DriverManager.getConnection(DriverManager.java:193)
     at com.mymodule.myclass.mymethod(myclass.java:475)

Can anybody help me??

Regards,

Bernat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040512/5aa9e1dd/attachment.htm>