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

QuotedIdentifierTest fails with ORA-04043 on Oracle12c

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: 5.3.3
    • Fix versions: 5.3.4, 5.4.0.CR1
    • Components: testsuite
    • Labels:
    • Environment:
      Oracle12c
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • backPortable:
      Backport?
    • Last commented by a user?:
      true
    • Sprint:

      Description

      org.hibernate.id.QuotedIdentifierTest

      11:48:09,985 DEBUG SQL:94 - 
          
          create table "table" (
             "index" number(10,0) generated as identity,
              "from" varchar2(255 char),
              "timestamp" number(19,0),
              primary key ("index")
          )
      Hibernate: 
          
          create table "table" (
             "index" number(10,0) generated as identity,
              "from" varchar2(255 char),
              "timestamp" number(19,0),
              primary key ("index")
          )
      ....
      ....
      11:48:10,049 DEBUG SQL:94 - 
          insert 
          into
              "table"
              ("from", "timestamp") 
          values
              (?, ?)
      Hibernate: 
          insert 
          into
              "table"
              ("from", "timestamp") 
          values
              (?, ?)
      11:48:10,051  WARN SqlExceptionHelper:137 - SQL Error: 4043, SQLState: 42000
      11:48:10,051 ERROR SqlExceptionHelper:142 - ORA-04043: object "TABLE" does not exist
      

      I'm not sure how accurate the logging is, but when I try these queries in standalone SQL client, both work.

      I tried changing table name to uppercase but it doesn't work. Also I tried to set physical naming strategy but with no success.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: