I've got 2 Tables:

User & Awards

A User can have many awards.

I've mapped a Unidirectional Many to one mapping from Awards to user like this:


<many-to-one name="user" class="User"
fetch="select" >
<column name="user_id" not-null="true" />
</many-to-one>

I'd like to know how is it possible to delete the awards when a user is deleted?

Right now, it throws a foriegn key exception when I delete the User. I have nothing mentioning Awards in the User hbm file.


Newbie question:
For every column that is mapped in the hbm file, does there need to be a getter/setter for it (I know there needs to be, but is there a way not to?). The reason I ask is, by declaring the relationship in Awards, but nothing in user, I don't see how Hibernate will know there is a relationship between User & Awards.

However, I don't want to clutter my User table with the Awards data, I especially don't want to load the Awards when all I want to do is load the Users Data.

Thanks.

Since you have a unidirectional mapping, there is no way to cascade deletions from User to Awards. You need to manually remove the associations from the Awards table corresponding to the User being deleted. Doing a Query like

get the set of Awards, and make those users null.



No need, if the access method is set to field, then there is no need for getter/setters. They are required only if the access method is set to property. But I dont see how thats connected to your question. You are only doing a unidirectional mapping, so there is no way for Hibernate to know the association from the other side[/code]