[ 
https://issues.apache.org/jira/browse/OPENJPA-946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ravi P Palacherla updated OPENJPA-946:
--------------------------------------

    Comment: was deleted

(was: Hi,

I was trying to run TestEJBState  against oracleDB  and I need to get this JIRA 
issue fixed as part of it.

So, I spent some time and I think I can do one of the two things to get this 
fixed:

1) To change the 
"openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/kernel/common/apps/ProxiesPC.java"
 to replace the variable name of "date" to something like "date0." ( this is 
more like a workaround rather than an actual fix.)

2)  I found the cause of this issue but I need some one to please review my 
proposed fix before I submit the patch.

The actual fix should go inside "correctName(Table table, Column col)" method 
of class  
"openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/meta/MappingDefaultsImpl.java"
If you check the method , "col.setName(dict.getValidColumnName(name, table));" 
is called only if _defMissing is false. But "_defMissing"  is set to true from 
"PersistenceMappingDefaults.java".

"_defMissing" represents DefaultMissingInfo and as per the doc,  
DefaultMissingInfo  is to determine Whether to default missing column and table 
names rather than throw an exception.

So, if "_defMissing" is true then we have to set the column name properly 
rather than throwing exception ( For example, if column uses reserve word then 
we have to replace the column name.)

But here the opposite is happening meaning, we are changing the column name 
only if the "_defMissing"  is false.

So, the resolution would be to change correctName to:

protected void correctName(Table table, Column col) {
if (_defMissing || _removeHungarianNotation)   // Replaced !_defMissing  with 
_defMissing  )
{
  String name = col.getName();
  if (_removeHungarianNotation)
    name = removeHungarianNotation(name);
    col.setName(dict.getValidColumnName(name, table));
}
}

Also as stated under 
(http://n2.nabble.com/Question-regarding-DefaultMissingInfo-of-MappingDefaults-property.-td2657689.html)

I also tried to use 
case 1: <property name="openjpa.jdbc.MappingDefaults" 
value="default(DefaultMissingInfo=true)"/>  or
case 2: <property name="openjpa.jdbc.MappingDefaults" 
value="default(DefaultMissingInfo=false)"/> or
case 3: <property name="openjpa.jdbc.MappingDefaults" value="jpa"/> ( default) 

but it did not help; meaning none of the above cases chaged the value of 
"_defMissing" and hence "col.setName(dict.getValidColumnName(name, table));" is 
not called, which is the cause of the issue.

Can someone please review the change before I submit the patch.
The reason for asking someone to review is because I think I did not understand 
the concept DefaultMissingInfo properly.

Thanks,
Ravi.)

> Oracle create table(s) exceptions
> ---------------------------------
>
>                 Key: OPENJPA-946
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-946
>             Project: OpenJPA
>          Issue Type: Sub-task
>            Reporter: Tim McConnell
>            Assignee: Tim McConnell
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to