Class Oracle12LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.spi.AbstractLimitHandler

org.hibernate.dialect.pagination.spi.Oracle12LimitHandler

All Implemented Interfaces:

LimitHandler

@SPI
public final class Oracle12LimitHandler
extends AbstractLimitHandler

A LimitHandler for Oracle 12c and later.

Since:

8.0

Field Summary

Fields

Modifier and Type	Field	Description
static final Oracle12LimitHandler	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?
boolean	supportsOffset()	Does this handler support offsetting query results without also specifying a limit?

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

Methods inherited from class Object

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

Field Details

INSTANCE

public static final Oracle12LimitHandler 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.

supportsOffset

public boolean supportsOffset()

Description copied from interface: LimitHandler

Does this handler support offsetting query results without also specifying a limit?

Specified by:

supportsOffset in interface LimitHandler

Overrides:

supportsOffset in class AbstractLimitHandler

Returns:

True if this handler supports offset alone.