Package org.hibernate.community.dialect.pagination

Class IngresLimitHandler

java.lang.Object

org.hibernate.dialect.pagination.AbstractLimitHandler

org.hibernate.dialect.pagination.OffsetFetchLimitHandler

org.hibernate.community.dialect.pagination.IngresLimitHandler

All Implemented Interfaces:

org.hibernate.dialect.pagination.LimitHandler

public class IngresLimitHandler
extends org.hibernate.dialect.pagination.OffsetFetchLimitHandler

A LimitHandler for Ingres. According to the documentation for Ingres 10.2, Ingres supports the syntax FETCH FIRST m ROWS ONLY and OFFSET n FETCH NEXT m ROWS ONLY, which is oh-so-close to the ANSI SQL standard, except for the missing ROWS after OFFSET.

Field Summary

Fields

Modifier and Type	Field	Description
static final IngresLimitHandler	INSTANCE

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

NO_LIMIT

Constructor Summary

Constructors

Constructor	Description
IngresLimitHandler()

Method Summary

Modifier and Type	Method	Description
protected Pattern	getForUpdatePattern()	The offset/fetch clauses must come before the WITH clause.
protected boolean	renderOffsetRowsKeyword()

Methods inherited from class org.hibernate.dialect.pagination.OffsetFetchLimitHandler

processSql, processSql, processSqlMutatesState, supportsLimit, supportsOffset, supportsVariableLimit

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

bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersFirst, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getFirstRow, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, setMaxRows, supportsLimitOffset, useMaxForLimit

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

Field Details

INSTANCE

public static final IngresLimitHandler INSTANCE

Constructor Details

IngresLimitHandler

public IngresLimitHandler()

Method Details

renderOffsetRowsKeyword

protected boolean renderOffsetRowsKeyword()

Overrides:

renderOffsetRowsKeyword in class org.hibernate.dialect.pagination.OffsetFetchLimitHandler

getForUpdatePattern

protected Pattern getForUpdatePattern()

The offset/fetch clauses must come before the WITH clause.

Overrides:

getForUpdatePattern in class org.hibernate.dialect.pagination.AbstractLimitHandler