Difference between revisions of "SQL Server - OpenKM 6.2"

From OpenKM Documentation
Jump to: navigation, search
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

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


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


Nota clasica.png 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.


Mssql1.jpg


Select your appropiate database collate.


Mssql2.jpg