FetchLimitHandler (Hibernate Javadocs)

java.lang.Object
- org.hibernate.dialect.pagination.AbstractLimitHandler
- - org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler
  - - org.hibernate.dialect.pagination.FetchLimitHandler

All Implemented Interfaces:

LimitHandler
```
public class FetchLimitHandler
extends AbstractNoOffsetLimitHandler
```
A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY but not OFFSET n ROWS.

Field Summary

Fields
Modifier and Type Field Description

static FetchLimitHandler INSTANCE
- Fields inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler
  NO_LIMIT

Constructor Summary

Constructors
Constructor Description

FetchLimitHandler(boolean variableLimit)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`boolean`	`bindLimitParametersFirst()`	Does the offset/limit clause come at the start of the `SELECT` statement, or at the end of the query?
`protected String`	`insert(String fetch, String sql)`
`protected String`	`limitClause()`	The SQL fragment to insert, with a ? placeholder for the actual numerical limit.

Methods inherited from class org.hibernate.dialect.pagination.AbstractNoOffsetLimitHandler
processSql, supportsLimit, supportsLimitOffset, supportsVariableLimit

Methods inherited from class org.hibernate.dialect.pagination.AbstractLimitHandler
bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getFirstRow, getForUpdatePattern, getMaxOrLimit, hasFirstRow, hasMaxRows, insertAfterDistinct, insertAfterSelect, insertAtEnd, insertBeforeForUpdate, setMaxRows, supportsOffset, 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 FetchLimitHandler INSTANCE
```
- Constructor Detail
  - FetchLimitHandler
```
public FetchLimitHandler(boolean variableLimit)
```
- Method Detail
  - limitClause
```
protected String limitClause()
```
    Description copied from class: AbstractNoOffsetLimitHandler
    
    The SQL fragment to insert, with a ? placeholder for the actual numerical limit.
    
    Specified by:
    
    limitClause in class AbstractNoOffsetLimitHandler
  - insert
```
protected String insert(String fetch,
                        String sql)
```
    Specified by:
    
    insert in class AbstractNoOffsetLimitHandler
  - bindLimitParametersFirst
```
public boolean bindLimitParametersFirst()
```
    Description copied from class: AbstractLimitHandler
    
    Does the offset/limit clause come at the start of the SELECT statement, or at the end of the query?
    
    Specified by:
    
    bindLimitParametersFirst in class AbstractNoOffsetLimitHandler
    
    Returns:
    
    true if limit parameters come before other parameters