Upgrading To Crowd 1.3x Fails On PostgreSQL Database

Related content

  • No related content found

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

  • No related content found
Powered by Confluence and Scroll Viewport.