Package org.hibernate.dialect.pagination.spi

@SPI package org.hibernate.dialect.pagination.spi

Supported contracts and reusable families for applying pagination to completed SQL.

Since:

8.0

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.
LimitHandler	Dialect strategy for applying execution-time limit and offset to already-rendered SQL.
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 Oracle 12c and later.
PaginationJdbcInstructions	Immutable JDBC execution instructions produced by a LimitHandler together with paginated SQL.
PaginationRequest	Immutable input supplied by Hibernate to a LimitHandler for applying execution-time pagination to completed SQL.
PaginationResult	Immutable result returned by LimitHandler.processSql(PaginationRequest), pairing completed SQL with all JDBC and result-set work required by its pagination.
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.