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

public Class FetchLimitHandler

extends AbstractNoOffsetLimitHandler
Class Inheritance
A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY but not OFFSET n ROWS.
Author
Gavin King

Field Summary

Modifier and TypeField and Description
public static final FetchLimitHandler
INSTANCE

Constructor Summary

AccessConstructor and Description
public
FetchLimitHandler(boolean variableLimit)

Method Summary

Modifier and TypeMethod and Description
public boolean
bindLimitParametersFirst()

Implements abstract org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler.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)

Implements abstract org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler.insert.

protected String
limitClause()

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

The SQL fragment to insert, with a ?
Inherited from org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler:
processSqlsupportsLimitsupportsLimitOffsetsupportsVariableLimit

Field Detail

INSTANCEback to summary
public static final FetchLimitHandler INSTANCE

Constructor Detail

FetchLimitHandlerback to summary
public FetchLimitHandler(boolean variableLimit)

Method Detail

bindLimitParametersFirstback to summary
public boolean bindLimitParametersFirst()

Implements abstract org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler.bindLimitParametersFirst.

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

Does the offset/limit clause come at the start of the SELECT statement, or at the end of the query?

Returns:boolean

true if limit parameters come before other parameters

Annotations
@Override
insertback to summary
protected String insert(String fetch, String sql)

Implements abstract org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler.insert.

Annotations
@Override
limitClauseback to summary
protected String limitClause()

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

Doc from org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler.limitClause.

The SQL fragment to insert, with a ? placeholder for the actual numerical limit.

Annotations
@Override