Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2356

Use new Offset/Limit/ROWNUM features in DB2 family of databases for range queries

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      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.

      Attachments

        Issue Links

        relates to

        Improvement - An improvement or enhancement to an existing feature or task. OPENJPA-759 Query pagination on DB2 - an alternative way

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Open

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            ppoddar@apache.org Pinaki Poddar
            ppoddar@apache.org Pinaki Poddar
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment