I have the following Tables in my database:

Person
Category
Person_Category
Category_Content
Content

A Person has a many to many relationship to Categories.

A Category has a many to many relationship to Content.

Therefore a Person has a many to many relationship to Content.

I would like to design my objects w/o creating a Category Object. I would like a collection of available Content in Person. So I want to create a mapping from Person to Content. The mapping would have to link across Person_Category and Category_Content.




It's not obvious to me how to map Person to Content through the two link tables

What would be the hibernate mapping syntax to do this? Thanks in advance for any examples[list=][/list]

So have you considered how, when adding a Content to a Person, hibernate is supposed to know which category to add it to? Even if it were possible to map such a thing, there would be no way for Hibernate to know the answer to that question.

Good point, I created a named Query instead.

Thanks