0 Replies Latest reply on Oct 29, 2008 6:46 AM by kenneth zhang

    Bug report:  "Group by" failed with paging (Seam 2.1.0GA)

    kenneth zhang Newbie
      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)

      I have reported this issue. Please resolve it asap, thanks.

      https://jira.jboss.org/jira/browse/JBSEAM-3643