Hi All,
I am lost trying to create a relationship for table with composite key. Here is my example:

<hibernate-mapping>
<class name="eg.User" table="user">
<composite-id name="compId" class="edu.umn.web.idea.data.entity.UserPK">
<key-property column="user_id" length="16" name="userId" type="string"/>
<key-property column="year" length="4" name="year" type="string"/>
</composite-id>
<property column="first_name" length="64" name="firstName" not-null="true" type="string"/>
.
.
.

<set name="roles">
<key>
<column name="id"/>
<column name="year"/>
</key>
<one-to-many class="eg.UserRole"/>
</set>

</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="eg.Role" table="role">
<composite-id>
<key-many-to-one column="id" class="edu.umn.web.idea.data.entity.User" name="id"/>
<key-property column="year" length="4" name="year" type="string"/>
<key-property column="role" length="4" name="role" type="integer"/>
</composite-id>
<property column="active" length="1" name="active" not-null="true" type="byte"/>
.
.
.
</class>
</hibernate-mapping>


At boot time, this is the message I got:
.
.
FATAL 2004-05-11 12:53:11,445 [main] (eg.ApplicationInit) - Error obtaining a Hibernate SessionFactory!
net.sf.hibernate.MappingException: Foreign key (role [id])) must have same number of columns as the referenced primary key (user [user_id,year])
at net.sf.hibernate.mapping.ForeignKey.setReferencedTable(ForeignKey.java:60)
.
.



What am I doing wrong in my role mapping??


Thanks

JavaLamer

I tried to make the above generic but forgot a few things.

Sorry
JavaLamer

Ok, with some reading, I think I got it.

OLD



NEW