openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Heath Thomann (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2336) Relax Join column name comparison based on database dictionary schema case setting
Date Wed, 20 Feb 2013 18:13:12 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13582389#comment-13582389
] 

Heath Thomann commented on OPENJPA-2336:
----------------------------------------

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.
                
> Relax Join column name comparison based on database dictionary schema case setting 
> -----------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2336
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2336
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Pinaki Poddar
>
> Name of join column name comparison should allow schema case set in database dictionary

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message