Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Fri, 22 Mar 2013 00:37:15 +0000 (UTC)
From: "Pinaki Poddar (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: <JIRA.12638420.1363912541869.31683.1363912635287@arcas>
In-Reply-To: <JIRA.12638420.1363912541869@arcas>
References: <JIRA.12638420.1363912541869@arcas>
Subject: [jira] [Created] (OPENJPA-2356) Use new Offset/Limit/ROWNUM
 features in DB2 family of databases for range queries
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Pinaki Poddar created OPENJPA-2356:
--------------------------------------

             Summary: Use new Offset/Limit/ROWNUM features in DB2 family of databases for range queries
                 Key: OPENJPA-2356
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2356
             Project: OpenJPA
          Issue Type: Improvement
            Reporter: Pinaki Poddar
            Assignee: Pinaki Poddar


JPA queries that use setFirstResult() and/or setMaxResult() translate to some form of Offset and Limit syntax in database SQL query. Recently DB2 and Derby has added ROWNUM and FETCH offset respectively.
OpenJPA should use these facilities when appropriate.   

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira