Package org.hibernate.dialect.pagination

Class LegacyDB2LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.AbstractLimitHandler

org.hibernate.dialect.pagination.LegacyDB2LimitHandler

All Implemented Interfaces:

LimitHandler

public class LegacyDB2LimitHandler
extends AbstractLimitHandler

A LimitHandler for DB2. Uses FETCH FIRST n ROWS ONLY, together with ROWNUMBER() when there is an offset. (DB2 does not support the ANSI syntax OFFSET n ROWS.)

Field Summary

Fields

Modifier and Type	Field	Description
static LegacyDB2LimitHandler	INSTANCE

Fields inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler

NO_LIMIT

Constructor Summary

Constructors

Constructor	Description
LegacyDB2LimitHandler()

Method Summary

Modifier and Type	Method	Description
String	processSql(String sql, Limit limit)
boolean	supportsLimit()	Does this handler support limiting query results?
boolean	supportsVariableLimit()	Does this handler support bind variables (JDBC prepared statement parameters) for its limit/offset?
boolean	useMaxForLimit()	Does the limit clause expect the number of the last row, or the "page size", the maximum number of rows we want to receive? Hibernate's Query.setMaxResults(int) accepts the page size, so the number of the last row is obtained by adding the number of the first row, which is one greater than Query.setFirstResult(int).

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

bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersFirst, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, setMaxRows, supportsLimitOffset, supportsOffset

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 Detail

INSTANCE

public static final LegacyDB2LimitHandler INSTANCE

Constructor Detail

LegacyDB2LimitHandler

public LegacyDB2LimitHandler()

Method Detail

processSql

public String processSql(String sql,
                         Limit limit)

Specified by:

processSql in interface LimitHandler

Overrides:

processSql in class AbstractLimitHandler

supportsLimit

public final boolean supportsLimit()

Description copied from interface: LimitHandler

Does this handler support limiting query results?

Specified by:

supportsLimit in interface LimitHandler

Overrides:

supportsLimit in class AbstractLimitHandler

Returns:

True if this handler supports limit alone.

useMaxForLimit

public final boolean useMaxForLimit()

Description copied from class: AbstractLimitHandler

Does the limit clause expect the number of the last row, or the "page size", the maximum number of rows we want to receive? Hibernate's Query.setMaxResults(int) accepts the page size, so the number of the last row is obtained by adding the number of the first row, which is one greater than Query.setFirstResult(int).

Overrides:

useMaxForLimit in class AbstractLimitHandler

Returns:

true if the limit clause expects the number of the last row, false if it expects the page size

supportsVariableLimit

public final boolean supportsVariableLimit()

Description copied from class: AbstractLimitHandler

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

Overrides:

supportsVariableLimit in class AbstractLimitHandler

Returns:

true if bind variables can be used