CODEWITHSUNDEEP
postgresqlhibernatehbm2ddl
firstpostcommenter
firstpostcommenter

Reputation: 2911

all_sequences table/relation not found?

I am not able to query the "all_sequences" table in my database.

Do I need to give any grants to the owner/userID to resolve this issue?

Due to this issue, During server startup I get the below error from hibernate.hbm2ddl.auto validate:

ERROR o.h.tool.hbm2ddl.SchemaValidator - HHH000300: Could not complete schema validation
org.postgresql.util.PSQLException: ERROR: relation "all_sequences" does not exist

Upvotes: 2

Views: 4595

Answers (1)

Mike-Bell
Mike-Bell

Reputation: 969

You should update your hibernate.cfg.xml with the following property:

<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>

Upvotes: 7

Related Questions