SQL Server - OpenKM 6.2

Download SQL Server JDBC driver from Miscrosof SQL Server Driver Page and move it to $TOMCAT_HOME/lib

Other JDBC driver for MS SQLServer we've tested is jdts.

OpenKM 6.2 has been verified to run with SQL Server 2005 using the JDBC driver sqljdbc4.jar under tomcat-7.0.27

In this OpenKM release you can create the databases automatically configuring the hibernate.dialect and hibernate.hbm2ddl properties in OpenKM.cfg.

hibernate.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.hbm2ddl=create

More info about this at:

• Hibernate: SQL Dialects

Database creation

Starting with OpenKM 6.0, only one databases is needed:

okm_repo

Start SQL Server Management Studio Express and create the two databases.

Select your appropiate database collate.