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

[Max Rydahl Andersen (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-820?page=all ]
     
Max Rydahl Andersen closed HBX-820:
-----------------------------------

    Resolution: Rejected

not a hibernate tools bug.

no testcase.

should be posted in forum first

> 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

>
> Original Estimate: 3 weeks
>         Remaining: 3 weeks
>
> 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