Many-to-many composite ID

[Jonathan Huang]

Is there a way to map a many-to-many set that does not use the entire composite ID of the association.

Table1's PK = column1 + column2 + column3
Table2 only has column1 and column2 that associate to Table1.

For Example we have two mappings:

 
<hibernate-mapping>
<class name="ClassA"  table="TableA" lazy="false">
<composite-id name="id" class="CompositeID">
<key-property name="job" column="JOB"/>
<key-property name="sclName" column="SCLNAME"/>
<key-property name="sclPunch" column="SCLPUNCH"/>
</composite-id>   
 
... 
...
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="ClassB" table="TableB" lazy="false">
<id name="id" class="QuestionId" />
 
<property name="JOB" type="integer" column="JOB" unique="true" insert="false" update="false" />
<property name="sclName" type="string" length="15" column="SCLNAME" />
 
<set name="tlkpScale"  table="TableA" inverse ="true" lazy="false">
<key>
<column name="SCLNAME" />
<column name="JOB" />
</key>
<many-to-many class="ClassA" >
<column name="SCLPUNCH" /> 
</many-to-many>
</set>

The code above throws a: "must have same number of columns as the referenced primary key (webquest.OTOSTLKPSCALE [JOB,SCLNAME,SCLPUNCH])" error.

Thanks in advance and I hope I was clear in describing my issue.
[ July 25, 2006: Message edited by: Jonathan Huang ]

[Jonathan Huang]

Anyone?

Still having trouble figuring this one out!

Thanks.