openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravi P Palacherla (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (OPENJPA-1083) org.apache.openjpa.persistence.kernel.TestEJBState fails with two exceptions ORA-00904 and ORA-02275 against oracleDB.
Date Mon, 08 Jun 2009 13:36:07 GMT

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

Ravi P Palacherla edited comment on OPENJPA-1083 at 6/8/09 6:35 AM:
--------------------------------------------------------------------

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 not dropping the foreignkey if FK name is null.

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.


      was (Author: rpalache):
    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.


Mime
View raw message