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] Commented: (OPENJPA-1083) org.apache.openjpa.persistence.kernel.TestEJBState fails with two exceptions ORA-00904 and ORA-02275 against oracleDB.
Date Wed, 13 May 2009 16:15:45 GMT

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

Ravi P Palacherla commented on OPENJPA-1083:
--------------------------------------------

Michael,

Thanks a lot for reviewing it.

I think the above exception will occur in any database that will not allow executing the same
SQL statement to add same foreign key more than once.
I tested it against Derby and oracle only.

E.g:  If you execute both the following statements (same statement twice)
ALTER TABLE DEPFIELDPC ADD FOREIGN KEY (OWNER_ID) REFERENCES DEPFIELDPC
ALTER TABLE DEPFIELDPC ADD FOREIGN KEY (OWNER_ID) REFERENCES DEPFIELDPC

Execution of above two statement will be successful in Derby ( hence test case passes in Derby)
.
The second statement will fail in oracle with the ORA-02275 exception.

>>Why we are getting duplicate FK ?

In getDeleteTableContentsSQL() of DBDictionary.java,
while trying to delete the contents of table , openJPA tries to
 a. remove FK 
 b. delete rows and then
 c. add FK back

When there is no FK name then we are not removing it but still trying to add it.
The attached patch will not add FK unless we remove it.

Please let me know of any suggestions.

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
>            Reporter: Ravi P Palacherla
>         Attachments: OPENJPA-1083.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