[opencms-dev] SQL Server

[Bernat López]

Hi Andras,

if I change Resource Broker param on opencms.properties then all my openCMS
has to run on my mssql database, don't?
Is not possible to have simultaneous openCMS running on MySQL database and
my module querying to MsSQL database??

Thanks,

bernat

----- Original Message ----- 
From: "Andras Balogh" <andras at reea.net>
To: <opencms-dev at opencms.org>
Sent: Thursday, May 13, 2004 9:50 AM
Subject: Re: [opencms-dev] SQL Server


    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


_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev