Joining table mapping HOWTO

Sharas · **Joined:** Tue Jul 22, 2008 4:55 pm **Posts:** 3

Hi,

Lets say I have Users abd Products tables. UserOrders table is a joining table and has UserId and ProductId columns.

In my User class I have a list of ordered products. How do I define mapping from Users to Products table through UserOrders table?

Please give me an example of mapping xml.

Thanks,

Sharas

wolli · **Posted:** Wed Jul 23, 2008 3:12 am

Try this

Code:

<set name="Products" lazy="false" table="UserOrders">
   <key column="productid"/>
   <many-to-many class="Order" column="orderid"/>
</set>

and have a look at the documentation for many-to-many associations.

http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/collections.html#collections-ofvalues