Association mapping on the same table

kalyancbabu · **Posted:** Fri Jun 01, 2007 9:52 am

Is it possible to create a mapping association on same table?

I have a user table. The user has friends and this friend is nothing but a user.

Is it possible to do it?

imosquer · **Joined:** Tue May 08, 2007 12:25 am **Posts:** 18

check message below

imosquer · **Joined:** Tue May 08, 2007 12:25 am **Posts:** 18

this is possible with a one-to-many relationship. You will however need a table which carries both values.

Code:

<class name="User" table="user">
    <id name="id" column="userId">
        <generator class="native"/>
    </id>
    <set name="friends" table="users_friends">
        <key column="user_id"/>
        <many-to-many column="friend_id"
            unique="true"
            class="User"/>
    </set>
</class>

Notice that by specifying unique="true", we have changed the multiplicity from many-to-many to one-to-many.

hope this helps. let me know =)

kalyancbabu · **Posted:** Sat Jun 02, 2007 3:49 am

Hey it resolved my problem.
Thanks for the quick reply.

mbbsabroad · **Joined:** Sat Jun 02, 2007 5:57 am **Posts:** 1

Hi,

If u are looking to study medicine in some of the best universities in China,
That too when they teach medicine in English,
and also get an oppurtunity to do a part of Clinicals in USA, at a cost 1/5'th of that of USA Medical schools.
Study Medicine in China

Visit: www.chinambbs.com
www.allianceedu.com