PostgreSQL - ERROR o.h.tool.hbm2ddl.SchemaUpdate - could not complete schema update
Symptons
When upgrade the application is shown in the terminal the error:
2019-09-20 17:45:58,806 [RMI TCP Connection(4)-127.0.0.1] ERROR o.h.tool.hbm2ddl.SchemaUpdate - could not complete schema updateCause
In PostgreSQL version 9.6 has been changed some tables and columns information about the schema.
More information at https://github.com/rundeck/rundeck/issues/2354
Resolution
- Stop OpenKM
- Replace the driver in $TOMCAT_HOME/libs for a more updated version
- Edit OpenKM.cfg and set the hbm2ddl parameter to update.
- Start OpenKM
More information about PostgreSQL JDBC drivers at https://jdbc.postgresql.org/download.html
Choose the right driver version. For example for PostgreSQL 10.10 with JAVA JDK version 1.8, you can use PostgreSQL JDBC 4.2 Driver, 42.2.8.
Properties
| Properties | |
|---|---|
|
Date |
2019-09-20 |
|
Applies to |
|
Keywords
- AllVersions