Class FetchLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.AbstractNoOffsetLimitHandler

org.hibernate.dialect.pagination.spi.FetchLimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final class FetchLimitHandler
extends AbstractNoOffsetLimitHandler

A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY but not OFFSET n ROWS.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final FetchLimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Constructor Summary

Constructors

Constructor	Description
FetchLimitHandler(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 fetch, String sql)
protected String	limitClause(PaginationRequest request)

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, parameterPositionStart, 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 final FetchLimitHandler INSTANCE

Constructor Details

FetchLimitHandler

@SPI
public FetchLimitHandler(boolean variableLimit)

Method Details

limitClause

protected String limitClause(PaginationRequest request)

Specified by:

limitClause in class AbstractNoOffsetLimitHandler

insert

protected String insert(String fetch,
 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