Class DB2LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.OffsetFetchLimitHandler

org.hibernate.dialect.pagination.spi.DB2LimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final class DB2LimitHandler
extends OffsetFetchLimitHandler

A LimitHandler for DB2 11.1 which supports the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY and OFFSET n ROWS FETCH NEXT m ROWS ONLY, with the only wrinkle being that this clause comes after the FOR UPDATE and other similar clauses.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final DB2LimitHandler	INSTANCE

Fields inherited from class AbstractLimitHandler

NO_LIMIT

Method Summary

Modifier and Type	Method	Description
protected String	insert(String offsetFetch, String sql)

Methods inherited from class OffsetFetchLimitHandler

begin, processSql, renderOffsetRowsKeyword, supportsLimit, supportsOffset, supportsVariableLimit

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, useMaxForLimit

Methods inherited from class Object

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

Field Details

INSTANCE

public static final DB2LimitHandler INSTANCE

Method Details

insert

protected String insert(String offsetFetch,
 String sql)

Overrides:

insert in class OffsetFetchLimitHandler