Class LimitLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.AbstractSimpleLimitHandler

org.hibernate.dialect.pagination.spi.LimitLimitHandler

All Implemented Interfaces:

LimitHandler

@SPI({USE,IMPLEMENT})
public class LimitLimitHandler
extends AbstractSimpleLimitHandler

Limit handler for MySQL and CUBRID which support the syntax LIMIT n and LIMIT m, n. Note that this syntax does not allow specification of an offset without a limit.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final LimitLimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Constructor Summary

Constructors

Constructor	Description
LimitLimitHandler()

Method Summary

Modifier and Type	Method	Description
protected Pattern	getForUpdatePattern()	The offset/limit clauses typically must come before the FOR UPDATEish clauses, so we need a way to identify these clauses in the text of the whole query.
protected String	limitClause(boolean hasFirstRow, PaginationRequest request)
protected String	offsetOnlyClause(PaginationRequest request)
boolean	supportsOffset()	Does this handler support offsetting query results without also specifying a limit?

Methods inherited from class AbstractSimpleLimitHandler

insert, processSql, supportsLimit, supportsVariableLimit

Methods inherited from class AbstractLimitHandler

bindLimitParametersFirst, bindLimitParametersInReverseOrder, bindLimitParameterValues, convertToFirstRowValue, forceLimitUsage, getFirstRow, 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 LimitLimitHandler INSTANCE

Constructor Details

LimitLimitHandler

@SPI({USE,IMPLEMENT})
public LimitLimitHandler()

Method Details

limitClause

protected String limitClause(boolean hasFirstRow,
 PaginationRequest request)

Specified by:

limitClause in class AbstractSimpleLimitHandler

offsetOnlyClause

protected String offsetOnlyClause(PaginationRequest request)

Overrides:

offsetOnlyClause in class AbstractSimpleLimitHandler

getForUpdatePattern

protected Pattern getForUpdatePattern()

Description copied from class: AbstractLimitHandler

The offset/limit clauses typically must come before the FOR UPDATEish clauses, so we need a way to identify these clauses in the text of the whole query.

Overrides:

getForUpdatePattern in class AbstractLimitHandler

supportsOffset

public boolean supportsOffset()

Description copied from interface: LimitHandler

Does this handler support offsetting query results without also specifying a limit?

Specified by:

supportsOffset in interface LimitHandler

Overrides:

supportsOffset in class AbstractSimpleLimitHandler

Returns:

True if this handler supports offset alone.