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

[Steve Jones (JIRA)]

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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira