Hello everybody

I've a many-to-many connection with the objects User and Role. The appropriate part of the xml-configuration file of User is as follows:


What I want is to create a query that returns the User objects that have a specific role. It should look like following:


Unfortunately the documentation lacks a little bit concerning queries with that kind of collections.

Could somebody give me a hint on this?

Hi,

One way is:

session.createQuery("Select u FROM User u INNER JOIN u.Roles r WHERE r.Name = :roleName")

Hope this helps!


Shawn

Hello,

no that does not help because Roles is a collection of Role objects. When I execute the query I get
[/quote]

The exception message you have indicates that the query you're testing is *not* the same as the query suggested by shware.

He is saying to use



instead of the query you've used



The important distinction is the join.

Cheers,

Symon.

Thanks to both of you. It's working now!