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.

Author:

Gavin King

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, LockOptions lockOptions)
protected String	processSql(String sql, boolean hasFirstRow, LockOptions lockOptions)	Deprecated, for removal: This API element is subject to removal in a future version. Use processSql(String, boolean, boolean, LockOptions) instead
protected String	processSql(String sql, int forUpdateIndex, boolean hasFirstRow)	Deprecated, for removal: This API element is subject to removal in a future version. Use processSql(String, int, boolean, boolean) instead
protected String	processSql(String sql, int forUpdateIndex, boolean hasFirstRow, boolean hasMaxRows)
String	processSql(String sql, Limit limit, QueryOptions queryOptions)
protected String	processSqlOffsetFetch(String sql, boolean hasFirstRow)	Deprecated, for removal: This API element is subject to removal in a future version. Use processSqlOffsetFetch(String, boolean, boolean) instead
protected String	processSqlOffsetFetch(String sql, boolean hasFirstRow, boolean hasMaxRows)
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?

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

Field Details

INSTANCE

public static final Oracle12LimitHandler INSTANCE

Method Details

processSql

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

processSql

@Deprecated(forRemoval=true)
protected String processSql(String sql,
 boolean hasFirstRow,
 LockOptions lockOptions)

Deprecated, for removal: This API element is subject to removal in a future version.

Use processSql(String, boolean, boolean, LockOptions) instead

processSql

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

processSqlOffsetFetch

@Deprecated(forRemoval=true)
protected String processSqlOffsetFetch(String sql,
 boolean hasFirstRow)

Deprecated, for removal: This API element is subject to removal in a future version.

Use processSqlOffsetFetch(String, boolean, boolean) instead

processSqlOffsetFetch

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

processSql

@Deprecated(forRemoval=true)
protected String processSql(String sql,
 int forUpdateIndex,
 boolean hasFirstRow)

Deprecated, for removal: This API element is subject to removal in a future version.

Use processSql(String, int, boolean, boolean) instead

processSql

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

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