mapping entity to itself?

shredit · **Joined:** Wed Jun 30, 2004 11:00 am **Posts:** 7

Is it possible to map an entity to itself with hibernate? I've searched the forums but haven't seen any mention to this.

I have a table MESSAGE (pk MESSAGE_ID). It contains an optional column named PARENT_MESSAGE_ID. I'd like to create relationship off of Message called "messageReplies" which would basically fetch all Messages that have a PARENT_MESSAGE_ID equal to this message's MESSAGE_ID.

It seems hibernate is very strict about pk/fk key names. It is possible to create a relationship like this?

Thanks in advance.

christian · **Posted:** Thu Jul 08, 2004 12:32 pm

Thats easy:

Code:

<class name="Message">
    <id .../>
    <many-to-one name="parentMessage" column="PARENT_MSG_ID"/>
    <set name="childMessages>
        <key column="PARENT_MSG_ID"/>
        <one-to-many class="Message"/>
    </set>
</class>

shredit · **Joined:** Wed Jun 30, 2004 11:00 am **Posts:** 7

Yeah, that worked perfectly. I felt like i had the relationhiped previoulsy mapped like that, but something exploded. Could have been related to something else.

Thanks for the quick reply. And sorry again for the noise.