HI Friends,

I am using one-to-many relationship,
I have Tow table table1 and table2 and table data is as,

table1

ID LAST FIRST AGE
1 Kumar Nagendra 26
2 Rao Komal 24

table2
ID parent_ID test result
1 1 blood A+
2 1 Pulse 75
===============================================
And I want to delete all data of parent_ID 1 from table2 and my code is,
=========================================
Transaction transaction = null;
Session session = HibernateUtil.currentSession() ;
transaction = session.beginTransaction();
TABLE1 table1 = (TABLE1)session.load(TABLE1.class,1);

Set l = table1.getStories();

try
{
Iterator i = l.iterator();
while(i.hasNext())
{
i.next();
i.remove();
}
// table1.setStories(l);
//session.save(table1);
transaction.commit();
}
=============================================
But is don’t effect on database. This is wrong way or I am missing something plz help me.
==============================================
And HBM file is as
<hibernate-mapping>
<class name="TABLE1" table="table1">
<id name="id" unsaved-value="0" >
<generator class="increment" />
</id>
<set name="stories" cascade="all-delete-orphan" inverse="true">
<key column="parent_id"/>
<one-to-many class="TABLE2"/>
</set>
<property name="last" type="string"/>
<property name="first" type="string"/>
<property name="age" type="string"/>
</class>

<class name="TABLE2" table="table2">
<id name="id" unsaved-value="0">
<generator class="increment"/>
</id>
<property name="test" type="string"/>
<property name="results" type="string"/>
<many-to-one name="parent" column="parent_id" not-null="true"/>
</class>
</hibernate-mapping>



Thanks in adv

I think the problem is that you are updating the inverse end of a bi-directional association. The hibernate documentation says:



This is at http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#collections-bidirectional

In a bi-directional one-to-many association the inverse end must be the "many" end. So to get the desired result you have to update the "one" end of the association. The following code does this:



In the code above we are updating the "one" end of the bi-directional association by setting TABLE2.parent to null.

The hibernate documentation also says:



So I expect that the associated TABLE2 objects will be deleted because of the cascade option for TABLE1.stories is set to all-delete-orphan.

I hope that helps (and works!).

Cheers