I have a one-to-many relation from PERSON and COMPANY TABLE
and the following mapping in hbm in person.hbm

<set
name="contacts"
lazy="true"
inverse="true"
cascade="all-delete-orphan"
access="field"
>
<key>
<column name="Person_person_id" />
</key>
<one-to-many
class="com.transbility.persistence.hibernate.Contact"
/>
</set>

I want to delete a contact from database. I read in documenation that the set tag must have cascade = "all-delete-orphan" and all the thing I have to do is to remove the Contact pojo from the set of person.

contact.setPerson(null);
person.getContact().remove(contact);

Doing in this way the contact from database is not delete physical. Instead the field person_person_id which is the foreign key in table contact is set to null. I want that contact record doesn't exist anymore in database. What sugest can you give me?

Thanks in advance.

Uhm, have you tried removing the "contact.setPerson(null)" part? I think it is at least unneeded.

http://forum.hibernate.org/viewtopic.php?t=934588

Others are having the same problem without setting the foreign key on the child object to null. removing the child from the parent's set and calling saveOrUpdate with cascade=all-delete-orphan" should delete the child, but instead hibernate issues an update and tries to set the child's FK to null.

just remove from the collection, don't set the parent ref to null