Deleting a row from a table which has Collection of values

LRK · **Joined:** Fri Aug 05, 2005 4:32 am **Posts:** 5

Hi,

I have class which is having collection of some other values which should go to different table. I am able to successfully insert values to both tables from the following mapping

<class name="Parent" table="Parent_table">
<id name="parentId" column="ID">
<generator class="increment" />
</id>
<property name="parentName" column="NAME" />
<set name="childValues" table="Child_table">
<key column="ID"/>
<element column="CHILD_ID" type="java.lang.String" not-null="true"/>
</set>
</class>

My tables are

Parent_table :
----------------
ID number (PK)
NAME varchar2(50)

Child_table:
--------------
ID number (FK references ID of Parent_table)
CHILD_ID varchar2(40) not null

Insertion and updation are working fine for me now. Now the problem is for the deletion of records from Child_table. As i don't have any mapping class for Child_table, i am unable to delete records from this table using HQL.

Now is it mandatory for me to create a class and have a mapping for it if i have to delete? or is there any other way i can do it without creating a class for this table?

scesbron · **Joined:** Thu Sep 04, 2003 8:23 am **Posts:** 368

You can delete child by removing them from the set of the parent children

Code:

session.open();
tx = session.beginTransaction();
parent = (Parent) session.get(...);
parent.getChildren().remove(myChild);
tx.commit();
session.close();