Class SQLServer2012LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.OffsetFetchLimitHandler

org.hibernate.dialect.pagination.spi.SQLServer2012LimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final class SQLServer2012LimitHandler
extends OffsetFetchLimitHandler

A LimitHandler compatible with SQL Server 2012 which introduced support for the ANSI SQL standard syntax OFFSET m ROWS FETCH NEXT n ROWS ONLY, though this syntax is considered part of the ORDER BY clause, and with the wrinkle that both ORDER BY and the OFFSET clause are required.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final SQLServer2012LimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Method Summary

Modifier and Type	Method	Description
protected void	begin(String sql, StringBuilder offsetFetch, boolean hasFirstRow, boolean hasMaxRows)	OFFSET and FETCH have to come right at the end of the ORDER BY clause, and OFFSET is required in order to have a FETCH:

Methods inherited from class OffsetFetchLimitHandler

insert, processSql, renderOffsetRowsKeyword, supportsLimit, supportsOffset, supportsVariableLimit

Methods inherited from class AbstractLimitHandler

bindLimitParametersFirst, bindLimitParametersInReverseOrder, bindLimitParameterValues, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, jdbcInstructions, jdbcMaxRows, parameterPositionStart, result, rowsToSkip, supportsLimitOffset, useMaxForLimit

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

INSTANCE

public static final SQLServer2012LimitHandler INSTANCE

Method Details

begin

protected void begin(String sql,
 StringBuilder offsetFetch,
 boolean hasFirstRow,
 boolean hasMaxRows)

OFFSET and FETCH have to come right at the end of the ORDER BY clause, and OFFSET is required in order to have a FETCH:

order by ... offset m rows [fetch next n rows only]

Overrides:

begin in class OffsetFetchLimitHandler