I've got a parent/child relationship where both tables/classes have a composite ID.

Both of the objects can be queried individually w/o error but I have problems when I try to create the parent/child relationship in the mapping.

I am getting this exception message:



However, I've done what it is telling me to do...as you can see below in my mapping files...

parent:



child:



Where do I go from here? I could not find a post in the forums that would clear this issue up for me...and I'm following the exact instructions from Hibernate In Action on how to do this...yet something is wrong.

Please advise! Thanks!

Hibernate version: 3.1

Name and version of the database you are using: MSSQL 2000

Here's one of my mapping files with composite keys. Does this help?

As long as I posted that, here's the other end of the relationship. Remember to make this one inverse.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.User" table="Users">
<cache usage="read-write" />
<id column="userName" name="userName" type="string">
<generator class="assigned" />
</id>
<many-to-one name="businessUnit" column="buName" cascade="save-update"
class="com.BusinessUnit" />
<property name="enabled" column="enabled" type="boolean" not-null="true"/>
<property name="firstName" column="firstName" type="string"
not-null="true"/>
<property name="lastName" column="lastName" type="string" not-null="true"/>
<property name="address" column="address" type="string"/>
<property name="city" column="city" type="string"/>
<property name="state" column="state" type="string"/>
<property name="zip" column="zip" type="string"/>
<property name="country" column="country" type="string"/>
<property name="phone" column="phone" type="string"/>
<property name="mobile" column="mobile" type="string"/>
<property name="email" column="email" type="string" not-null="true"
unique="true" />
<set name="groupMemberships" inverse="true" cascade="all-delete-orphan"
lazy="true">
<cache usage="read-write" />
<key column="userName" />
<one-to-many class="com.GroupMember" />
</set>
</class>
</hibernate-mapping>

hmm...sorry, can't see where that helps.

Everything works except the <bag> mapping on mine and yours does not contain a collection w/ a composite key, like mine does.

If I take the <bag> mapping out I can pull records...it works fine...but I'm obviously doing something wrong in the child collection mapping.

OK, got rid of the errors and am joining the two tables together but the join is wrong...but that's for another thread.

Thanks!