I had assumed this would be a simple mapping (via XML) but it is eluding me so far.

Nutshell: table consists of userid, appid, roleid. I want each User to have a Map<App, List<Role>> where Apps and Roles are what you'd expect.

Is this possible? I've tried a lot of combinations and so far I've been SOL.

If this is a stupid mistake, cool; if it's a stupid question, not so cool, 'cuz I kinda want to do this.

TIA!

Dave

Map<App, List<Role>>

Have you tried just mapping the List<Role> and App as attributes by themselves, then adding some helper methods to the object which returns them as a Map<App, List<Role>>

No, I haven't, although I've been working on various workarounds... I'm open to any suggestions at this point. Also, not that it matters, I'm using Java 1.4 but illustrating with 1.5, so my generated classes don't necesarily give me the information I need without actually compiling and running them :/

One "problem" is that I'm using the Hibernate tools and would prefer neither to stop using them nor subclass a generated class, but it might come down to that.

This has been kicking my ass for a day now :/

Thanks,
Dave