[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2655) SQLServer2005Dialect (ROW_NUMBER for Paging)

[Yoryos Valotassios (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yoryos Valotassios updated HHH-2655:
------------------------------------

    Attachment: SqlServer2008Dialect.java

I'm updating a modified dialect that fixes an issue with the offset. With jpa the offset is zero based where mssql's ROW_NUMBER() function starts with 1. The dialect uses TOP when no offset is provided (using the getLimitString of it's superclass) and only changes the sql when the offset is greater than 1.


> SQLServer2005Dialect (ROW_NUMBER for Paging)
> --------------------------------------------
>
>                 Key: HHH-2655
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2655
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 3.2.2, 3.2.3, 3.2.4, 3.5.3
>         Environment: SQLServer 2005, Hibernate 3.2.2+
>            Reporter: Wells Tiedeman
>         Attachments: BindingSqlServerDialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SQLServer2005Dialect.java, SqlServer2008Dialect.java, SqlServer2008Dialect.java
>
>   Original Estimate: 1m
>  Remaining Estimate: 1m
>
> Add a SQLServer2005Dialect class to the product that leverages the new ROW_NUMBER capabilities within SQLServer2005 to do paged result sets more efficiently.  See attached source...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira