Hibernate version: 2.17

Hi,
I would like to know what's the common practice in handling this requirement: I need to associate the same class twice with one-to-one relationship.

For example, I have class 'File', which has two properties: submitter and lockedBy, both points to a class User.

Mapping documents:

<class name="File" ...>
......
<one-to-one name="submitter" column=".." class="User"/>
<one-to-one name="lockedBy" column=".." class="User"/>
</class>


I do not think we can do this right ?

thanks in advance for your help !

lixin

correction: it should be two <many-to-one> relationship, not one-to-one.

Sure you can do that with 2 many-to-ones:

Thank Steve. It is that simple !

one question, this only works with many-to-one, not many-to-many, not one-to-many right ?

You can do it with any multiplicity *other than one-to-one*. It does not make sense for one-to-one...

thank you very much !