Not sure how 2008 LimitHandler will take care of 2012 SQL Syntax.
I wasn't talking about SQLServer2008LimitHandler but rather the 2008 revision of the ANSI SQL standard. The specific implementation we had won't work for MSSQL2012 given some requirements which SQL Server has for syntax, so I created a specific LimitHandler implementation.
I thought of extending SQLServer2012Dialect myself to implement pagination with hibernate standard setFirstResult/setMaxResults calls. Some said I have to extend LimitHandler as well.
No worries, you are welcomed to see the necessary changes shortly when I push the pull request to github. |