Hi,

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.

can u please explain with configuration mappings ...

Thanks
Babu