[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6205) Derby dialect does not query for existing sequences

Derby dialect does not query for existing sequences --------------------------------------------------- Key: HHH-6205 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6205 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.1 Reporter: Steve Jones Derby supports sequences from version 10.6, and Hibernate will create sequences for Derby. Currently Hibernate does not correctly upgrade a schema that contains a sequence since "getQuerySequencesString" returns null in "DerbyDialect". The dialect should be updated as follows to support schema upgrading with sequences for Derby: @Override public String getQuerySequencesString() { if ( supportsSequences() ) { return "select sequencename from sys.syssequences"; } else { return null; } } Currently the following error occurs due to the existing sequence not being found: ERROR X0Y68: Sequence 'HIBERNATE_SEQUENCE' already exists. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira