Table maps back to itself?

jdcyuen · **Joined:** Sat Jul 08, 2006 2:58 pm **Posts:** 26

How would I do this?

Suppose I have a table called Person which has a column called Friends which is a set of Persons, like this:

Code:

Person {
  Long id
  Set<Person> friends;
       .
       .
       .
}

What would the mapping file look like? Is this a bad idea to do this??

MikePloed · **Posted:** Thu Jul 27, 2006 6:21 pm

This is no problem at all. Just map it as you would map any other set as described in
http://www.hibernate.org/hib_docs/v3/re ... l-join-12m

jdcyuen · **Joined:** Sat Jul 08, 2006 2:58 pm **Posts:** 26

So would the mapping file look like this?

Code:

<class name="Person">
    <id name="id" column="personId">
        <generator class="native"/>
    </id>
    <set name="friends" table="Person">
        <key column="personId"/>
        <element  type='long" column="Friends" unique="true" class="Person"/>
    </set>
</class>