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

public Class OffsetFetchLimitHandler

extends AbstractLimitHandler
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.pagination.SQLServer2012LimitHandler, org.hibernate.dialect.pagination.DB2LimitHandler, org.hibernate.dialect.pagination.DerbyLimitHandler
Imports
org.hibernate.query.spi.Limit
A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY and OFFSET n ROWS FETCH NEXT m ROWS ONLY.
Author
Gavin King

Field Summary

Modifier and TypeField and Description
public static final OffsetFetchLimitHandler
INSTANCE

private final boolean
variableLimit

Inherited from org.hibernate.dialect.pagination.AbstractLimitHandler:
NO_LIMIT

Constructor Summary

AccessConstructor and Description
public
OffsetFetchLimitHandler(boolean variableLimit)

Method Summary

Modifier and TypeMethod and Description
pack-priv void
begin(String sql, StringBuilder offsetFetch, boolean hasFirstRow, boolean hasMaxRows)

pack-priv String
insert(String offsetFetch, String sql)

public String
processSql(String sql, Limit limit)

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.processSql.

Implements org.hibernate.dialect.pagination.LimitHandler.processSql.

protected boolean
renderOffsetRowsKeyword()

public final boolean
supportsLimit()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.supportsLimit.

Implements org.hibernate.dialect.pagination.LimitHandler.supportsLimit.

Does this handler support limiting query results?
public boolean
supportsOffset()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.supportsOffset.

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

Does this handler support offsetting query results without also specifying a limit?
public final boolean
supportsVariableLimit()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.supportsVariableLimit.

Does this handler support bind variables (JDBC prepared statement parameters) for its limit/offset?
Inherited from org.hibernate.dialect.pagination.AbstractLimitHandler:
bindLimitParametersbindLimitParametersAtEndOfQuerybindLimitParametersAtStartOfQuerybindLimitParametersFirstbindLimitParametersInReverseOrderconvertToFirstRowValueforceLimitUsagegetFirstRowgetForUpdatePatterngetMaxOrLimithasFirstRowhasMaxRowsinsertAfterDistinctinsertAfterSelectinsertAtEndinsertBeforeForUpdatesetMaxRowssupportsLimitOffsetuseMaxForLimit

Field Detail

INSTANCEback to summary
public static final OffsetFetchLimitHandler INSTANCE
variableLimitback to summary
private final boolean variableLimit

Constructor Detail

OffsetFetchLimitHandlerback to summary
public OffsetFetchLimitHandler(boolean variableLimit)

Method Detail

beginback to summary
pack-priv void begin(String sql, StringBuilder offsetFetch, boolean hasFirstRow, boolean hasMaxRows)
insertback to summary
pack-priv String insert(String offsetFetch, String sql)
processSqlback to summary
public String processSql(String sql, Limit limit)

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.processSql.

Implements org.hibernate.dialect.pagination.LimitHandler.processSql.

Annotations
@Override
renderOffsetRowsKeywordback to summary
protected boolean renderOffsetRowsKeyword()
supportsLimitback to summary
public final boolean supportsLimit()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.supportsLimit.

Implements org.hibernate.dialect.pagination.LimitHandler.supportsLimit.

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

Does this handler support limiting query results?

Returns:boolean

True if this handler supports limit alone.

Annotations
@Override
supportsOffsetback to summary
public boolean supportsOffset()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.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
supportsVariableLimitback to summary
public final boolean supportsVariableLimit()

Overrides org.hibernate.dialect.pagination.AbstractLimitHandler.supportsVariableLimit.

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

Does this handler support bind variables (JDBC prepared statement parameters) for its limit/offset?

Returns:boolean

true if bind variables can be used

Annotations
@Override