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
     

    Fields declared in class org.hibernate.dialect.pagination.AbstractLimitHandler

    NO_LIMIT
  • Constructor Summary

    Constructors
    Constructor
    Description
     
  • Method Summary

    Modifier and Type
    Method
    Description
    protected Pattern
    The offset/fetch clauses must come before the WITH clause.

    Methods declared in class org.hibernate.dialect.pagination.OffsetFetchLimitHandler

    processSql, processSql, processSqlMutatesState, renderOffsetRowsKeyword, supportsLimit, supportsOffset, supportsVariableLimit

    Methods declared in 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 declared in interface org.hibernate.dialect.pagination.LimitHandler

    getParameterPositionStart, processSql
  • Field Details

  • Constructor Details

    • IngresLimitHandler

      public IngresLimitHandler()
  • Method Details

    • getForUpdatePattern

      protected Pattern getForUpdatePattern()
      The offset/fetch clauses must come before the WITH clause.
      Overrides:
      getForUpdatePattern in class org.hibernate.dialect.pagination.AbstractLimitHandler