Uses of Interface
org.hibernate.dialect.pagination.spi.LimitHandler

Packages that use LimitHandler

Package	Description
org.hibernate.dialect	Defines the root contracts and built-in implementations for SQL dialects.
org.hibernate.dialect.pagination.spi	Supported contracts and reusable families for applying pagination to completed SQL.

Uses of LimitHandler in org.hibernate.dialect

Methods in org.hibernate.dialect that return LimitHandler

Modifier and Type	Method	Description
LimitHandler	CockroachDialect.getLimitHandler()
LimitHandler	DB2Dialect.getLimitHandler()
LimitHandler	DB2iDialect.getLimitHandler()
LimitHandler	DB2zDialect.getLimitHandler()
LimitHandler	Dialect.getLimitHandler()	Supplies execution-time pagination for already-rendered SQL requested by Query.setMaxResults(int) or Query.setFirstResult(int).
LimitHandler	H2Dialect.getLimitHandler()
LimitHandler	HANADialect.getLimitHandler()
LimitHandler	HSQLDialect.getLimitHandler()
LimitHandler	MySQLDialect.getLimitHandler()
LimitHandler	OracleDialect.getLimitHandler()
LimitHandler	PostgreSQLDialect.getLimitHandler()
LimitHandler	SpannerDialect.getLimitHandler()
LimitHandler	SpannerPostgreSQLDialect.getLimitHandler()
LimitHandler	SQLServerDialect.getLimitHandler()
LimitHandler	SybaseASEDialect.getLimitHandler()

Uses of LimitHandler in org.hibernate.dialect.pagination.spi

Classes in org.hibernate.dialect.pagination.spi that implement LimitHandler

Modifier and Type	Class	Description
class	AbstractLimitHandler	Default implementation of LimitHandler interface.
class	AbstractNoOffsetLimitHandler	Superclass for LimitHandlers that don't support offsets at all.
class	AbstractSimpleLimitHandler	Superclass for simple LimitHandlers that don't support specifying an offset without a limit.
final class	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.
final class	FetchLimitHandler	A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY but not OFFSET n ROWS.
final class	LegacyDB2LimitHandler	A LimitHandler for DB2.
class	LimitLimitHandler	Limit handler for MySQL and CUBRID which support the syntax LIMIT n and LIMIT m, n.
class	LimitOffsetLimitHandler	A LimitHandler for databases like PostgreSQL, H2, and HSQL that support the syntax LIMIT n OFFSET m.
final class	NoopLimitHandler	Handler not supporting query LIMIT clause.
class	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.
final class	Oracle12LimitHandler	A LimitHandler for Oracle 12c and later.
final class	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.
final class	TopLimitHandler	A LimitHandler for Transact SQL and similar databases which support the syntax SELECT TOP n.

Fields in org.hibernate.dialect.pagination.spi declared as LimitHandler

Modifier and Type	Field	Description
static final LimitHandler	AbstractLimitHandler.NO_LIMIT