I am using the "petclinic" app to learn more about Hibernate and Spring MVC (Hibernate3, and Spring 2.5). It works beautifully, and now I'm customizing/extending this app...
Simply: I have a USER table (tt_user) and a GROUP table (tt_group), and a USERGROUP many-to-many relationship table (tt_usergroup).
I want a list of users that have not yet been added to a given group. Here is the SQL:
My HQL conversion went something like this:
I realized that I may need to have an object to represent the tt_usergroup table, so I created UserGroup. But do I need to? Up until now I haven't needed an explicit object for this table...
Here are my hibernate mappings for User and Group:
At this point, I tried to create a class mapping for the UserGroup object/table:
but that didn't work... it has 2 keys (the only 2 fields in the table...)
Perhaps this approach is wrong?
[ November 07, 2008: Message edited by: Michael Stringham ]
[ November 07, 2008: Message edited by: Michael Stringham ]