I have a unidirectional one-to-many relation between hotel and hotelroom (one hotel has several rooms). When i load a hotel with say 4 rooms and then delete it, then hibernate issues 5 delete statements (one for hotel, 4 for the rooms) since the rooms are not deleted by using the FK to the hotel but the PK of the room (see statements below).
i expected something like:
Hibernate: delete from T_HOTELROOM where HOTEL_REF=?
Hibernate: delete from T_HOTEL where HOTEL_ID=?

How can i achieve this ?

thanks for your help and have a nice weekend.

fab

Hibernate version:
3.0.5

Mapping documents:
Mapping of the many rooms in one Hotel
<set
name="rooms" cascade="all" inverse="true">
<key column="HOTEL_REF" not-null="false"/>
<one-to-many class="HotelRoom"/>
</set>

Code between sessionFactory.openSession() and session.close():
Object obj = session.get(Hotel.class, new Long(12));
session.delete(obj);

Name and version of the database you are using:
Mysql 5

The generated SQL (show_sql=true):
Hibernate: delete from T_HOTELROOM where HOTELROOM_ID=?
Hibernate: delete from T_HOTELROOM where HOTELROOM_ID=?
Hibernate: delete from T_HOTELROOM where HOTELROOM_ID=?
Hibernate: delete from T_HOTELROOM where HOTELROOM_ID=?
Hibernate: delete from T_HOTEL where HOTEL_ID=?

after doing some more experiments i can partialy answer this question myself:
by adding an on-delete="cascade" to the sets key element and changing the cascade to "save-update" the hotel gets deleted by using one statement since the DB will take care of the cascading.



still i would like to know if hibernate can issue the delete based on the FK on the hotel instead of the PK of the rooms ?


fab