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 6CDCF60BD for ; Fri, 24 Jun 2011 09:40:56 +0000 (UTC) Received: (qmail 56929 invoked by uid 500); 24 Jun 2011 09:40:56 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 56663 invoked by uid 500); 24 Jun 2011 09:40:50 -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 56653 invoked by uid 99); 24 Jun 2011 09:40:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jun 2011 09:40:47 +0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FREEMAIL_FROM,RFC_ABUSE_POST,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.236.26 is neither permitted nor denied by domain of yazuna@gmail.com) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jun 2011 09:40:42 +0000 Received: from jim.nabble.com ([192.168.236.80]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1Qa2s9-0004Uu-8d for users@openjpa.apache.org; Fri, 24 Jun 2011 02:40:21 -0700 Date: Fri, 24 Jun 2011 02:40:21 -0700 (PDT) From: Krzysztof To: users@openjpa.apache.org Message-ID: <1308908421248-6511427.post@n2.nabble.com> In-Reply-To: <1308908421261-6500387.post@n2.nabble.com> References: <1308908421261-6500387.post@n2.nabble.com> Subject: Re: OpenJPA 1.2.2 - setFirstResult/setMaxResults not working for ORACLE 11g MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, This query looks ok, this is standard trick to get paged results in Oracle the fastest possible way, known for many years. check i.e. : http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:127412348064 Cheers, Krzysztof -- View this message in context: http://openjpa.208410.n2.nabble.com/OpenJPA-1-2-2-setFirstResult-setMaxResults-not-working-for-ORACLE-11g-tp6500387p6511427.html Sent from the OpenJPA Users mailing list archive at Nabble.com.