Hi all,
I have a question about mapping a many-to-many association using list. Suppose I have a schema like that :
Customer {id : int}
Account {id : int}
Customer_Account {CustomerID : int, AccountID : int, CustomerIndex : int, AccountIndex : int}

now I mapped the association using list :

In Customer mapping:


In Account mapping:


When I saving the customer object, it only insert the CustomerID, CustomerIndex and AccountID into the database, did anyone know whats wrong with it?[/code]

Hi

use inverse=true in


Amila

(Don't forget to rate if helps)

Thanks for your advance.

But I still got the following problems:
1. specify inverse="true" in customer side => will only insert AccountIndex
2. specify inverse="true" in account side => will only insert CustomerIndex
3. specify inverse="true" in other side => it will insert the record twice, first record is inserting CustomerIndex, another one is AccountIndex.


Is it have anyway to insert only one record and specify both index column??

Is there have any solution for this?

You have your associations backwards. In Customer you want a list of Account objects, not Customer objects. It should look like this:


In Customer mapping:

<list name="accounts" table="Customer_Account" cascade="save-update,lock">
<key column="CustomerID" not-null="true"/>
<list-index column="AccountIndex"/>
<many-to-many column="AccountID" class="Account"/>
</list>


And the same thing for Account

In Account mapping:

<list name="customers" table="Customer_Account" cascade="save-update,lock">
<key column="AccountID" not-null="true"/>
<list-index column="CustomerIndex "/>
<many-to-many column="CustomerID" class="Customer"/>

</list>