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

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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira