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

  • 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