[opencms-dev] SQL Server

[Andras Balogh]

    Hello,

    Did you switch the resource broker to mssql?
i.e. in opencms.properties (somwehere in the beginning of file):
resourcebroker=mssql

Hope it helps.

Best wishes,
Andras.



Bernat López wrote:

> 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