Hibernate version:
3.2.6.ga
Mapping documents:
Code:
<class name="company.WorkflowWatch" table="INTRANET_WF_WATCH">
<cache usage="read-write"/>
<id name="id">
<column name="watch_id" not-null="true" unique="true" />
<generator class="sequence">
<param name="sequence">RH_GENERIC_SEQ</param>
</generator>
</id>
<!-- .... other simple properties ...-->
<many-to-one name="profile" column="PROFILE_ID" not-null="false" cascade="save-update"/>
</class>
Code:
<class name="company.Profile" table="INTRANET_PROFILE" lazy="false">
<cache usage="read-write"/>
<id name="id">
<column name="profile_id" not-null="true" unique="true" />
<generator class="sequence">
<param name="sequence">RH_GENERIC_SEQ</param>
</generator>
</id>
<!-- .... other properties ...-->
<set name="watchedWorkflows" cascade="all,delete-orphan">
<key column="PROFILE_ID"/>
<one-to-many class="be.rmi.intranet.profile.WorkflowWatch"/>
</set>
</class>
Code:
s.flush();
id = w.getId();
Long id2 = p2.getId();
System.out.println("removing");
p2.getWatchedWorkflows().remove(w);
s.save(p2);
System.out.println("flushing");
s.flush();
s.close();
s = WorkflowsService.getInstance().createSession();
assertNull("an update of profile should have remove watch",s.get(WorkflowWatch.class, id));
The generated SQL (show_sql=true):Code:
removing
flushing
Hibernate: update INTRANET_WF_WATCH set PROFILE_ID=null where PROFILE_ID=?
Hibernate: delete from INTRANET_WF_WATCH where watch_id=?
With above mapping, when i remove an item from a set, hibernate is supposed to delete corresponding row for item (delete-orphan rule). However, why does it systematically issue an update on the very same row before deleting it? It first set the foreign key of PROFILE_ID to null before deleting. Not only does it waste time, it also means that i have to remove my "not null" constraint from this foreign key in the database or hibernate issue an exception abuot not null when asked to delete an item.... Is there any way to ask hbernate not to do that non-sense update?
Login
FAQ
Search
