• Post Reply Bookmark Topic Watch Topic
  • New Topic

Hibernate (HQL) and many-to-many issues

 
Michael Stringham
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Luis Casanueva
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
try

String sql = = "select user from User as user where "+groupID+" not in elements (user.groupsInternal)";

No need to have an object to represent the tt_usergroup table

I found this in the book Harnessing Hibernate. Highly recomended

Cheers,

Luis Casanueva
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!