Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2336

Relax Join column name comparison based on database dictionary schema case setting

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: None
    • Labels:
      None

      Description

      Name of join column name comparison should allow schema case set in database dictionary

        Activity

        Hide
        jira-bot ASF subversion and git services added a comment -

        Commit 1447945 from Pinaki Poddar
        [ https://svn.apache.org/r1447945 ]

        OPENJPA-2336: Consider database dictionary schema case while matching join column name

        Show
        jira-bot ASF subversion and git services added a comment - Commit 1447945 from Pinaki Poddar [ https://svn.apache.org/r1447945 ] OPENJPA-2336 : Consider database dictionary schema case while matching join column name
        Hide
        jpaheath Heath Thomann added a comment -

        For the sake of history, and to make it absolutely clear, in addition to this fix one may need to set DBDictionary.schemaCase as appropriate for the use case. E.g.:

        <property name="openjpa.jdbc.DBDictionary" value="schemaCase=upper"/>

        As another example, take this Column definition:

        @Column(name="MYCOL#")
        @Id

        and assume we use a different case when referred as a join column:

        @JoinColumn(name="hpnum", referencedColumnName="mycol#")

        Given the referencedColumnName is a different case than the actual column, OpenJPA will not find the column. To resolve this, one must have the fix of this JIRA, as well as setting the DBDictionary.schemaCase.

        Show
        jpaheath Heath Thomann added a comment - For the sake of history, and to make it absolutely clear, in addition to this fix one may need to set DBDictionary.schemaCase as appropriate for the use case. E.g.: <property name="openjpa.jdbc.DBDictionary" value="schemaCase=upper"/> As another example, take this Column definition: @Column(name="MYCOL#") @Id and assume we use a different case when referred as a join column: @JoinColumn(name="hpnum", referencedColumnName="mycol#") Given the referencedColumnName is a different case than the actual column, OpenJPA will not find the column. To resolve this, one must have the fix of this JIRA, as well as setting the DBDictionary.schemaCase.

          People

          • Assignee:
            Unassigned
            Reporter:
            ppoddar@apache.org Pinaki Poddar
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development