Dear all,

Maybe this is a db design problem.

I have a simple scenario and quite new to ORM concepts. There are 3 tables / entities in my demo app; 1) user, 2) group, 3) accessRule

1 user can have multiple group (ie. 1 to many relationships) and
1 group can have multiple accessRule (ie. 1 to many relationships)

so with my non ORM knowledge, I will create a secondary table to store the keys of the relations between "User" and "Group" ie.
user-group [user_id, group_id]

However, I was wondering if I could use a running number (generated id field) instead of using this approach.

ie. using the key of the secondary table "user-group" (an id field) to reference the "user" and "group" table

Please let me know if there is something wrong in my design (as I feel a bit strange using this approach, and no idea how to do the hibernate mapping config as well)

From Jason (Kusanagihk)

Could it be a "many-to-many" situation instead???

really confused.

I've found a tutorial similar to my situation
http://www.java2s.com/Code/Java/Hiberna ... ashMap.htm

but it is searchable on only 1 side (ie. in the tutorial's case, only employee is possible to search the benefits; but not possible to search employees from the benefits side)

Hi,

For many to many, it should be one user has many groups and one group has many users. Is your case one to many or many to many?