Hi everyone!

The situation that I am encountering is that I need to remove a record associated with another record when that record is set to null. To be a bit more clear, here is an example. I have a Person object which contains a Phone object (PERSON table references PHONE_ID from the PHONE table). When the Phone object is set to null in the Person object, I need the Phone record to be removed from the database when the Person object is saved. But what actually happens is that only the PHONE_ID from the PERSON table gets removed, but the actual phone record is still in the database.

The following is what I have inside my mapping for the Person object:



I tried using a one-to-one relationship but this doesn't seem to work either. Any suggestions?

Thanks in advance!

Anyone?

As far as I understand cascading is for the events that happen to the containing object. Therefore, setting the phone instance to null has nothing to do with cascading. However, you should expect your phone record to be deleted when person records are deleted. There is an exception when it comes to collection associations in which you can tell hibernate to delete orphan objects by setting cascading to delete-orphan (all does not include delete-orphan). I believe you need to write a code to delete phone objects manually.

I do not know how to do it properly, via mapping. We achived this behavior by providing a custom SQL for deleting from a collection.

Indeed, it seems there is a better way, at least these posts indicate that delete is issued:

http://forum.hibernate.org/viewtopic.php?t=979189
http://forum.hibernate.org/viewtopic.ph ... highlight=