Defining an object with an @ElementCollection prevents bulk delete ------------------------------------------------------------------ Key: HHH-5528 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5528 Project: Hibernate Core Issue Type: Bug Affects Versions: 3.5.4 Reporter: Jacob Rhode The following query to delete a set of records, only works in some circumstances: {code} Query query=em.createQuery("DELETE FROM Person"); query.executeUpdate(); {code} If you use an @ElementCollection and add some data, this query will fail. Example class: {code:title=Person.java|borderStyle=solid} @Entity @Table(name="person") public class Person implements Comparable<Person> { @Id @GeneratedValue(strategy = GenerationType.AUTO) @Column(name="id") private long id = 0; @ElementCollection @Column(name = "activation_key") @CollectionTable(name = "activation_key") private Set<String> activationKey = new HashSet<String>(); } {code} The following error is generated while trying to bulk delete: {code} 2029 [main] ERROR org.hibernate.util.JDBCExceptionReporter - integrity constraint violation: foreign key no action; FKCEC6E942485388AB table: ACTIVATION_KEY {code} As a result, this means code that formerly worked using a bulk delete, can stop working due to an @ElementCollection being added to the associated Java class. -- 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