Class LegacyDB2LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.LegacyDB2LimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final 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.)

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final LegacyDB2LimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Method Summary

Modifier and Type	Method	Description
PaginationResult	processSql(PaginationRequest request)	Apply pagination to a complete SQL string.
final boolean	supportsLimit()	Does this handler support limiting query results?
final boolean	supportsVariableLimit()	Does this handler support bind variables (JDBC prepared statement parameters) for its limit/offset?
final 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 AbstractLimitHandler

bindLimitParametersFirst, bindLimitParametersInReverseOrder, bindLimitParameterValues, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, jdbcInstructions, jdbcMaxRows, parameterPositionStart, result, rowsToSkip, supportsLimitOffset, supportsOffset

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

INSTANCE

public static final LegacyDB2LimitHandler INSTANCE

Method Details

processSql

public PaginationResult processSql(PaginationRequest request)

Description copied from interface: LimitHandler

Apply pagination to a complete SQL string.

Return PaginationResult.unchanged(String) when the request needs no SQL or JDBC pagination. The returned JDBC instructions must describe every pagination parameter introduced by the rewritten SQL.

Specified by:

processSql in interface LimitHandler

Overrides:

processSql in class AbstractLimitHandler

Parameters:

request - immutable completed-SQL pagination input

Returns:

rewritten SQL and the JDBC work needed to execute it

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