| For those interested I think this might be a solution for Hibernate 5.2.6 with proper pagination:
------------------------------------------------------------------------------------------------
public class ValSQLLimitHandler extends AbstractLimitHandler { public ValSQLLimitHandler() { // NOP } @Override
public boolean supportsLimit() { return true; } @Override
public String processSql( String sql, RowSelection selection) {
if (LimitHelper.useLimit( this, selection)) { if (LimitHelper.hasFirstRow( selection)) return sql + " offset ? rows fetch next ? rows only"; else return sql + " offset 0 rows fetch next ? rows only"; } else { // or return unaltered SQL return sql; } }
}
------------------------------------------------------------------------------------------------
public class ValSQLServerDialect extends SQLServer2012Dialect {
public String getQuerySequencesString() { return "select name from sys.sequences"; } @Override
protected LimitHandler getDefaultLimitHandler() { return new ValSQLLimitHandler(); } } |
