| Map Key ManyToMany Relationships [message #734783] |
Sun, 09 October 2011 22:03  |
 Lucas Manzke
Messages: 2
Registered: October 2011 |
Junior Member |
|
|
Hey Guys,
I am new to EclipseLink and I am not making progress in solving the following problem.
I tried searching google, but I could not find a solution. Maybe I looked for the wrong keywords?
Anyways, here is the problem I am stuck with:
I am working on a little web application that is backed up by an EclipseLink persistence unit. I want users to be able to log into that application and organize in groups. However, this shall be optional, so a user can use that application without having to join any group. If they do, they will be assigned an access level inside of that group. Moreover, one user can join multiple groups, which makes this a classical ManyToMany relationship.
So this is what I imagine:
I have two entities, TUser (to avoid the user keyword) and UserGroup. They have some basic attributes, but these don't pose any problems to EclipseLink. But here comes the tough (for me) part:
I realized the rights inside a group via a HashMap. When a user joins the group or is manually assigned a certain access level, that access level (an Embeddable class only containing an int as an access mask) is associated with him in the HashMap via put(TUser, access).
Moreover, the user entity contains a list of the groups he or she is in.
What I would like EclipseLink to do is map that very list to the KeySet of the HashMap. The result I'd love to see is a table created with the two id's of the entities and the access mask that the user has inside a certain group.
Logically, I do not see a reason why this should not be possible.
I have tried something along the lines of
@Entity
public class UserGroup implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@MapKeyColumn
@JoinTable(joinColumns={@JoinColumn(name="groups")})
@ManyToMany(targetEntity=TUser.class, mappedBy="groups", cascade= CascadeType.ALL)
private Map<TUser, Integer> users;
@Entity
public class TUser implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
@ManyToMany(cascade= CascadeType.ALL)
private List<UserGroup> groups;
...
getters and setters omitted.
but this does not work.
After
TUser user = new TUser();
UserGroup group = new UserGroup();
group.addUser(user); //puts the user into the hashmap and adds the group to the user's group list via addGroup(this)
p.persist(group);
nothing happens (no entries in the database). There is no exception either, which leaves me clueless.
There is something I noticed though:
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'mapped_KEY' doesn't exist in table
Error Code: 1072
Call: ALTER TABLE USERGROUP ADD CONSTRAINT FK_USERGROUP_mapped_KEY FOREIGN KEY (mapped_KEY) REFERENCES TUSER (ID)
Query: DataModifyQuery(sql="ALTER TABLE USERGROUP ADD CONSTRAINT FK_USERGROUP_mapped_KEY FOREIGN KEY (mapped_KEY) REFERENCES TUSER (ID)")
I found the reason why the Database(mysql) complains:
The mapped_KEY column resides in the TUSER_USERGROUP table, not USERGROUP. Thus it fails.
My question: What do I do wrong? What is the solution to my problem?
Thanks for any help.
Best Regards,
Lucas
|
|
|
|
Powered by
FUDForum. Page generated in 0.03193 seconds
] 
Search
Help
Register
Login
Home
