[hibernate-issues] [Hibernate-JIRA] Created: (HBX-820) Order of the execution of the queries resukting in org.hibernate.exception.ConstraintViolationException: could not delete: []

[Suvasri Mandal (JIRA)]

Order of the execution of the queries resukting in org.hibernate.exception.ConstraintViolationException: could not delete: []
-----------------------------------------------------------------------------------------------------------------------------

         Key: HBX-820
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-820
     Project: Hibernate Tools
        Type: Bug

    Versions: 3.0beta2    
 Environment: Hibernate version 3.0 ,Oracle9
    Reporter: Suvasri Mandal


We have the following hierarchy in the business model:
A has an association with B and C.

In the database:
B holds the FK of A and C holds the FK of A.

We are facing a problem when the operation should result in the DELETE of the entire hierarchy.
This problem occurs ONLY AT TIMES AND NOT ALWAYS.

Probelm Defn:
The delete method is being called on the OBJECTS in the following order:
1. C
2. B
3. A

However, at times, the order in which hibernate fires the delete queries differs from the order mentioned above.
Hence, that resutls in the following error:
org.hibernate.exception.ConstraintViolationException: could not delete:[]


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira