You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Pinaki Poddar (JIRA)" <ji...@apache.org> on 2013/03/22 01:37:15 UTC
[jira] [Created] (OPENJPA-2356) Use new Offset/Limit/ROWNUM
features in DB2 family of databases for range queries
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