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

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

    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

        1. graycol.gif
          0.1 kB
          Pinaki Poddar
        2. OPENJPA-2356.patch
          3 kB
          Di Wu Lau

        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

            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: