Package org.hibernate.dialect.pagination

Class TopLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.AbstractLimitHandler

org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler

org.hibernate.dialect.pagination.TopLimitHandler

All Implemented Interfaces:

LimitHandler

public 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.

Field Summary

Fields

Modifier and Type	Field	Description
static TopLimitHandler	INSTANCE

Fields inherited from class org.hibernate.dialect.pagination.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?
int	getParameterPositionStart(Limit limit)	Returns the position at which to start binding parameters after LimitHandler.bindLimitParametersAtStartOfQuery(Limit, PreparedStatement, int).
protected String	insert(String limitClause, String sql)
protected String	limitClause()	The SQL fragment to insert, with a ? placeholder for the actual numerical limit.
protected String	limitClause(int jdbcParameterCount, ParameterMarkerStrategy parameterMarkerStrategy)
boolean	processSqlMutatesState()	Returns whether LimitHandler.processSql(String, int, ParameterMarkerStrategy, QueryOptions) mutates the state of this limit handler and needs to be called for certain other methods to work correctly.

Methods inherited from class org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler

processSql, processSql, supportsLimit, supportsLimitOffset, supportsVariableLimit

Methods inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler

bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, setMaxRows, supportsOffset, useMaxForLimit

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.hibernate.dialect.pagination.LimitHandler

processSql

Field Details

INSTANCE

public static TopLimitHandler INSTANCE

Constructor Details

TopLimitHandler

public TopLimitHandler(boolean variableLimit)

Method Details

limitClause

protected String limitClause()

Description copied from class: AbstractNoOffsetLimitHandler

The SQL fragment to insert, with a ? placeholder for the actual numerical limit.

Specified by:

limitClause in class AbstractNoOffsetLimitHandler

limitClause

protected String limitClause(int jdbcParameterCount,
 ParameterMarkerStrategy parameterMarkerStrategy)

Overrides:

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

processSqlMutatesState

public boolean processSqlMutatesState()

Description copied from interface: LimitHandler

Returns whether LimitHandler.processSql(String, int, ParameterMarkerStrategy, QueryOptions) mutates the state of this limit handler and needs to be called for certain other methods to work correctly.

getParameterPositionStart

public int getParameterPositionStart(Limit limit)

Description copied from interface: LimitHandler

Returns the position at which to start binding parameters after LimitHandler.bindLimitParametersAtStartOfQuery(Limit, PreparedStatement, int).