Return-Path: X-Original-To: apmail-openjpa-users-archive@minotaur.apache.org Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D132E18A4B for ; Wed, 17 Jun 2015 05:35:53 +0000 (UTC) Received: (qmail 18753 invoked by uid 500); 17 Jun 2015 05:35:48 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 18712 invoked by uid 500); 17 Jun 2015 05:35:48 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 18701 invoked by uid 99); 17 Jun 2015 05:35:48 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Jun 2015 05:35:48 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id CCE9CCE59E for ; Wed, 17 Jun 2015 05:35:47 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.233 X-Spam-Level: ** X-Spam-Status: No, score=2.233 tagged_above=-999 required=6.31 tests=[SPF_FAIL=0.919, URIBL_BLOCKED=0.001, URI_HEX=1.313] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id Y20WXlCESzwa for ; Wed, 17 Jun 2015 05:35:39 +0000 (UTC) Received: from mwork.nabble.com (mwork.nabble.com [162.253.133.43]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTP id 0CFB243AC7 for ; Wed, 17 Jun 2015 05:35:38 +0000 (UTC) Received: from mjim.nabble.com (unknown [162.253.133.84]) by mwork.nabble.com (Postfix) with ESMTP id E500B2118FF6 for ; Tue, 16 Jun 2015 22:35:31 -0700 (PDT) Date: Tue, 16 Jun 2015 22:35:31 -0700 (MST) From: zhourui To: users@openjpa.apache.org Message-ID: <1434519331488-7588297.post@n2.nabble.com> Subject: group by error with empty table. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable with the apache-openjpa-2.4.1-20150608.073929-5-binary.zip CriteriaBuilder cb =3D em.getCriteriaBuilder(); CriteriaQuery cq =3D cb.createQuery(Tuple.class); Root root =3D cq.from(ReadCompleted.class); Predicate p =3D cb.equal(root.get(ReadCompleted_.person), person); javax.persistence.criteria.Path applicationNamePath =3D root.get(ReadCompleted_.applicationName); Expression countPath =3D cb.count(root); cq.multiselect(countPath, applicationNamePath).where(p).groupBy(applicationNamePath); if the table of ReadCompleted is empty, it is error: Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][4.13.127] =E6=93=8D=E4=BD=9C=E6=97=A0=E6=95=88=EF= =BC=9A=E5=B7=B2=E5=85=B3=E9=97=AD result set=E3=80=82 ERRORCODE=3D-4470, SQLSTATE=3Dnull =09at com.ibm.db2.jcc.am.id.a(id.java:661) =09at com.ibm.db2.jcc.am.id.a(id.java:60) =09at com.ibm.db2.jcc.am.id.a(id.java:103) =09at com.ibm.db2.jcc.am.bo.Db(bo.java:4599) =09at com.ibm.db2.jcc.am.bo.r(bo.java:4556) =09at com.ibm.db2.jcc.am.bo.f(bo.java:1399) =09at com.ibm.db2.jcc.am.bo.getObject(bo.java:1391) =09at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.j= ava:325) =09at org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.j= ava:325) =09at org.apache.openjpa.lib.jdbc.DelegatingResultSet.getObject(DelegatingResultS= et.java:269) =09at org.apache.openjpa.jdbc.sql.DBDictionary.getObject(DBDictionary.java:916) =09at org.apache.openjpa.jdbc.sql.ResultSetResult.getObjectInternal(ResultSetResu= lt.java:449) =09at org.apache.openjpa.jdbc.sql.AbstractResult.getObject(AbstractResult.java:69= 1) =09at org.apache.openjpa.jdbc.kernel.exps.UnaryOp.load(UnaryOp.java:120) =09at org.apache.openjpa.jdbc.kernel.ProjectionResultObjectProvider.getResultObje= ct(ProjectionResultObjectProvider.java:78) =09at org.apache.openjpa.slice.jdbc.UniqueResultObjectProvider.next(UniqueResultO= bjectProvider.java:97) =09at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.next(QueryI= mpl.java:2085) =09at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:34) =09... 58 more org.apache.openjpa.persistence.PersistenceException: [jcc][t4][10120][10898][4.13.127] =E6=93=8D=E4=BD=9C=E6=97=A0=E6=95=88=EF= =BC=9A=E5=B7=B2=E5=85=B3=E9=97=AD result set=E3=80=82 ERRORCODE=3D-4470, SQLSTATE=3Dnull =09at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:500= 1) =09at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.jav= a:4961) =09at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.j= ava:574) =09at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133) =09at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) =09at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) =09at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedExce= ption(SelectResultObjectProvider.java:154) =09at org.apache.openjpa.slice.jdbc.UniqueResultObjectProvider.handleCheckedExcep= tion(UniqueResultObjectProvider.java:76) =09at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheck= edException(QueryImpl.java:2109) =09at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:39) =09at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1250) =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1006) =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:862) =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:793) =09at org.apache.openjpa.slice.DistributedQueryImpl.execute(DistributedQueryImpl.= java:61) =09at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541) =09at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274) =09at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290) =09at com.x.processplatform.assemble.surface.task.jaxrs.task.TaskAction.countWith= Application(TaskAction.java:304) =09at com.x.processplatform.assemble.surface.task.jaxrs.task.TaskAction.countWith= Application(TaskAction.java:142) =09at sun.reflect.GeneratedMethodAccessor89.invoke(Unknown Source) =09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp= l.java:43) =09at java.lang.reflect.Method.invoke(Method.java:497) =09at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerF= actory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) =09at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispat= cher$1.run(AbstractJavaResourceMethodDispatcher.java:164) =09at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispat= cher.invoke(AbstractJavaResourceMethodDispatcher.java:181) =09at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProv= ider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.jav= a:158) =09at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispat= cher.dispatch(AbstractJavaResourceMethodDispatcher.java:101) =09at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMeth= odInvoker.java:389) =09at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMetho= dInvoker.java:347) =09at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMetho= dInvoker.java:102) =09at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:30= 5) =09at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) =09at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) =09at org.glassfish.jersey.internal.Errors.process(Errors.java:315) =09at org.glassfish.jersey.internal.Errors.process(Errors.java:297) =09at org.glassfish.jersey.internal.Errors.process(Errors.java:267) =09at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.= java:317) =09at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:288) =09at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.ja= va:1110) =09at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:4= 01) =09at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java= :386) =09at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java= :335) =09at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java= :222) =09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterChain.java:291) =09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:206) =09at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52= ) =09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterChain.java:239) =09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:206) =09at com.x.common.core.application.jaxrs.AbstractJaxrsFilter.doFilter(AbstractJa= xrsFilter.java:32) =09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio= nFilterChain.java:239) =09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC= hain.java:206) =09at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.j= ava:219) =09at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.j= ava:106) =09at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBas= e.java:502) =09at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:14= 2) =09at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79= ) =09at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogV= alve.java:617) =09at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.jav= a:88) =09at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) =09at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Proc= essor.java:1091) =09at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(Abstra= ctProtocol.java:668) =09at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.ja= va:2463) =09at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java= :2452) =09at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1= 142) =09at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:= 617) =09at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.j= ava:61) =09at java.lang.Thread.run(Thread.java:745) if the table is not empty. it is work fine. -- View this message in context: http://openjpa.208410.n2.nabble.com/group-by-= error-with-empty-table-tp7588297.html Sent from the OpenJPA Users mailing list archive at Nabble.com.