AW: [opencms-dev] Using Microsoft's JDBC drivers...

[Kindlieb Tobias]

Hi,

Here's the section in the properties file:

change the parts:

- pool.mssql.driver
- pool.mssql.url

three times:

# Parameters for the mssql connection-pool
# pool.mssql.driver = sun.jdbc.odbc.JdbcOdbcDriver
# pool.mssql.url = jdbc:odbc:datasourcename
# pool.mssql.driver = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
# pool.mssql.url = jdbc:merant:sqlserver://sqlserver:1433
pool.mssql.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
pool.mssql.url=jdbc:microsoft:sqlserver://10.73.1.101:1433
pool.mssql.user=opencms
pool.mssql.password=opencms
pool.mssql.minConn=10
pool.mssql.maxConn=20
pool.mssql.increaseRate=5
pool.mssql.timeout=120
pool.mssql.maxage=360

# Parameters for the online connection-pool
# pool.mssqlonline.driver = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
# pool.mssqlonline.url = jdbc:merant:sqlserver://sqlserver:1433
pool.mssqlonline.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
pool.mssqlonline.url=jdbc:microsoft:sqlserver://10.73.1.101:1433
pool.mssqlonline.user=opencms
pool.mssqlonline.password=opencms
pool.mssqlonline.minConn=5
pool.mssqlonline.maxConn=10
pool.mssqlonline.increaseRate=5
pool.mssqlonline.timeout=120
pool.mssqlonline.maxage=360

# Parameters for the backup connection-pool
# pool.mssqlbackup.driver = com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
# pool.mssqlbackup.url = jdbc:merant:sqlserver://sqlserver:1433
pool.mssqlbackup.driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
pool.mssqlbackup.url=jdbc:microsoft:sqlserver://10.73.1.101:1433
pool.mssqlbackup.user=opencms
pool.mssqlbackup.password=opencms
pool.mssqlbackup.minConn=5
pool.mssqlbackup.maxConn=10
pool.mssqlbackup.increaseRate=5
pool.mssqlbackup.timeout=120
pool.mssqlbackup.maxage=360

don't forget to put the three jar files in the lib directory:
msutil.jar, mssqlserver.jar, msbase.jar

Regards, Tobias Kindlieb

-----Ursprüngliche Nachricht-----
Von: Ainhoa Llorente Coto [mailto:allorente at robotiker.es] 
Gesendet: Dienstag, 7. Januar 2003 11:50
An: opencms-dev at www.opencms.org
Betreff: [opencms-dev] Using Microsoft's JDBC drivers... 

Can anybody tell me which are the exact entries that must be changed in the
opencms.properties file to point to the microsoft classes??
Thank you very much
Ainhoa