Hi,

I just would like to know how to create a filter on a collection with a left join fetch clause in it so that hibernate will fetch all the information I need in the same sql statement.
I've looked in the documentation but I didn't find anything about it.
I've tried it in many different ways with no luck, such as:
"from this left join fetch this.rooms"
"from left join fetch this.rooms"
"from fetch this.rooms"

Please, is there a way to do it?

Thank you.

Luis Fernando

"left join fetch this.rooms"

(I think that will work, but not 100% sure)

Thanks for the reply, but it doesn't work.

Here is the stack trace:
net.sf.hibernate.QueryException: query must begin with SELECT or FROM: left [left join fetch this.rooms]
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:84)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.hql.FilterTranslator.compile(FilterTranslator.java:26)
at net.sf.hibernate.impl.SessionFactoryImpl.getFilter(SessionFactoryImpl.java:305)
at net.sf.hibernate.impl.SessionImpl.getFilterTranslator(SessionImpl.java:3452)
at net.sf.hibernate.impl.SessionImpl.filter(SessionImpl.java:3509)
at net.sf.hibernate.impl.SessionImpl.filter(SessionImpl.java:3404)

oh well, in that case its not possible .. use a full query instead.

lfkauer,
are you sure you've tried "select this from this left join fetch this.rooms" ??

just an idea.... i'm not sure

Anthony,

Thanks for the try, but it didn't work either.
I've already tried it in many different ways, but if you have any other ideas, I'll be glad to try them too.

Here is the stack trace:

net.sf.hibernate.QueryException: unexpected token: left [select this from this left join fetch this.rooms]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:77)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.hql.FilterTranslator.compile(FilterTranslator.java:26)
at net.sf.hibernate.impl.SessionFactoryImpl.getFilter(SessionFactoryImpl.java:305)
at net.sf.hibernate.impl.SessionImpl.getFilterTranslator(SessionImpl.java:3452)
at net.sf.hibernate.impl.SessionImpl.filter(SessionImpl.java:3509)
at net.sf.hibernate.impl.SessionImpl.filter(SessionImpl.java:3404)