[ 
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

Reply via email to