I am new to hibernate and not very clear about how mapping works.
I have a 'User' table and a 'Role' table.
User table has fields USERID, USERNAME, ROLEID.
Role table has ROLEID, ROLENAME.
User table has a foreign key reference to the 'ROLE' table (ROLEID).
I am not sure how would the mapping files and the POJO classes would go for both the USER and the ROLE table. Will they have <many-to-one> or <one-to-many> references in the mapping files (which mapping USER or ROLE).
Also, when I do session.load(User.class,userId); how do i get the ROLE NAME associated with that user. Just to remind USER table has a ROLE ID and not a ROLE NAME.
Please help with some code snippet for mapping files and the POJO class for the above example
Well, in your model, Role is the one side and User is the many. So in Role you use a OneToMany mapping to User, and in User you have a ManyToOne mapping to Role.
In your load to get the RoleName, you would probably call getRole from the loaded User class, and the return of that method is a Role object, and call getRoleName from that Role object.
0
