Package org.hibernate.dialect.pagination

package org.hibernate.dialect.pagination

Support for Dialect-specific pagination strategies.

See Also:

• LimitHandler

Related Packages

Package	Description
org.hibernate.dialect	This package abstracts over the multifarious dialects of SQL understood by the databases supported by Hibernate.

Class	Description
AbstractLimitHandler	Default implementation of LimitHandler interface.
AbstractNoOffsetLimitHandler	Superclass for LimitHandlers that don't support offsets at all.
AbstractSimpleLimitHandler	Superclass for simple LimitHandlers 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.
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.
LimitHandler	Contract defining dialect-specific limit and offset handling.
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.