IngresLimitHandler (Hibernate Javadocs (hibernate-community-dialects))

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 IngresLimitHandler INSTANCE
- Fields inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler
  NO_LIMIT

Constructor Summary

Constructors
Constructor Description

IngresLimitHandler()

Method Summary

All Methods Instance Methods Concrete Methods
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, 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
processSql

- Field Detail
  - INSTANCE
```
public static final IngresLimitHandler INSTANCE
```
- Constructor Detail
  - IngresLimitHandler
```
public IngresLimitHandler()
```
- Method Detail
  - 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