glassfish
  1. glassfish
  2. GLASSFISH-4887

Support for SQL LIMIT / OFFSET with setMaxResults() / setFirstResult()

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Blocker Blocker
    • Resolution: Unresolved
    • Affects Version/s: 9.0peur1
    • Fix Version/s: not determined
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      4,887

      Description

      Almost all web applications use pagination to split large tables into pages with
      a relatively small number of rows each. In Toplink Essentials, setFirstResult()
      and setMaxResults() can be used to achieve this.

      At least for PostgreSQL and MySQL, and most likely for other RDBMs, a lot of I/O
      effort can be saved by using the LIMIT and OFFSET sql clauses. Toplink
      Essentials really should use it!!

      (Hibernate has been doing this for a long time!!)

        Activity

        Hide
        Tom Mueller added a comment -

        Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

        Show
        Tom Mueller added a comment - Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

          People

          • Assignee:
            tware
            Reporter:
            batzee
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: