The situation is like this:
I have an entity Book that holds a one-to-many relationship with Chapter.
Now if I try the query,
Code:
from Book book inner join book.chapters chapter where chapter.title like '%hibernate%'
, it gives me the desired result.
But if I try,
Code:
from Book where book.chapters.title like '%hibernate%'
, I get the error
illegal attempt to dereference collection.The thing is that I only want the collection of Book objects in return and not a collection of pair of Book and Chapter objects in return which I get with the former query.
Could someone help me understand?