Hi there,

Im working with hibernate3 and I just can't get my head round this mapping that I need to do:

I need to map one class to write to 2 different tables:
Class:
public class User {
private Long id;
private String username;
private String password;
private String role;

public String getRole() {
return role;
}
public void setRole(String role) {
this.role = role;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}

Table:
User_tbl

user_id int(8)
user_name varchar(50)
user_pass varchar(50)

User_Role_tbl

user_id int(8)
user_name varchar(50)
role_name varchar(50)

Can this be done and how?

Sorry, I messed up the post, the roles in the User class is actually a list. A user can have multiple roles. I got the previous post right using joins but I cant get it right with multiple roles

option 1)
one to many mapping
You should find an example for this in the Hibernate reference
option 2)
mapping of user to a component
there are also examples for this in the reference.

Regards Sebastian

your user class may have something line this in case of a seperate role entity

class User {
....
private Set<Role> roles ;

}

and mapping as

<set name="roles" cascade="all">
<key column="USER_ID" />
<one-to-many class="test.Role" />
</set>