[opencms-dev] SQL Server

[Andras Balogh]

    Hello Bernat,

Try to define your own pool, not name it mssql but ex. 'mypool':
pool.mypool.driver=
pool.mypool.url=
pool.mypool.user=
pool.mypool.password=
pool.mypool.minConn=
pool.mypool.maxConn=
pool.mypool.increaseRate=
pool.mypool.timeout=
pool.mypool.maxage=

    This should put after the other pool defintions in opencms.properties
and refer from code as  "jdbc:opencmspool:mypool"

Hope it works, i have  mssql for both OpenCms and mypool.

Best wishes,
Andras.


Bernat López wrote:

>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
>  
>