How do you write multi level fetch joins?

[Oddgeir B]

I have a query that I want to rewrite to use jinq.

SELECT a

INNER JOIN FETCH a.bs AS b

INNER JOIN FETCH b.cs AS c

I tried to do:

..streamAll(session, A.class)

.joinFetch(a -> JinqStream.from(a.getBs()) 

                         .join(b -> JinqStream.from(b.getCs() )

                )

This did not work...

Is it possible? If so, how?

I am currently using jinq-hibernate-legacy version 1.8.19 since I could not get 1.8.24 to work with Hibernate 5.1.

[Jinq]

It never occurred to me that you could chain JOIN FETCH like that. Does Hibernate even support that? 

Actually, now that I think about it, I did play with alternate syntaxes for join fetch in the past, and I might have chosen this syntax specifically because it prevents people from chaining join fetches for some reason. 

In any case, if it doesn't work, then it isn't supported.

[Oddgeir B]

Yes, Hibernate supports it. We use it a lot.