Hi,

I have a model where there is a relationship between users and roles but the roles are determined by firm. So for example a user u1 is associated with firm f1 and have roles r1, r2. The same user u1 could also be associated with f2 and u1 would have roles r3, r4 for that relationship. In Java I would like to map this as a Map<Firm, List<Role>> from the User class. Is this possible and how can it be done?

Many Thanks in advance

Ted

I'm not very sure, but probably something like this:



This might help you http://ndpsoftware.com/HibernateMappingCheatSheet.html

Another solution would be to have the RoleInFirm intermediary class used to encode/decode Map<Firm, List<Role>>.

Hope it helps...

Thanks Cristian, it turns out that you can't map collections of collections so instead I created link table as a first class object, one for each user/firm combination, and created a many to many link between this and the roles table (via another join table).