Upgrading To Crowd 1.3x Fails On PostgreSQL Database
症状
Upgrading to Crowd 1.3x using PostgreSQL database fails with error;
main ERROR [hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata
org.postgresql.util.PSQLException: ERROR: relation "information_schema.system_sequences" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1575)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1324)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:190)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
原因
Crowd isn't configured to use the correct PostgreSQL Dialect.
ソリューション
Update file crowd-openidserver-webapp/WEB-INF/classes/jdbc.properties with the correct database dialect.
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
最終更新日 2012 年 11 月 21 日
Powered by Confluence and Scroll Viewport.