ManyToMany from the same table?

jonycus · **Joined:** Tue Mar 30, 2010 2:10 pm **Posts:** 4

Perhaps this question has been asked before, however I was unable to find an answer in the forum.

The problem is the following:

I have a class that says the folowing

Code:

public class User {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Basic(optional = false)
@Column(name = "ID")
private Integer id;
@ManyToMany
List<Users> friends;
@ManyToMany
List<Users> friendsRequests;
...

How do I specify that the friends are saved in the FRIENDS table, and the friendsRequests are saved in the FRIENDSREQUESTS table?

Given the current code, hibernate creates USERS_USERS table which does not distinguish the FRIENDS from the FRIENDSREQUESTS....

Thanks in advance...

Vasko

hallmit · **Posted:** Wed Mar 31, 2010 7:44 am

hi, did you try this?

Code:

@ManyToMany
@JoinTable(name = "user_to_friendsusers")
List<Users> friends;
@ManyToMany
@JoinTable(name = "user_to_friendsrequest")
List<Users> friendsRequests;

jonycus · **Joined:** Tue Mar 30, 2010 2:10 pm **Posts:** 4

Yes, I did try that and it did not work.. However, it was my mistake because I did not drop the original Users table, so Hibernate tried just an update, regarding it as its an default operation in my persistence.xml... After I dropped the Users table it worked like a charm... :)

Thanks anyway for the reply...