Uploaded image for project: 'Hibernate ORM'
  1. Hibernate ORM
  2. HHH-7232

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Out of Date
    • Affects Version/s: 4.1.2, 4.3.6
    • Fix Version/s: None
    • Component/s: hibernate-core
    • Environment:
      Hibernate 4.1.2.Final, Oracle 11gR2
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true

      Description

      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

        Attachments

          Activity

            People

            • Votes:
              8 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: