Hi Guys,

Facing a serious problem with many-to-many relationship with a link table between two master tables.

I have a Customer Table and a Group Table and the relationship is many-to-many thereby


Customer(customers)[0...*]------------------customerGroup--------------------Group(groups))[0...*]


the HBM declarations are as follows:

In Customer.hbm.xml

....
<set name="groups"
table="CUSTOMER_GROUP"
order-by="GROUPS_FK" lazy="true"
fetch="select" inverse="false">

<key foreign-key="GROUP_CUSTOMER_FC">
<column name="CUSTOMER_FK" sql-type="VARCHAR(36)"/>
</key>
<many-to-many class="com.test.Group"
foreign-key="CUSTOMER_GROUPS_FKC">
<column name="GROUPS_FK" sql-type="VARCHAR(36)"/>
</many-to-many>
</set>
....

In Group.hbm.xml

...
<set name="customers"
table="CUSTOMER_GROUP"
order-by="CUSTOMERS_FK" lazy="true"
fetch="select" inverse="true" >

<key foreign-key="CUSTOMER_GROUP_FKC">
<column name="GROUPS_FK" sql-type="VARCHAR(36)"/>
</key>
<many-to-many
class="com.test.Customer"
foreign-key="GROUP_CUSTOMERS_FC">
<column name="CUSTOMERS_FK"
sql-type="VARCHAR(36)"/>
</many-to-many>
</set>
....

Since inverse is true on Customer, it should update the link table and not Group, is this assumption correct?

If I flip the flags, no updates happen to the link table.

Any help would be appreciated.

- Kingfisher.

It'll probably help if you show the java code where you are doing the updates.

Anyway, given the two mapping files you have,

If you do

The link table will be updated.

If you flip the inverse flag, you'd need to do

on top of the previous snippet in order for the link table to be updated.

Budyanto

[/code]