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 1DAC410CD4 for ; Mon, 27 Apr 2015 13:32:19 +0000 (UTC) Received: (qmail 18510 invoked by uid 500); 27 Apr 2015 13:32:19 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 18469 invoked by uid 500); 27 Apr 2015 13:32:19 -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 18458 invoked by uid 99); 27 Apr 2015 13:32:18 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Apr 2015 13:32:18 +0000 X-ASF-Spam-Status: No, hits=1.3 required=5.0 tests=SPF_PASS,URI_HEX X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: message received from 54.164.171.186 which is an MX secondary for users@openjpa.apache.org) Received: from [54.164.171.186] (HELO mx1-us-east.apache.org) (54.164.171.186) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Apr 2015 13:32:12 +0000 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 BBAE945413 for ; Mon, 27 Apr 2015 13:31:51 +0000 (UTC) Received: from mjim.nabble.com (unknown [162.253.133.84]) by mwork.nabble.com (Postfix) with ESMTP id EE7351C3E76B for ; Mon, 27 Apr 2015 06:32:31 -0700 (PDT) Date: Mon, 27 Apr 2015 06:31:50 -0700 (MST) From: zhourui To: users@openjpa.apache.org Message-ID: <1430141510788-7588024.post@n2.nabble.com> Subject: how to use orderBy clause in tuple query? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R org.apache.openjpa.persistence.InvalidStateException: =E4=BD=BF=E7=94=A8=E8=BF=87=E6=BB=A4=E5=99=A8=E2=80=9Cnull=E2=80=9D=E5=AF= =B9=E5=80=99=E9=80=89=E7=B1=BB=E5=9E=8B=E2=80=9Cjavax.persistence.criteria= =E2=80=9D=E6=89=A7=E8=A1=8C=E4=BA=86=E6=AD=A4=E6=9F=A5=E8=AF=A2=EF=BC=8C=E5= =8C=85=E6=8B=AC=E5=B0=86=E5=A4=9A=E4=B8=AA=E6=9F=A5=E8=AF=A2=E7=9A=84=E7=BB= =93=E6=9E=9C=E5=90=88=E5=B9=B6=E5=9C=A8=E5=86=85=E5=AD=98=E4=B8=AD=E3=80=82= =E6=82=A8=E5=B7=B2=E9=80=89=E6=8B=A9=E5=AF=B9=E2=80=9C=E2=80=9D=E4=B8=8A=E7= =9A=84=E7=BB=93=E6=9E=9C=E8=BF=9B=E8=A1=8C=E6=8E=92=E5=BA=8F=EF=BC=8C=E4=BD= =86=E5=B0=9A=E6=9C=AA=E5=9C=A8 setResult() =E5=AD=90=E5=8F=A5=E4=B8=AD=E9=80=89=E6=8B=A9=E6=AD=A4=E6=95=B0= =E6=8D=AE=E3=80=82=E8=AF=B7=E5=B0=86=E6=AD=A4=E6=8E=92=E5=BA=8F=E6=95=B0=E6= =8D=AE=E5=8C=85=E5=90=AB=E5=9C=A8 setResult() =E4=B8=AD=EF=BC=8C=E4=BB=A5= =E4=BE=BF OpenJPA =E5=8F=AF=E4=BB=A5=E6=8A=BD=E5=8F=96=E6=AD=A4=E6=95=B0=E6= =8D=AE=E4=BB=A5=E8=BF=9B=E8=A1=8C=E5=86=85=E5=AD=98=E4=B8=AD=E6=8E=92=E5=BA= =8F=E3=80=82 [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.getOrderin= gValue(ExpressionStoreQuery.java:837) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.OrderingMergedResultObjectProvider.getOrderingVal= ue(OrderingMergedResultObjectProvider.java:62) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.lib.rop.MergedResultObjectProvider.next(MergedResultObje= ctProvider.java:172) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.next(QueryI= mpl.java:2087) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:35) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.slice.DistributedQueryImpl.execute(DistributedQueryImpl.= java:61) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302) [15-4-27 21:18:26:952 CST] 000000d7 SystemErr R =09at com.ibm.ws.persistence.QueryImpl.getResultList(QueryImpl.java:118) CriteriaBuilder cb =3D em.getCriteriaBuilder(); CriteriaQuery cq =3D cb.createQuery(WrapOutCompany.class); Root root =3D cq.from(Company.class); Predicate p =3D cb.equal(root.get(Company_.level), 1); cq.multiselect(root.get(Company_.id), root.get(Company_.name), root.get(Company_.unique), root.get(Company_.level), root.get(Company_.superior)); cq.where(p); cq.orderBy(cb.asc(root.get(Company_.name))); return em.createQuery(cq).getResultList(); use tuple query, where with orderBy clause,it's throw exception, but without orderBy clause,it's work fine. how to use orderBy clause in tuple query? -- View this message in context: http://openjpa.208410.n2.nabble.com/how-to-us= e-orderBy-clause-in-tuple-query-tp7588024.html Sent from the OpenJPA Users mailing list archive at Nabble.com.