I am mapping 3 many-to-many relationships with a common table. I've been trying to get this to map, but am not sure it is possible. If anyone knows of a way to handle this complex mapping, I'd greatly appreciate help. I have the following table structures simplified to their primary keys:

TableA:
<PK>col1

TableB:
<PK>col2

TableC:
<PK>col3
<PK>col4

TableD:
<PK>col1
<PK>col2
<PK>col3
<PK>col4
<PK>col5

TableD contains foreign keys to all other tables and has an additional key column to make a 5 column primary key. I was able to get D mapped to A and B, but can't figure out how to get D mapped to C(so the POJO for TableD will have a reference to a related item in C). If anyone know how this can be done

Thanks,
Dave

it'd look something like:


yummy! ;)

Have a look at:
http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-compositeid

and

http://www.hibernate.org/hib_docs/v3/reference/en/html/components.html#components-compositeid