You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Mark Bortolazzo (JIRA)" <ji...@apache.org> on 2017/09/01 05:57:00 UTC

[jira] [Commented] (OPENJPA-2598) Support SQL server Offset Fetch syntax for pagination

    [ https://issues.apache.org/jira/browse/OPENJPA-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16150077#comment-16150077 ] 

Mark Bortolazzo commented on OPENJPA-2598:
------------------------------------------

Hi.  I have experienced this issue as well.  Please find attached a patch.

It would be nice if it could go on a 2.4 release as well as the 3.0 release.

Regards
Mark

> Support SQL server Offset Fetch syntax for pagination
> -----------------------------------------------------
>
>                 Key: OPENJPA-2598
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2598
>             Project: OpenJPA
>          Issue Type: New Feature
>          Components: query
>    Affects Versions: 2.2.2
>            Reporter: Joe Luo
>         Attachments: OPENJPA-2598-TRUNK.patch
>
>
> We are using OpenJPA with SQL Server.  Currently, it uses the TOP syntax for pagination.  First, it will select the TOP 20.  Then, the TOP 40.  The pagination get progressively slower as more rows are returned.  SQL 2012 now supports Offset Fetch syntax.  Could support for this new syntax be added?
> https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)