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