Difference between revisions of "SQL Server - OpenKM 6.2"
From OpenKM Documentation
| Line 21: | Line 21: | ||
okm_repo | okm_repo | ||
| − | [http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en Start SQL Server Management Studio Express] and create the | + | [http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en Start SQL Server Management Studio Express] and create the database. |
Revision as of 09:37, 5 September 2013
Contents |
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:
Database creation
Starting with OpenKM 6.0, only one databases is needed:
okm_repo
Start SQL Server Management Studio Express and create the database.
Select your appropiate database collate.
