Top Description Fields Constructors Methods
org.hibernate.dialect.pagination

public Class LimitOffsetLimitHandler

extends AbstractSimpleLimitHandler
Class Inheritance
A LimitHandler for databases like PostgreSQL, H2, and HSQL that support the syntax LIMIT n OFFSET m. Note that this syntax does not allow specification of an offset without a limit.

Field Summary

Modifier and TypeField and Description
public static LimitOffsetLimitHandler
INSTANCE

public static LimitOffsetLimitHandler
OFFSET_ONLY_INSTANCE

Constructor Summary

AccessConstructor and Description
public
LimitOffsetLimitHandler()

Method Summary

Modifier and TypeMethod and Description
public final boolean
bindLimitParametersInReverseOrder()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.bindLimitParametersInReverseOrder.

Usually, the offset comes before the limit, but occasionally the offset is specified after the limit.
protected String
limitClause(boolean hasFirstRow)

Implements abstract org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.limitClause.

protected String
offsetOnlyClause()

Overrides org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.offsetOnlyClause.

public boolean
supportsOffset()

Overrides org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.supportsOffset.

Implements org.hibernate.dialect.pagination.LimitHandler.supportsOffset.

Does this handler support offsetting query results without also specifying a limit?
Inherited from org.hibernate.dialect.pagination.AbstractSimpleLimitHandler:
insertprocessSqlsupportsLimitsupportsVariableLimit

Field Detail

INSTANCEback to summary
public static LimitOffsetLimitHandler INSTANCE
OFFSET_ONLY_INSTANCEback to summary
public static LimitOffsetLimitHandler OFFSET_ONLY_INSTANCE

Constructor Detail

LimitOffsetLimitHandlerback to summary
public LimitOffsetLimitHandler()

Method Detail

bindLimitParametersInReverseOrderback to summary
public final boolean bindLimitParametersInReverseOrder()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.bindLimitParametersInReverseOrder.

Doc from org.hibernate.dialect.pagination.AbstractLimitHandler.bindLimitParametersInReverseOrder.

Usually, the offset comes before the limit, but occasionally the offset is specified after the limit. Does this dialect require us to bind the parameters in reverse order?

Returns:boolean

true if the correct order is limit then offset

Annotations
@Override
limitClauseback to summary
protected String limitClause(boolean hasFirstRow)

Implements abstract org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.limitClause.

Annotations
@Override
offsetOnlyClauseback to summary
protected String offsetOnlyClause()

Overrides org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.offsetOnlyClause.

Annotations
@Override
supportsOffsetback to summary
public boolean supportsOffset()

Overrides org.hibernate.dialect.pagination.AbstractSimpleLimitHandler.supportsOffset.

Implements org.hibernate.dialect.pagination.LimitHandler.supportsOffset.

Doc from org.hibernate.dialect.pagination.LimitHandler.supportsOffset.

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

Returns:boolean

True if this handler supports offset alone.

Annotations
@Override