Package org.hibernate.dialect.pagination

Class FetchLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.AbstractLimitHandler

org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler

org.hibernate.dialect.pagination.FetchLimitHandler

All Implemented Interfaces:

LimitHandler

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

Field Summary

Fields

Modifier and Type	Field	Description
static final FetchLimitHandler	INSTANCE

Fields inherited from class org.hibernate.dialect.pagination.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()	The SQL fragment to insert, with a ? placeholder for the actual numerical limit.

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

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

Constructor Details

FetchLimitHandler

public FetchLimitHandler(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

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