I am looking for an example of reflexive many-to-many relation.

Let say i have a table User.

User:

id: int primary key
name: varchar2
surname: varchar2

and the relation table UserFriends

UserFriends:

userid: int foreign key
friendid: int foreign key

How could i map this ?

Thanx for your suggestion. :)

i dont know what you mean by "reflexive"
bute here is the ref doc for many to many

http://www.hibernate.org/hib_docs/v3/reference/en/html/associations.html#assoc-unidirectional-join-m2m

Thanx for your answer scarface :)

In fact what i mean with 'reflexive' is a relation many-to-many with
the same table:

for example, in a entity, relation schema, it could be

-------------------
PERSON | <--- The entity
-------------------
| {0,n} | {0,n}
| |
| |
( Is Friend of ) <--- The relation


A person P1 could have friends (persons P2,P3,P4).
Person P2 could have no friend.
Person P3 could have friends (persons P4,P5).
ans so on ...

I have found what an answer to my problem.
In fact this special kind of many-to-many can be map
in the same way other many-to-many.

Still Thanx