[jbossseam-issues] [JBoss JIRA] Resolved: (JBSEAM-3643) "Group by" failed with paging

[Dan Allen (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBSEAM-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dan Allen resolved JBSEAM-3643.
-------------------------------

    Resolution: Done


Got it. The group by condition needs to become a distinct inside of the count() and the group by clause removed.

So for your query, it would be

select count(distinct book.name) from Book book

> "Group by" failed with paging 
> ------------------------------
>
>                 Key: JBSEAM-3643
>                 URL: https://jira.jboss.org/jira/browse/JBSEAM-3643
>             Project: Seam
>          Issue Type: Bug
>          Components: Framework
>    Affects Versions: 2.1.0.GA
>         Environment: JBoss 4.2.3GA, Seam 2.1.0GA,JDK 1.5.0_16
>            Reporter: Kenneth Zhang
>            Assignee: Dan Allen
>             Fix For: 2.1.2.CR1
>
>         Attachments: Book-sample-2-log.txt, Book-sample-2.zip
>
>
> GroupBy is a new function at seam 2.1.0GA's Query module, but it cannot work with paging.
> This is the test code:
> @Name("bookStat")
> public class BookStat extends EntityQuery<Book> {
>         private static final String EJBQL = "select name, count(*) from Book book";
>         (snip)
>         public BookStat() {
>                setEjbql(EJBQL);
>                setRestrictionExpressionStrings(Arrays.asList(RESTRICTIONS));
>                setMaxResults(3);
>                setGroupBy("name");
>          }
>         (snip)
> }
> There is the error log:
> 13:05:09,578 INFO  [STDOUT] Hibernate: 
>     select
>         count(*) as col_0_0_ 
>     from
>         test_seam.dbo.BOOK book0_ 
>     group by
>         book0_.name
> Caused by: javax.persistence.NonUniqueResultException: result returns 21 elements
> 	at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:85)
> 	at org.jboss.seam.framework.EntityQuery.initResultCount(EntityQuery.java:129)
> 	at org.jboss.seam.framework.EntityQuery.getResultCount(EntityQuery.java:120)
> 	at org.jboss.seam.framework.Query.getPageCount(Query.java:202)
> 	at org.jboss.seam.framework.Query.getLastFirstResult(Query.java:163)

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