Hi,


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

Hibernate version:
3.0

Name and version of the database you are using:
Oracle 10G

I am trying to do a mapping for two many-to-many associations which are interlinked.

This means that

A<------->B
B<------->C

Suppose class A has attributes A_ID,A_NAME and similarly the class B has B_ID,B_NAME and class C has C_ID,C_NAME

A,B, C are three classes and are linked by a many-to-many relation.

The corresponding DB schema is like this.

A--->AB---->B
AB---->BC----->C

Table A has columns A_ID,A_NAME
Table AB has columns A_ID,B_ID
Table B has columns B_ID,B_NAME
Table BC has columns A_ID,B_ID,C_ID,D_ANOTHER_FIELD
Table C has columns C_ID,C_NAME

I would prefer if we don't require to have the AB,BC tables not to be present as corresponding Entity classes. Please note table BC has additional fields other than the Identifier fields

Can a mapping be done for this relation?

Thanks,
Surya

check out pg 101 of reference.pdf it is almost identical (if not similar) to what you are talking about:

http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf