Hi!

I am having a problem with a many-to-many relationship.

First, the...
..(involved) DB-TABLES:

OFSUser -- (m:n) -- Role
An additional table, UserRole, is used to map the m:n relationship.


MAPPING FILE:
<class name="OFSUser" table="ofsuser">
<id column="id" name="id" type="long">
<generator class="native"/>
</id>
<property name="email" type="string">
<meta attribute="finder-method">findByMail</meta>
</property>
<property name="password" type="string"/>

<set name="roles" table="userrole" cascade="all">
<key column="userid"/>
<many-to-many column="roleid" class="edu.ofs.database.dto.Role"/>
</set>
</class>

<class name="UserRole" table="userrole">
<id column="userid" name="userid" type="long">
<generator class="native"/>
</id>
<property name="roleid" type="long"/>
</class>


<class name="Role" table="role">
<id column="id" name="id" type="long">
<generator class="native"/>
</id>
<property name="description" type="string">
<meta attribute="finder-method">findByDescription</meta>
</property>
</class>


RELEVANT JAVA SOURCE CODE:

OFSUser newuser = new OFSUser();
newuser.setEmail(mail);
newuser.setPassword(pw);

Set newroles = new HashSet();
// [...] add some new roles to the set

newuser.setRoles(newroles);
session.save(newuser);


THE PROBLEM:
The object OFSUser is stored correctly in the database (MySQL), but shouldn't a new entry to table UserRole be added automatically too, based on the many-to-many declaration? Maybe my mapping file is flawed or do I overestimate Hibernate's capabilities. Thus, it would be necessary to add a new entry to UserRole manually.

Thanks in advance + Regards,
- Markus

do you save those roles?

Hi!

Thanks for the immediate reply. That's terrific in this forum.

No, I don't save these roles explicitely. And I also don't want to save them. I just want to have these entries in UserRole.

The function this problems belongs to is "add a new user". so i only want to assign user to his roles, not add new ones in the DB.

Example:
new user(john@somedomain.com, mypassword) + selected role: CEO

Then I want hibernate to add an entry in UserRole, so
userid: 1 (for john) + role id 1 (for CEO)

Regards,
- Markus

but what are these roles? are you :
- instanciating new one
- retrieving the role and then adding the roles into the collection?

the second option:
retrieving the role and then adding the roles into the collection?