I am trying to confirm the syntax for a multi-level join using criteria query (all examples I have seen so far are for a single join). I am writing a forum application, where one forum contains multiple threads and one thread contains multiple posts. Given a forum id, I would like to write a criteria query which returns the forum along with all its threads and posts. This is how I have specified the query right now:



This seems to work, I am getting everything in one fetch, but not sure if setFetchMode("threads.posts", FetchMode.JOIN) is the right way to specify the eager fetch for posts.

Please help.
Naresh

Can someone please confirm that setFetchMode("threads.posts", FetchMode.JOIN) is a valid way to specify left outer join in the example I posted earlier?

In the meanwhile, I tried to assemble the criteria query slightly differently - see below. I thought that this would also fetch forums, threads and posts in one hit, but it doesn't - it actually makes two hits.



Here are the two hits to the database:



Can anyone tell why this version generates two queries? Also why is thread joined with inner join instead of outer join?

Thanks.
Naresh