[jbossseam-issues] [JBoss JIRA] Closed: (JBSEAM-2177) No easy way to add "join fetch" in ejbql in EntityQuery

No easy way to add "join fetch" in ejbql in EntityQuery ------------------------------------------------------- Key: JBSEAM-2177 URL: http://jira.jboss.com/jira/browse/JBSEAM-2177 Project: JBoss Seam Issue Type: Bug Components: Framework Affects Versions: 2.0.0.BETA1 Reporter: Yenan Zhou There is no easy way to add "join fetch" in ejbql in EntityQuery. The renderedEjbql is correct, but to count the number of the result, it gave: "select count(*) from A a inner join fetch a.b where ......", which was wrong. The countEjbql is calculated based on ejbql supplied by user, but the calculation didn't take "join fetch" issue into account. But that is crucial to avoid n+1 problem. Extension is possible, but is hardly clean.