Hi guys,
I have an object.
This object holds reference to another object.

I would like to set the foreign key of the containing object to
any field of the contained object.

How could be this done in the mapping xml file ?

The problem is that when Hibernate sets the foreign key of the containig object to the primary key of the contained object.

This is a sample of the mapping xml file I use.

<hibernate-mapping>

<class name="xxx.xx.ContainingObject" table="XXX">
<id name="id" column="id" type="long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">XXX</param> <!-- nom de la sequence utilisee -->
</generator>
</id>
.
.
.
<set name="YYY" inverse="true" lazy="false" cascade="all-delete-orphan" where="clause where">
<key column="KEY TO BE SET"/>
<one-to-many class="xxx.xx.ContainedObject"/>
</set>

</hibernate-mapping>


What I want is th set the KEY TO BE SET value to a different field than
primary key of the contained object.

Any idea haw this could be done ?

Thank you.
moh.

Use a property-ref.

how?

thanks

As described in the reference documentation.

property-ref doesn't exist in
<one-to-many .....>
?

I don't see your problem, have you tried simply setting the <key> column to the column you want?

example file maping
<hibernate-mapping>

<class name="A" table="A">
<id name="id" column="id" type="long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">id</param> <!-- nom de la sequence utilisee -->
</generator>
</id>
<property name="b" column="B"/>
<property name="c" column="C"/>

<set name="listD" inverse="true" lazy="false" cascade="all-delete-orphan" >
<key column="d_code" />
<one-to-many class="D" />
</set>

</class>

the probleme may column d_code is refer to column c and not column id
of a ?

This is not possible. Use a query.

You might want to give this Jira Issue a vote:
http://opensource.atlassian.com/project ... key=HB-806

It's currently rejected, but who knows, if enough people ask for it something might happen. :)

thanks with query its work