I'm strageling with this for some time now, so please forgive me if it’s a stupid question.
I have two classes,
User with ID and name
And Message with text ,fromUser and toUser.
I write HBM files and run hbm2java and hbm2ddl to create .java and .sql files.
My question is: how do I define this relationship in the HBM so that in the java files I will have something like:
List<Message> list_1 = aUser.getSentMessages();
And
List<Message> list_2 = aUser.getReceived Messages();

What I tried is in Message.hbm.xml:
<many-to-one
name="fromUser"
class="User"
not-found="ignore"
fetch="join"
not-null="false" >
<column name="FROM_USER_ID" />
</many-to-one>

<many-to-one
name="toUser"
class="User"
not-found="ignore"
fetch="join"
not-null="false" >
<column name="TO_USER_ID" />
</many-to-one>

and in User.hbm.xml:
<set name="sentMessages" lazy="false" inverse="true">
<key column="USER_ID"/>
<one-to-many class="Message"/>
</set>

but this is clearly wrong.

Any suggestions will be highly appreciated

Thanks,
~Z

In the inverse relation (the one in user), you specify the foreign key column (that is, the column in the Message table that references the user entry).

it should be something like: