org.hibernate.dialect.pagination (Hibernate Javadocs)

Support for Dialect-specific pagination strategies.

See Also:: LimitHandler

Interface Summary
Interface Description

LimitHandler
Contract defining dialect-specific limit and offset handling.

Class Summary
Class	Description
AbstractLimitHandler	Default implementation of `LimitHandler` interface.
AbstractNoOffsetLimitHandler	Superclass for `LimitHandler`s that don't support offsets at all.
AbstractSimpleLimitHandler	Superclass for simple `LimitHandler`s that don't support specifying an offset without a limit.
DB2LimitHandler	A `LimitHandler` for DB2 11.1 which supports the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` and `OFFSET n ROWS FETCH NEXT m ROWS ONLY`, with the only wrinkle being that this clause comes after the `FOR UPDATE` and other similar clauses.
DerbyLimitHandler	A `LimitHandler` for Apache Derby, which fully supports the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` and `OFFSET n ROWS FETCH NEXT m ROWS ONLY`.
FetchLimitHandler	A `LimitHandler` for databases which support the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` but not `OFFSET n ROWS`.
LegacyDB2LimitHandler	A `LimitHandler` for DB2.
LegacyHSQLLimitHandler	A `LimitHandler` for HSQL prior to 2.0.
LegacyOracleLimitHandler	A `LimitHandler` for Oracle prior to 12c, which uses `ROWNUM`.
LimitLimitHandler	Limit handler for MySQL and CUBRID which support the syntax `LIMIT n` and `LIMIT m, n`.
LimitOffsetLimitHandler	A `LimitHandler` for databases like PostgreSQL, H2, and HSQL that support the syntax `LIMIT n OFFSET m`.
NoopLimitHandler	Handler not supporting query LIMIT clause.
OffsetFetchLimitHandler	A `LimitHandler` for databases which support the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` and `OFFSET n ROWS FETCH NEXT m ROWS ONLY`.
Oracle12LimitHandler	A `LimitHandler` for databases which support the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` and `OFFSET n ROWS FETCH NEXT m ROWS ONLY`.
SQLServer2005LimitHandler	A `LimitHandler` compatible with SQL Server 2005 and later that uses `top()` and `rownumber()`.
SQLServer2012LimitHandler	A `LimitHandler` compatible with SQL Server 2012 which introduced support for the ANSI SQL standard syntax `OFFSET m ROWS FETCH NEXT n ROWS ONLY`, though this syntax is considered part of the `ORDER BY` clause, and with the wrinkle that both `ORDER BY` and the `OFFSET` clause are required.
TopLimitHandler	A `LimitHandler` for Transact SQL and similar databases which support the syntax `SELECT TOP n`.