Hi ;)
I´m using Hibernate 2.8.1 and MicrosoftSQL-Server.
My problem:
I have two tables with a one-to-many relation:

Table 1
Name: Adressen
Primary Key: __Org_RecordNo
column:Name (String36)
column:Number(int)

Table2
Name: Ansprechpartner
Primary Key: __Org_RecordNo
Foreign Key: AdressID
Column: Name(String36)

if i use the "normal" mapping the relation looks like this:
Mapping for Adressen:
...
<set inverse="true" name="AnsprechpartnerSet">
<key column ="AdressID"/>
<one-to-many class="Ansprechpartner"/>
</set>
I think that works fantastic. Now comes the PROBLEM:
The return-mapping from Ansprechpartner:
...
<many-to-one
name="Adressen"
column="AdressID"
class="Adressen"/>

That means, AdressID from Ansprechpartner references to __Org_RecordNo(PrimaryKey) from Adressen. But it have to show to the column Number of Adressen not to the primary key...a little confuse..but thats the given situation..
Ah..and it´s not allowed to me to make any changes on database...so i can just make it on mapping-file...

How can i map this?

Ok...i got it...
there is a property-ref-Tag to reference to a column wich is not PrimaryKey.
Now it looks like that ;)

<set name="AnsprechpartnerSet" property-ref="Id">
<key column ="AdressID"/>
<one-to-many class="Ansprechpartner"/>
</set>

This doesn't work in 3.0 BTW.

<set name="AnsprechpartnerSet" property-ref="Id">
<key column ="AdressID"/>
<one-to-many class="Ansprechpartner"/>
</set>

property-ref is not allowed there. I'm trying to do a similar thing, if anyone has any suggestions.

does work