Hi,

I want to create a .hbm.xml file for many-to-many link table
because whenever there is some deletion of the row in the link table
the child tables of the link table must also cascade the delete.

eg:

Tables A And B have many-to-many relation.

The link table is A_B;this link table has a child table A_B_child;

now whenever arow is deleted in the link table A_B i should cascade it in A_B_child.

the link table has got two foreign keys from table A and table B.

can u please explain me how to create a .hbm file for link table and use cascade to its childs.

can u please respond quickly.

Babu

It looks like this has been discussed before.

Does this link help?:
http://forum.hibernate.org/viewtopic.ph ... 4d5cf9b871

No its completely different reference u have given.
Please check my question again.

I guess I am not understanding the problem then. Could you provide your existing configuration (hbm.xml) files, and an example of what you are trying to do?

Table 1:

Name : Account
Columns: account_id
account_name

Table 2:

Name: Field
Columns : field_id
field_name

Account and Field => many-to-many association

link table:

name : account_field
columns : account_id
field_id


Link Table(account_field) has got a child account_field_child

Link Table Child :

Name : account_field_child
Columns :account_id
field_id
account_field_childname
account_field_childdescription

Queries :


1) Do I need to go for a .hbm.xml for the link table;because I need to cascade delete the account_field_child whenever a row is deleted in account_field.

2)I want to maintain unidirectional many-to-many relationship from account to field;so how to cofigure <set> in Account to specify link table in this scenario.

Thanks
Babu[/code][/list]

Yes, you have to model the link as an entity. Then you need a one-to-many association from Account to AccountField and a many-to-one from AccountField to Field. Additionally you can setup an one-to-one association from AccountField to AccoutFieldChild (or whatever you need here).



Somthing like that:

Account:


AccountField:


[/quote]

Thank You Wolli.

Thank You Wolli...This is working for me.