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

Apply "global quote identifier" to HBM processing

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.4
    • Fix Version/s: 4.3.0.Beta5
    • Component/s: metamodel
    • Labels:
      None
    • Last commented by a user?:
      true

      Description

      Table name is quoted correctly, but column name is not quoted.

      Manual clone of HHH-6521 Closed as unable to reopen or clone automatically.

      I am using PostgreSQLDialect, with PostgresSQL any unquoted name/identifier is converted to lowercase server side and then matched case sensitive against objects.

      If you have one or more uppercase characters you need to quote the name, just like you expect to need to quote if you use spaces in names/identifiers.

      hibernate.globally_quoted_identifiers=true

      Hibernate:
      select
      this_.userId as userId1_2_0_,
      this_.version as version2_2_0_,
      this_.whenCreated as whenCrea3_2_0_,
      this_.state as state4_2_0_,
      this_.whenStateChange as whenStat5_2_0_,
      this_.usernameSelectorId as username6_2_0_,
      this_.username as username7_2_0_,
      this_.passwordHash as password9_2_0_,
      this_.whenPasswordChange as whenPas12_2_0_,
      from
      "sec_UserCredential" this_
      where
      this_.usernameSelectorId=?
      and this_.username=?

        Attachments

          Issue links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: