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

public Class TopLimitHandler

extends AbstractNoOffsetLimitHandler
Class Inheritance
A LimitHandler for Transact SQL and similar databases which support the syntax SELECT TOP n. Note that this syntax does not allow specification of an offset.
Author
Brett Meyer

Field Summary

Modifier and TypeField and Description
public static TopLimitHandler
INSTANCE

Constructor Summary

AccessConstructor and Description
public
TopLimitHandler(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 limitClause, 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 TopLimitHandler INSTANCE

Constructor Detail

TopLimitHandlerback to summary
public TopLimitHandler(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 limitClause, 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