[jboss-user] [EJB 3.0] - Re: EJB QL requires useless item in select list

org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=c,role=null,tableName=Channel,tableAlias=channel1_,origin=Request request0_,colums={request0_.channel_FK ,className=com.telepathyproof.adventure.ejb.entity.channel.Channel}}] [select c.id, sum(se.currentListeners) from com.telepathyproof.adventure.ejb.entity.stats.Request r inner join fetch r.channel c left join fetch r.stats s left join fetch s.statsEntries se where r.createdDate > :startDate and r.createdDate < :endDate] at org.hibernate.hql.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:195) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3995017#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...