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

          Hide
          membersound member sound added a comment -

          I'm having the same issue in 4.3.10.Final.

          Show
          membersound member sound added a comment - I'm having the same issue in 4.3.10.Final.
          Hide
          steve Steve Ebersole added a comment -

          This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings.

          For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/

          Show
          steve Steve Ebersole added a comment - This bug report does not indicate that the reported issue affects version 5.x. Versions prior to 5.x are no longer maintained. It would be a great help to the Hibernate team and community for someone to verify that the reported issue still affects version 5.x. If so, please add the 5.x version that you verified with to the list of affected-versions and attach the (preferably SSCCE) test case you used to do the verification to the report; from there the issues will be looked at during our triage meetings. For details, see http://in.relation.to/2015/10/27/great-jira-cleanup-2015/
          Hide
          steve Steve Ebersole added a comment -

          As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.

          Show
          steve Steve Ebersole added a comment - As part of verifying that this issue affects 5.0, please just set the "Affects version". Leave the "verify-affects-5.0" label and leave the issue in "Awaiting Response" status; these are critical for us to be able to track these verifications and triage them. Thanks.
          Hide
          HubertBubert Hubert Łyczek added a comment -

          This issue does not affect version 5.x. Tested with 5.0.6.Final.

          Show
          HubertBubert Hubert Łyczek added a comment - This issue does not affect version 5.x. Tested with 5.0.6.Final.
          Hide
          steve Steve Ebersole added a comment -
          Show
          steve Steve Ebersole added a comment - Thanks Hubert Łyczek !

            People

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

              Dates

              • Created:
                Updated:
                Resolved: