QueryException from Query.getReturnAliases when query uses "fetch" ------------------------------------------------------------------ Key: HHH-1464 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1464 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.1.2 Environment: Hibernate 3.1.2 OSX 10.3.9 Java 1.4.2 Reporter: Loren Rosen Assignee: Steve Ebersole Fix For: 3.2.0.alpha1, 3.1.3 Attachments: Main.java Calling Query.getReturnAliases on a query containing a join fetch results in a QueryException. This also happens for Query.getReturnTypes. Here's the stack trace: [java] Exception in thread "main" org.hibernate.QueryException: fetch may not be used with scroll() or iterate() [from org.hibernate.auction.AuctionItem item left join fetch item.bids bid left join fetch bid.bidder order by item.ends desc] [java] at org.hibernate.hql.ast.tree.FromElement.setFetch(FromElement.java:391) [java] at org.hibernate.hql.ast.tree.FromElementFactory.createCollection(FromElementFactory.java:218) [java] at org.hibernate.hql.ast.tree.DotNode.dereferenceCollection(DotNode.java:262) [java] at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:200) [java] at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:94) [java] at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:313) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3268) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3060) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2938) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) [java] at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158) [java] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109) [java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75) [java] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54) [java] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) [java] at org.hibernate.impl.SessionFactoryImpl.getReturnAliases(SessionFactoryImpl.java:622) [java] at org.hibernate.impl.AbstractQueryImpl.getReturnAliases(AbstractQueryImpl.java:156) [java] at org.hibernate.auction.Main.viewAllAuctionsSlow(Main.java:52) [java] at org.hibernate.auction.Main.main(Main.java:158) I've attached an example; it's a slightly modified version of the Main class from the auction example in the hibernate distribution. There's nothing particularly special about it -- so far as I know any call to getReturnAliases with a query containing fetch results in the same exception. Note that a feature in the Hibernate Tools Eclipse plugin relies on getReturnAliases working consistently,