OpenJPA
  1. OpenJPA
  2. OPENJPA-2336

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

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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
        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
        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
        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
        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:
            Pinaki Poddar
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development