[hibernate-issues] [Hibernate-JIRA] Created: (HHH-7232) Hibernate ignores 'schema' attribute of @SequenceGenerator for Oracle sequences

[Scott Van Wart (JIRA)]

Hibernate ignores 'schema' attribute of @SequenceGenerator for Oracle sequences
-------------------------------------------------------------------------------

                 Key: HHH-7232
                 URL: https://hibernate.onjira.com/browse/HHH-7232
             Project: Hibernate ORM
          Issue Type: Bug
          Components: annotations
    Affects Versions: 4.1.2
         Environment: Hibernate 4.1.2.Final, Oracle 11gR2

            Reporter: Scott Van Wart


I wrote a mapping for a sequence such as:

@SequenceGenerator( schema="jaseadm", name="applicantSignupSequence", sequenceName="seq_applicant_signup" )

And the generated SQL is as follows:

DEBUG org.hibernate.SQL - select seq_applicant_signup.nextval from dual

Which leads to this:

WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 2289, SQLState: 42000
ERROR o.h.e.jdbc.spi.SqlExceptionHelper - ORA-02289: sequence does not exist


--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira