Hello, we're using hibernate for some time now. But we have a problem now which we can't solve. Let's say we have a database model with a table timetable and a table member. To couple these two we create a table TimetableMember. The primary key of the table TimetableMember will be the timetableid and the memberid combined so . Now we want to create this situation in hibernate but we can't get this to work. The ProductMember class has many to one relation with member and product. Now we want hibernate to generate a table where product and member together are the primary key of the table. The docs tells us to use a composite-id but we can't get this to work. Can somebody please help us by pointing us in the right direction how to achive this in hibernate and better in xdoclet?

Here is a sketch of the situation:

Conceptual model:

Physical model:


Thanks in advance.

Maybe another solution?