Difference between revisions of "Using OpenKM with other databases"
From OpenKM Documentation
| Line 1: | Line 1: | ||
By default, OpenKM uses an embedded database called [http://hsqldb.org/ HSQLDB]. This database is integrated into JBoss and offers a good performance and low hardware requirements. But sometimes it not enough for some users and need OpenKM to be deployed within their IT structure, which is based on any other database vendor. | By default, OpenKM uses an embedded database called [http://hsqldb.org/ HSQLDB]. This database is integrated into JBoss and offers a good performance and low hardware requirements. But sometimes it not enough for some users and need OpenKM to be deployed within their IT structure, which is based on any other database vendor. | ||
| + | |||
| + | Startign with OpenKM 5, 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.HSQLDialect | ||
| + | hibernate.hbm2ddl=create | ||
| + | </source> | ||
| + | |||
| + | Once the tables are created, change the '''hibernate.hbm2ddl''' property from ''create'' to ''none''. | ||
| + | |||
| + | {{Warning|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.}} | ||
Here we will discuss the changes needed to run OpenKM with these databases: | Here we will discuss the changes needed to run OpenKM with these databases: | ||
Revision as of 10:01, 5 October 2010
By default, OpenKM uses an embedded database called HSQLDB. This database is integrated into JBoss and offers a good performance and low hardware requirements. But sometimes it not enough for some users and need OpenKM to be deployed within their IT structure, which is based on any other database vendor.
Startign with OpenKM 5, you can create the databases automatically configuring the hibernate.dialect and hibernate.hbm2ddl properties in OpenKM.cfg.
hibernate.dialect=org.hibernate.dialect.HSQLDialect
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. |
Here we will discuss the changes needed to run OpenKM with these databases:
