I've just upgraded from hibernate2.0 to hibernate2.0.3 and I'm getting a mapping exception where I did not before.

Prior to upgrading to hibernate2.0.3, no exception was thrown when parsing the mapping, but hibernate could not properly bind variables to the generated insert statement for the specific class. [I was planning on posting a question about this problem . . . and now I think it will be easier to explain].

The error I get is:


The mapping that I have is:


The problem that I have is that the class PersonTestSection has a composite id with two key-many-to-one components (PersonTestAdministration and TestAdministrationGradeTestSection), each of which includes in its primary key the same key-many-to-one component (TestAdministration). The mapping exception suggests that I change the mapping to add

I cannot do this to key-many-to-one components . . . the DTD does not allow it.

This seems to be a bug in hibernate -- not supporting this type of mapping for primary keys.

Unfortunately, in our application we are required to use complex composite keys (i.e., we don't have control over the schema and have lost the fight for generated primary keys) and we have lots of situations which result in this problem.

Any thoughts?

Thanks,

Sarah

As a follow-up to this issue, I also have the situation where the offensive columns are both a subset of a key-many-to-one component and a subset of a many-to-one component. In this case, how am I supposed to set the

properties for only a subset of the columns?

Thanks,
Sarah

I also have a simiilar problem with the following schema mapping because the country code and national number are declared twice.

<class name="VxsUserRegisteredPhone" table="vxs_user_registered_phone" discriminator-value="null">
<composite-id class="VxsUserRegisteredPhone$Key">
<key-property name="domainId" column="DOMAIN_ID" />
<key-property name="countryCode" column="COUNTRY_CODE"/>
<key-property name="nationalCode" column="NATIONAL_NUMBER"/>
</composite-id>
<many-to-one name="user" class="VxsUser" column="user_id" not-null="true"/>
<component name="phoneNumber" class="com.voxsurf.core.telephony.VxsPhoneNumber">
<property name="countryCode" column="COUNTRY_CODE"/>
<property name="nationalCode" column="NATIONAL_NUMBER" not-null="true"/>
</component>
</class>

What I'd really like is for the composite id to be able to contain a component...
<class name="VxsUserRegisteredPhone" table="vxs_user_registered_phone" discriminator-value="null">
<composite-id class="VxsUserRegisteredPhone$Key">
<key-property name="domainId" column="DOMAIN_ID" />
<component name="phoneNumber" class="com.voxsurf.core.telephony.VxsPhoneNumber">
<property name="countryCode" column="COUNTRY_CODE"/>
<property name="nationalCode" column="NATIONAL_NUMBER" not-null="true"/>
</component>
</composite-id>
<many-to-one name="user" class="VxsUser" column="user_id" not-null="true"/>
</class>

This doesn't look possible from the DTD. Is there another way?

Chris