Hi,

could it be that Hibernate does not support many-to-many mappings of the following type?

I have a n-to-m relationship of objects of classes A and B. A has the following composite PK: pk1, pk2. B has the composite PK pk1, pk2, pk3. The db table for the n-to-m mapping contains pk1, pk2, pk3. So a specific combination pk1fix, pk2fix (an individual A entity) maps to corresponding combinations pk1fix, pk2fix, pk3var (the corresponding B entities).

WIth the following mapping I always get a Hibernate mapping exception. Am I correct that Hibernate does not support this type of composite PKs? (Though that would be sad, 'cause I would like to switch from JDO to Hibernate, if we don't have to change our whole DB schema.)

Mapping for A:
<set name="bs" table="AB_MAPPING" lazy="true" inverse="true">
<key>
<column name="pk1"/>
<column name="pk2"/>
</key>
<many-to-many class="B">
<column name="pk1"/>
<column name="pk2"/>
<column name="pk3"/>
</many-to-many>
</set>

Mapping for B:
<set name="as" table="AB_MAPPING" lazy="true">
<key>
<column name="pk1"/>
<column name="pk2"/>
<column name="pk3"/>
</key>
<many-to-many class="A">
<column name="pk1"/>
<column name="pk2"/>
</many-to-many>
</set>


Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Seems to be that way.
Extending the n-to-m mapping table from pk1,pk2,pk3 to pk1a,pk1b,pk2a,pk2b,pk3 did the job and since I received no response from the Hibernate team...

It has been answered many times...