Hi,

i'm very new to Hibernate and need some help how to set up the following scenario:

I got a Class "User" with attributes
int userid
String prename
String lastname
User manager
List<User> employees

ID should be the primary key, prename / lastname should be the name and manager should be another user of this class type. The list employess should save this relation the other way and make it possible to access sub-ordinated employess from an user who is a manager.

everything seems to work fine, but i doesn't know how to set up this self-relation to another manager / employess.

sombebody got a hint for me ?
a user should have exactly one manager and could have other employess under himself.

thx in advance![/list][/list]

If you are using annotations and have the DB schema:

create table UserExample (
id integer not null auto_increment,
lastName varchar(255),
preName varchar(255),
manager_id integer,
primary key (id)
)

You can use the following annotations setup for your class:

@Entity
public class UserExample {

@Id @GeneratedValue(strategy=GenerationType.AUTO)
private Integer id = null;

@Column(length = 255, nullable = true)
String preName;

@Column(length = 255, nullable = true)
String lastName;

@ManyToOne(cascade={CascadeType.PERSIST, CascadeType.MERGE})
UserExample manager;

@OneToMany(mappedBy = "manager", fetch = FetchType.LAZY, cascade=CascadeType.ALL)
List<UserExample> employees;
}

thx for your assistance.
i'm using an hbm.xml configuration file to handle my project.
can you supply the correpsponding xml tags ?

thx in advance !