Package org.hibernate.dialect.pagination

Class Oracle12LimitHandler

java.lang.Object

org.hibernate.dialect.pagination.AbstractLimitHandler

org.hibernate.dialect.pagination.Oracle12LimitHandler

All Implemented Interfaces:

LimitHandler

public class Oracle12LimitHandler
extends AbstractLimitHandler

A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY and OFFSET n ROWS FETCH NEXT m ROWS ONLY.

Field Summary

Fields

Modifier and Type	Field	Description
static final Oracle12LimitHandler	INSTANCE

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

NO_LIMIT

Method Summary

Modifier and Type	Method	Description
boolean	bindLimitParametersInReverseOrder()	Usually, the offset comes before the limit, but occasionally the offset is specified after the limit.
protected String	processSql(String sql, boolean hasFirstRow, boolean hasMaxRows, int jdbcParameterCount, @Nullable ParameterMarkerStrategy parameterMarkerStrategy, LockOptions lockOptions)
protected String	processSql(String sql, boolean hasFirstRow, boolean hasMaxRows, LockOptions lockOptions)
protected String	processSql(String sql, int forUpdateIndex, boolean hasFirstRow, boolean hasMaxRows)
protected String	processSql(String sql, int forUpdateIndex, boolean hasFirstRow, boolean hasMaxRows, int jdbcParameterCount, @Nullable ParameterMarkerStrategy parameterMarkerStrategy)
String	processSql(String sql, int jdbcParameterCount, @Nullable ParameterMarkerStrategy parameterMarkerStrategy, QueryOptions queryOptions)	Applies the limit from the QueryOptions to the SQL with the given ParameterMarkerStrategy.
String	processSql(String sql, Limit limit, QueryOptions queryOptions)
protected String	processSqlOffsetFetch(String sql, boolean hasFirstRow, boolean hasMaxRows)
protected String	processSqlOffsetFetch(String sql, boolean hasFirstRow, boolean hasMaxRows, int jdbcParameterCount, @Nullable ParameterMarkerStrategy parameterMarkerStrategy)
final boolean	supportsLimit()	Does this handler support limiting query results?
boolean	supportsOffset()	Does this handler support offsetting query results without also specifying a limit?
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, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, processSql, setMaxRows, supportsLimitOffset, supportsVariableLimit

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

getParameterPositionStart, processSqlMutatesState

Field Details

INSTANCE

public static final Oracle12LimitHandler INSTANCE

Method Details

processSql

public String processSql(String sql,
 Limit limit,
 QueryOptions queryOptions)

processSql

public String processSql(String sql,
 int jdbcParameterCount,
 @Nullable ParameterMarkerStrategy parameterMarkerStrategy,
 QueryOptions queryOptions)

Description copied from interface: LimitHandler

Applies the limit from the QueryOptions to the SQL with the given ParameterMarkerStrategy.

processSql

protected String processSql(String sql,
 boolean hasFirstRow,
 boolean hasMaxRows,
 LockOptions lockOptions)

processSql

protected String processSql(String sql,
 boolean hasFirstRow,
 boolean hasMaxRows,
 int jdbcParameterCount,
 @Nullable ParameterMarkerStrategy parameterMarkerStrategy,
 LockOptions lockOptions)

processSqlOffsetFetch

protected String processSqlOffsetFetch(String sql,
 boolean hasFirstRow,
 boolean hasMaxRows)

processSqlOffsetFetch

protected String processSqlOffsetFetch(String sql,
 boolean hasFirstRow,
 boolean hasMaxRows,
 int jdbcParameterCount,
 @Nullable ParameterMarkerStrategy parameterMarkerStrategy)

processSql

protected String processSql(String sql,
 int forUpdateIndex,
 boolean hasFirstRow,
 boolean hasMaxRows)

processSql

protected String processSql(String sql,
 int forUpdateIndex,
 boolean hasFirstRow,
 boolean hasMaxRows,
 int jdbcParameterCount,
 @Nullable ParameterMarkerStrategy parameterMarkerStrategy)

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.

bindLimitParametersInReverseOrder

public boolean bindLimitParametersInReverseOrder()

Description copied from class: AbstractLimitHandler

Usually, the offset comes before the limit, but occasionally the offset is specified after the limit. Does this dialect require us to bind the parameters in reverse order?

Overrides:

bindLimitParametersInReverseOrder in class AbstractLimitHandler

Returns:

true if the correct order is limit then offset

useMaxForLimit

public 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