[
https://issues.apache.org/jira/browse/OPENJPA-1083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717248#action_12717248
]
Ravi P Palacherla commented on OPENJPA-1083:
--------------------------------------------
Hi Milosz,
The bug you mentioned exists even before the fix for this JIRA went in.
The cause of the issue is inside DBDictionary.getDropForeignKeySQL() where it
tries to use DROP constraint instead of DROP FK.
The reason for why this issue appears now is because before the fix for this
JIRA , getDropForeignKeySQL() was never called.
The fix in this JIRA makes sure that the FKs are dropped properly before
clearing table contents and hence you are seeing this issue now.
So, I guess a new JIRA would be appropriate to fix the issue. Please let me
know if you think otherwise.
Also we may have to make getDropPrimaryKeySQL() consistent with
getDropForeignKeySQL().
Regards,
Ravi.
> org.apache.openjpa.persistence.kernel.TestEJBState fails with two exceptions
> ORA-00904 and ORA-02275 against oracleDB.
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-1083
> URL: https://issues.apache.org/jira/browse/OPENJPA-1083
> Project: OpenJPA
> Issue Type: Sub-task
> Affects Versions: 2.0.0-M2
> Reporter: Ravi P Palacherla
> Assignee: Michael Dick
> Fix For: 1.3.0, 2.0.0
>
> Attachments: OPENJPA-1083.patch, OPENJPA-1083_option1.patch,
> OPENJPA-1083_option2.patch, OPENJPA-1083_trunk.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
