Please reopen, this issue still occur with Hibernate 4.1.11.Final (with PostgreSql in my case, but this is not related to a specific database).
In DatabaseMetadata, sequences HashSet still use unqualified sequence name, so if you have 2 applications using each their own schema (quite common) : schema1 and schema2, the first one will work as expected but the second one will fail because schema1.hibernate_sequence will be processed as hibernate_sequence, so schema2.hibernate_sequence will never be created.
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Please reopen, this issue still occur with Hibernate 4.1.11.Final (with PostgreSql in my case, but this is not related to a specific database).
In DatabaseMetadata, sequences HashSet still use unqualified sequence name, so if you have 2 applications using each their own schema (quite common) : schema1 and schema2, the first one will work as expected but the second one will fail because schema1.hibernate_sequence will be processed as hibernate_sequence, so schema2.hibernate_sequence will never be created.