My tree structure behaves strange or does the parent/child really behave this way?Let say i had three records:

Media
- News
-- Sports News

When i try to delete News, its children must also be deleted. But what is happening is that even its parent are also deleted. (the whole nodes are deleted). Does a tree structure table in hibernate behave this way or am i missing something in my configuration?


Industry table

Industry
id,(primary key)
name,
industry_id_fk (foreign key)


Industry.java
public Industry{

Industry parent;
Set childer;

}


Industry.hbm.xml

<hibernate-mapping >
<class name="com.eon.cms.vo.Industry" table="industry">
<id name="id" type="long" unsaved-value="0">
<generator class="native"/>
</id>

<set name="children" inverse="true" lazy="false" cascade="save-update" order-by="industry_id_fk">
<key column="industry_id_fk"/>
<one-to-many class="com.eon.cms.vo.Industry" />
</set>
<many-to-one name="parent" column="industry_id_fk" cascade="all" class="com.eon.cms.vo.Industry"/>

<property name="name" length="50"/>
</class>
</hibernate-mapping>


* i've already tried to change the cascade in set (save-update| all | all-delete-orphan) but still the results are the same.

hibernate: 2.1.2 version
database: postgres


any help?

thanks.


raymond

Change to cascade="save-update" (or, more likely, cascade="none").

It works!

thanks Gavin!