Hibernate version: hibernate2.0 http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd

Here is what i've tried:
a) <composite-id
name="id"
class="edu.mnscu.housing.vo.RCCampusPK"
>

<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="tech_id"
/>
<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="rc_id"
/>

...
</composite-id>

I'm getting "Configuration problem: Foreign key (admin_rc_campus [tech_id])) must have same number of columns as the referenced primary key (cr_reporting [tech_id,rc_id])" . It seems to me the second id (ie. "rc_id") is not recognized.


b) if put two ids in one <key-many-to-one>,

<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="tech_id,rc_id"
/>

I'm still seeing the disbelievable errors:
"Configuration problem: Foreign key (admin_rc_campus [tech_id,rc_id])) must have same number of columns as the referenced primary key (cr_reporting [tech_id,rc_id])" .

Is this a known issue or what should i do to get around this ?

well, I'm getting the same result as case a). - the second 'rc_id' is ignored.

"Foreign key (admin_rc_campus [tech_id])) must have same number of columns as the referenced primary key (cr_reporting [tech_id,rc_id])"

I just realized that the change doesn't take effect if i manually change the .hbn.xml in war file under *.ear file in jboss /deploy. So actually xdoclet can't generate two <key-many-to-one> in <composite-id> , and can't recognize the non-attribute 'column' .

Here is what i've tried:

1. The goal is to generate :
----
<composite-id
name="id"
class="edu.mnscu.housing.vo.RCCampusPK"
>

<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="tech_id"
/>
<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="rc_id"
/>
....
</composite-id>

------
//xdoclet
/**
*@hibernate.many-to-one class="edu.mnscu.housing.vo.Campus" column="tech_id" not-null="true"
*@hibernate.many-to-one class="edu.mnscu.housing.vo.Campus" column="rc_id" not-null="true"
*/
//file .hbn.xml generated --- missing another <key-many-to-one> for 'rc_id'.
<composite-id
name="id"
class="edu.mnscu.housing.vo.RCCampusPK"
>

<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="tech_id"
/>

...
</composite-id>
2. The goal is to generate the following mapping:
---
<composite-id name="id"
class="edu.mnscu.housing.vo.RCCampusPK">
<key-many-to-one name="campus"
class="edu.mnscu.housing.vo.Campus"
<column name="tech_id"/>
<column name="rc_id"/>
</key-many-to-one>
...
</composite-id>
---
//xdoclet
/**
*@hibernate.many-to-one class="edu.mnscu.housing.vo.Campus"
*@hibernate.column="tech_id" not-null="true"
*@hibernate.column="rc_id" not-null="true"
*/
//file generated -- didn't recognize the 'column' , set the default name 'campus' to column.
<composite-id
name="id"
class="edu.mnscu.housing.vo.RCCampusPK"
>

<key-many-to-one
name="campus"
class="edu.mnscu.housing.vo.Campus"
column="campus"
/>
...
</composite-id>

It works for me if just one column in <composite-id> .<many-to-one>. not the case if a nested composite-id (ie. more than one columns ) in <composite-id>.<many-to-one>. Am i missing something?