HQL to Many To Many

PRE · **Joined:** Thu Jan 12, 2006 5:22 pm **Posts:** 6

Hello!

I have a many-to-many relashionship: Principal <-> Roles. How can I use HQL to get all the Roles from a particular Principal? I am doing this:

Quote:

from Roles e where e.Principals.Id = 1

All the properties in the HQL exist. This does not work, how can I do what I want?

Thanks

dado2003 · **Posted:** Fri Apr 14, 2006 4:04 am

from Roles e inner join e.Principals p where p.Id = 1

or

select elements (p.Roles) from Principal p where p.Id = 1

The reason your query does not work is that you cannot traverse collection association with . (dot). So book.Pages.PageNumber is not correct becase Pages is a collection, but book.Author.OriginCountry.Name is correct because all are many-to-one..