Hi!

This is how my simplified association looks like:
I have got an employee and a pc table.





The problem I have is that when I want to delete an employee, his pc shouldn't be deleted, the only action which shall take place is that his foreign key (emp) to the employee should be set to null.

I couldn't find anything in the documentation and after searching the forum for hours, I hope that somebody can help me. All I want is a ON DELETE SET NULL statement within the foreign key constraint.

Oh, and I'm using Oracle 9i and Hibernate 3 but this won't matter much anyway, does it?

Thanks for any help,
Markus

You don't have a one-to-many declaration in the Employee mapping?

Should I?

I just need a unidirectional association. Anyway this won't help me with my problem or will it?

Markus

Hibernate Team:
Is my question not understandable or isn't this feature implemented in Hibernate yet?

I just want to make sure that I don't waste time with something which would'nt work anyway.

thanks for any information concerning this problem.

I don't think this is implemented. You probably have to do it in code.

First of all, thank you for your answer.

Currently I am writing an application that uses Hibernate, but without the support of "on delete set null" I would have to change the data on the database (in my simple case, when I delete a user 'a' then all pcs, which belong to 'a' have to be updated. ) with an additional sql statement every time a user gets deleted.

Isn't there any other/better oppurtunity?

Thanks again,
Markus

P.S.: @Hibernate Team: If this feature isn't implemented yet, then it could be added to the TODO list of the following releases.

Isn't the 'ON DELETE SET NULL' something you define in your database ? Hibernate only deals with mapping SQL to Objects.

I could see where you might want to add support for this in the Hibernate Tools.

Absolutely.
But if my associations don't exist on the database, Hibernate creates those (At least I think so). And this is my problem: A foreign key with a "SET NULL ON DELETE" isn't generated with my code by Hibernate.

Or am I mistaken?