Difference between revisions of "Other DBMS"
From OpenKM Documentation
(Created page with '{{TOCright}} __TOC__ OpenKM uses lucene that means can be installed on major DBMS. By default OpenKM community tested DBMS are MySQL and PostgreSQL. In the OpenKM [http:…') |
|||
| Line 2: | Line 2: | ||
OpenKM uses lucene that means can be installed on major DBMS. By default OpenKM community tested DBMS are [[MySQL]] and [[PostgreSQL]]. In the OpenKM [http://www.openkm.com/en/overview/comparison-of-versions.html comparasion matrix] can see other DBMS tested at OpenKM professional version | OpenKM uses lucene that means can be installed on major DBMS. By default OpenKM community tested DBMS are [[MySQL]] and [[PostgreSQL]]. In the OpenKM [http://www.openkm.com/en/overview/comparison-of-versions.html comparasion matrix] can see other DBMS tested at OpenKM professional version | ||
| + | |||
| + | == Test in other DBMS == | ||
| + | First you should know which is your hibernate dialect. For info about this take a look at [http://docs.jboss.org/hibernate/core/3.3/reference/en/html/session-configuration.html#configuration-optional-dialects Hibernate: SQL Dialects] | ||
To create the databases automatically configuring the '''hibernate.dialect''' and '''hibernate.hbm2ddl''' properties in [[OpenKM.cfg]]. | To create the databases automatically configuring the '''hibernate.dialect''' and '''hibernate.hbm2ddl''' properties in [[OpenKM.cfg]]. | ||
| Line 11: | Line 14: | ||
Once the tables are created, OpenKM will automatically change the '''hibernate.hbm2ddl''' property from ''create'' to ''none''. | Once the tables are created, OpenKM will automatically change the '''hibernate.hbm2ddl''' property from ''create'' to ''none''. | ||
| + | |||
| + | {{Note|Is possible depending your DBMS should be needed to make some minimal optimization in source code. Refer to [[Developer_Guide]]}} | ||
{{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.}} | {{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.}} | ||
| − | |||
| − | |||
[[Category: Installation Guide]] | [[Category: Installation Guide]] | ||
Revision as of 12:13, 24 October 2012
Contents |
OpenKM uses lucene that means can be installed on major DBMS. By default OpenKM community tested DBMS are MySQL and PostgreSQL. In the OpenKM comparasion matrix can see other DBMS tested at OpenKM professional version
Test in other DBMS
First you should know which is your hibernate dialect. For info about this take a look at Hibernate: SQL Dialects
To create the databases automatically configuring the hibernate.dialect and hibernate.hbm2ddl properties in OpenKM.cfg.
hibernate.dialect=org.hibernate.dialect.SomeDialect
hibernate.hbm2ddl=create
Once the tables are created, OpenKM will automatically change the hibernate.hbm2ddl property from create to none.
 |
Is possible depending your DBMS should be needed to make some minimal optimization in source code. Refer to Developer_Guide |
 |
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. |
