Hello,

after searching the documentation and forum posts I am still stuck with
the question how to map a many-to-many relationship between two tables
with the relationship table having a primary key of its own and extra attributes:


I've learned I could use the <idbag>-tag introduced in 6.13. of the hibernate reference with the many-to-many tag, but then, I can't figure out how to adress the extra fields STATUS and DATE.

Alternatively, trying to map the above with
I do not understand wether I have to do this in the mappings of both outer tables and wonder which java classes to generate/write. Until now, I ended up with four classes mapping the above relation, leaving me with a feeling of doubt....

Could someone give me some insight or even better, provide an understandable example of two mapping files, please?

Thanks,
Markus

Hi Markus,

I'm facing with a situation like yours. Can you help me how to map this 3 tables?

Thanks in advance,
Thomas

You can use composed element, or instead of a many to many you can use 2 many to one relationship bidirectionnal.
Look at the hibernate reference in examples chapter "Product, Customer and Order".