[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1464) QueryException from Query.getReturnAliases when query uses "fetch"

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-1464.
-------------------------------


Closing stale resolved issues

> 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,

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira