[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3337?page=c... ] Alex Savitsky updated HHH-3337: ------------------------------- Attachment: TestHB.zip Eclipse project with a Maven POM. Build and execute the test.Test class. Notice that the generated DELETE SQL looks like this: DELETE FROM ElementMapping WHERE NOT (EXISTS (SELECT headermapp1_.id FROM HeaderMapping headermapp1_, Unit unit2_, Element element3_ WHERE ElementMapping.UNIT_ID = unit2_.id AND ElementMapping.ELEMENT_ID = element3_.id AND unit2_1_.TOP_HEAD_ID = headermapp1_.UNIT_ID AND element3_.HEADER_ID = headermapp1_.HEADER_ID)); where unit2_1_ is supposed to point to the LINK table, but it is missing. The real SQL should look like this (with the missing pieces marked with '->'): DELETE FROM ElementMapping WHERE NOT (EXISTS (SELECT headermapp1_.id FROM HeaderMapping headermapp1_, Unit unit2_, -> Link unit2_1_, Element element3_ WHERE ElementMapping.UNIT_ID = unit2_.id AND ElementMapping.ELEMENT_ID = element3_.id -> AND unit2_1_.UNIT_ID = unit2_.ID AND unit2_1_.TOP_HEAD_ID = headermapp1_.UNIT_ID AND element3_.HEADER_ID = headermapp1_.HEADER_ID)); -- 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