Class TopLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.AbstractNoOffsetLimitHandler

org.hibernate.dialect.pagination.spi.TopLimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final class TopLimitHandler
extends AbstractNoOffsetLimitHandler

A LimitHandler for Transact SQL and similar databases which support the syntax SELECT TOP n. Note that this syntax does not allow specification of an offset.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static TopLimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Constructor Summary

Constructors

Constructor	Description
TopLimitHandler(boolean variableLimit)

Method Summary

Modifier and Type	Method	Description
boolean	bindLimitParametersFirst()	Does the offset/limit clause come at the start of the SELECT statement, or at the end of the query?
protected String	insert(String limitClause, String sql)
protected String	limitClause(PaginationRequest request)
int	parameterPositionStart(PaginationRequest request)	Determine the one-based position of the first original query parameter after any pagination parameters inserted at the beginning of the SQL.

Methods inherited from class AbstractNoOffsetLimitHandler

processSql, supportsLimit, supportsLimitOffset, supportsVariableLimit

Methods inherited from class AbstractLimitHandler

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

Methods inherited from class Object

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

Field Details

INSTANCE

public static TopLimitHandler INSTANCE

Constructor Details

TopLimitHandler

@SPI
public TopLimitHandler(boolean variableLimit)

Method Details

limitClause

protected String limitClause(PaginationRequest request)

Specified by:

limitClause in class AbstractNoOffsetLimitHandler

insert

protected String insert(String limitClause,
 String sql)

Specified by:

insert in class AbstractNoOffsetLimitHandler

bindLimitParametersFirst

public boolean bindLimitParametersFirst()

Description copied from class: AbstractLimitHandler

Does the offset/limit clause come at the start of the SELECT statement, or at the end of the query?

Specified by:

bindLimitParametersFirst in class AbstractNoOffsetLimitHandler

Returns:

true if limit parameters come before other parameters

parameterPositionStart

public int parameterPositionStart(PaginationRequest request)

Description copied from interface: LimitHandler

Determine the one-based position of the first original query parameter after any pagination parameters inserted at the beginning of the SQL.

This method must agree with PaginationJdbcInstructions.parametersAtStart returned by LimitHandler.processSql(PaginationRequest) and must not mutate this handler.

Specified by:

parameterPositionStart in interface LimitHandler

Overrides:

parameterPositionStart in class AbstractLimitHandler