[b]Hibernate version:2.1.4[/b]

How can I design following relation.
I have parent table with fields id(PK),id2,...
I have chield table with feilds id2(PK),id3(PK),fld1,fld2,...
chield table should be linked with parent by id2 field (which is not Primary Key). how should be described relation in parent.hbm.xml
I tried many combinations like this:

<set
name="children"
lazy="true"
inverse="true"
>
<key>
<column name="id2" />
</key>
<one-to-many
class="com.*.persistence.Chield"
/>
</set>
but in any case HSQL query "select Parent FROM Parent left join fetch Chield"
leads to link between parent.id=chield.id2 (I need parend.id2=chield.id2)

See this forum post & reply:

http://forum.hibernate.org/viewtopic.php?t=933550

It is not possible with one-to-many mapping. child should have a foreign key that references to the parent primary key.

Let's try to replace one-to-many mapping by many-to-one in parent:


your child mapping should look like:

if does not work, try this for child mapping:

and please use [code] tags for your mappings, it makes them more readable ;)