where is OnDeleteAction.SETNULL ?

hugeride · **Joined:** Thu Aug 18, 2005 12:24 pm **Posts:** 11

Hibernate version: 3.1

Hi, Im trying to use ON DELETE SET NULL integrity restriction but it doesnt exists on annotation OnDeleteAction!
How to do this?

emmanuel · **Posted:** Tue Aug 23, 2005 5:37 pm

This feature does not exist, but you can provide a patch.

hugeride · **Joined:** Thu Aug 18, 2005 12:24 pm **Posts:** 11

Hi!
First of all I would like to thank you a lot for your help.. ;) Thanks!

OnDeleteAction.SETNULL really doesnt exist, but I can provide a patch... how can I do this?
I understand that hibernate can only deal with some pre-defined annotations.. is there a way to add annotations to it and to program the way it handle those annotations?

Thank you very much!

emmanuel · **Posted:** Wed Aug 24, 2005 5:24 am

You have to download Hibernate Annotation source code plus Hibernate 3 source code from sourceforge and update both. Hibernate does not handle SETNULL action at all currently.

hugeride · **Joined:** Thu Aug 18, 2005 12:24 pm **Posts:** 11

Hi emmanuel, thank you again for your help...
Im still a hibernate newbye - I've been studying it for the last 3 weeks only - and I dont feel totally confortable with the idea of building a patch to it... but I would like to know if you think this 'OnDeleteAction.SETNULL' feature is really important ( because from my point of view it is ) and if it is going to be supported by hibernate on a future version...

emmanuel · **Posted:** Thu Aug 25, 2005 7:37 am

I never liked those DB tricks. They break the 1st and second level cache consistency.