Upgrading To Crowd 1.3x Fails On PostgreSQL Database

Related content

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

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)

Cause

Crowd isn't configured to use the correct PostgreSQL Dialect.

Resolution

Update file crowd-openidserver-webapp/WEB-INF/classes/jdbc.properties with the correct database dialect.


hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

Last modified on Nov 21, 2012

Was this helpful?

Yes
No
Provide feedback about this article

Related content

Powered by Confluence and Scroll Viewport.