Difference between revisions of "SQL Server - OpenKM 5.0"
From OpenKM Documentation
(Created page with '{{TOCright}} __TOC__ Download MS SQLServer JDBC driver from [http://http://www.microsoft.com/spain/sql/technologies/jdbc/default.mspx MS SQLServer Home Page] and move it to ''$J…') |
|||
| Line 1: | Line 1: | ||
{{TOCright}} __TOC__ | {{TOCright}} __TOC__ | ||
| − | + | {{Note|This configuration has been tested with [http://www.microsoft.com/sqlserver/2005/en/us/default.aspx Microsoft SQL Server 2005] and [http://www.microsoft.com/sqlserver/2005/en/us/express.aspx Microsoft SQL Server 2005 express edition].}} | |
| + | Download MS SQLServer JDBC driver from [http://www.microsoft.com/spain/sql/technologies/jdbc/default.mspx MS SQLServer Home Page] and move it to ''$JBOSS_HOME/server/default/lib''. | ||
In this OpenKM release you can create the databases automatically configuring the '''hibernate.dialect''' and '''hibernate.hbm2ddl''' properties in '''OpenKM.cfg'''. | In this OpenKM release you can create the databases automatically configuring the '''hibernate.dialect''' and '''hibernate.hbm2ddl''' properties in '''OpenKM.cfg'''. | ||
| Line 23: | Line 24: | ||
okm_app | okm_app | ||
| − | Start SQL Server Management Studio and create the two databases | + | Start SQL Server Management Studio and create the two databases. Select your appropiate database collate. |
[[file:Mssql1.jpg|center]] | [[file:Mssql1.jpg|center]] | ||
| + | |||
[[file:Mssql2.jpg|center]] | [[file:Mssql2.jpg|center]] | ||
| + | |||
| + | == Solving some hibernate creation problems == | ||
| + | |||
[[Category: Installation Guide]] | [[Category: Installation Guide]] | ||
[[Category: OKM Network]] | [[Category: OKM Network]] | ||
Revision as of 14:49, 23 October 2010
 |
This configuration has been tested with Microsoft SQL Server 2005 and Microsoft SQL Server 2005 express edition. |
Download MS SQLServer JDBC driver from MS SQLServer Home Page and move it to $JBOSS_HOME/server/default/lib.
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
Once the tables are created, change the hibernate.hbm2ddl property from create to none.
 |
This configuration property should be set before the database creation. Once the database has been initialized don't modify it because can damage your installation. If your OpenKM installation has been already configured with another database (default one is an embedded one called HSQL) you can't switch to another database simply changing this property. |
More info about this at:
Database creation
Starting with OpenKM 5.0, only two databases are needed:
okm_repo okm_app
Start SQL Server Management Studio and create the two databases. Select your appropiate database collate.
