Hi,

i have a quite huge project with a lot of OneToMany relations. The problem is that hibernate doesn't set the foreign key to NULL when
i delete a parent entity. So a value remains in the database that doesn't exist anymore (producing errors in hibernate core).

Is there any way to tell hibernate to set every foreign key to NULL or is the only way to do this a ON DELETE SET NULL constraint in
the database? If the only way is the constraint how can i avoid hibernate seeing the wrong state (cache)?

Thanks for your help

Yours
Thomas

I think that is exactly what controlled by inverse property:

• if inverse=false, then when collection entry is removed, the parent key is set to null (update child set parent_id = null where parent_id = ?)
• if inverse=true, then when collection entry is removed, it is deleted by key (delete from child where id = ?)