Hi I have 2 questions @ associations

1) I have 2 tables, TableOne and TableMany

TableOne has a composite key as shown below

<composite-id>

<key-property name="key1" column="PKCOLUMN1" />
<key-property name="key2" column="PKCOLUMN2" />

</composite-id>


TableMany has also a compositeKey as shown below

<composite-id>

<key-property name="key3" column="PKCOLUMN3" />
<key-property name="key1" column="PKCOLUMN1" />

</composite-id>

<property name="key2" column="PKCOLUMN2" />


Above tables are related by relation one to many.........now I have to define a relation between these 2 tables using key2 only.

In short we are trying to define a relation on part of the composite key........


2) Second question is, when we define 2 many-to-one association in one .hbm.xml file(as shown below) using same column , it

throws a error saying using a repeated column use insert="false" update="false"

<many-to-one name="association1" class="class1" insert="false" update="false" >
<column name="key1" />
<column name="key2" />
</many-to-one>


<many-to-one name="association2" class="class2" insert="false" update="false" >
<column name="key1" />
<column name="key3" />
</many-to-one>



hope i was clear enough to stae problem.....glad if any one can throw light on above 2 issues


Sudhir

Hi,

I try to answer your Q1.

You can not use a partial key to define an association unless that column maintains uniqueness property.

So may be you should try to make a unique index on key2. If it is not unique, you can not make association anyway.

Paul

Try using <formula> instead of <column> to define the associations:



generates DDL: