Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.0

Hi I have successfully implemented many-to-many relationship using the collections object, and it is working fine. Now I have the following question.

How can I write other attributes in the intersection table while the inter relationship is being built?

For example my collection object is successfully putting the contacts_id and custodian_id in the intersection table BUT I also have to write id and custodian_type in the intersection table. How can I achieve that?

Any lead or help will be greatly appreciated. Thank you. If you need me to post the code and xml's I will do so.

Database tables:

Table: Contacts:
Columns:
id, first_name, last_name

Table: Custodian:
Columns:
id, custodian_name

Table: Contact_Custodian
Columns:
id, contact_id, custodian_id, custodian_type

This question is very common.
As soon as you start putting extra information in the relationship table, even just a couple of extra files, it is not a relationship table anymore, but another entity.

You should decompose your many-to-many relationship into one one-to-may relationship between contacts and contacts_custodians, and another many-to-one relationship between contacts_custodians and custodians.

Very few real-life applications manage to keep "pure" many-to-many relationships, and end up doing something like this.