[ https://issues.apache.org/jira/browse/OPENJPA-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13611034#comment-13611034 ]
ASF subversion and git services commented on OPENJPA-2356: ---------------------------------------------------------- Commit 1459918 from [~ppod...@apache.org] [ https://svn.apache.org/r1459918 ] OPENJPA-2356: Use FETCH OFFSET/NEXT and ROWNUM support for DB2 familiy of databases for Range queries > 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