Difference between revisions of "SQL Server - OpenKM 6.2"
From OpenKM Documentation
| Line 7: | Line 7: | ||
{{Note|'''OpenKM 6.2''' has been verified to run with '''SQL Server 2005''' using the JDBC driver '''sqljdbc4.jar''' under tomcat-7.0.27}} | {{Note|'''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]]. | ||
| + | |||
| + | <source lang="java"> | ||
| + | hibernate.dialect=org.hibernate.dialect.SQLServerDialect | ||
| + | hibernate.hbm2ddl=create | ||
| + | </source> | ||
| + | |||
| + | More info about this at: | ||
| + | * [http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-optional-dialects Hibernate: SQL Dialects] | ||
| + | |||
| + | == Database creation == | ||
| + | Starting with OpenKM 6.0, only one databases is needed: | ||
| + | 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 two databases. | ||
| + | |||
| + | |||
| + | [[file:Mssql1.jpg|center]] | ||
| + | |||
| + | |||
| + | Select your appropiate database collate. | ||
| + | |||
| + | |||
| + | [[file:Mssql2.jpg|center]] | ||
[[Category: Installation Guide]] | [[Category: Installation Guide]] | ||
Revision as of 09:35, 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 two databases.
Select your appropiate database collate.
