Hello!

I'm new to Hibernate and I've been searching the problem for some time now, but i cant find a solution.

I have a class using a composite-id Key element.
But i also want to join with another table with only one part of the composite key. Is this possible with Hibernate?

I get the Error:
Foreign key (:RP [RP_ID])) must have same number of columns as the referenced primary key (ZR [RP_ID,ZB_ID])

thanks for helping!

Is this mapping not possible? Or anyone who knows how to work around with another mapping association?

Here are my tables from a legacy DB:



As you can see, there is a foreign key from B -> A and from B -> C. This is also the compositeKey from B.

I allready know how to map it with mapping files for each table, but i'm looking for a possibility to map only table B with the <join-table> attribute to the other two tables.

Anyone know, if this is possible?

Thanks!