Hi guys !

I'd like to manage the users of my tomcat JDBCRealm with hibernate. But i don't know if my mapping is true. Someone can help me ?


My mapping files :

<hibernate-mapping>
<class name="capgemini.gestionav.modele.valueobject.UtilisateurDTO" table="User">
<id name="nom">
<column name="User_Nom" length="32" not-null="true"/>
<generator class="assigned"/>
</id>
<property name="password">
<column name="User_Pass" length="32" not-null="true"/>
</property>
<set name="userroles" table="user_role" inverse="true" lazy="true">
<key column="User_Nom"/>
<many-to-many class="capgemini.gestionav.modele.valueobject.RoleDTO" column="Role_id"/>
</set>
</class>

<class name="capgemini.gestionav.modele.valueobject.RoleDTO" table="Role">
<id name="nom">
<column name="Role_Nom" length="32" not-null="true"/>
<generator class="assigned"/>
</id>
</class>

For those who don't know how work exactly the tomcat jdbc realm, you must have two tables like that :


create table users (
user_name varchar(15) not null primary key,
user_pass varchar(15) not null
);

create table user_roles (
user_name varchar(15) not null,
role_name varchar(15) not null,
primary key (user_name, role_name)
);