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

Packages that use LimitHandler

Package	Description
org.hibernate.dialect	This package abstracts over the multifarious dialects of SQL understood by the databases supported by Hibernate.
org.hibernate.dialect.pagination	Support for Dialect-specific pagination strategies.
org.hibernate.sql.results.jdbc.internal

Uses of LimitHandler in org.hibernate.dialect

Methods in org.hibernate.dialect that return LimitHandler

Modifier and Type	Method	Description
LimitHandler	AbstractHANADialect.getLimitHandler()	Deprecated, for removal: This API element is subject to removal in a future version.
LimitHandler	CockroachDialect.getLimitHandler()
LimitHandler	DB2400Dialect.getLimitHandler()	Deprecated.
LimitHandler	DB2Dialect.getLimitHandler()
LimitHandler	DB2iDialect.getLimitHandler()
LimitHandler	DB2zDialect.getLimitHandler()
LimitHandler	DerbyDialect.getLimitHandler()
LimitHandler	Dialect.getLimitHandler()	Obtain a LimitHandler that implements pagination support for Query.setMaxResults(int) and Query.setFirstResult(int).
LimitHandler	DialectDelegateWrapper.getLimitHandler()
LimitHandler	H2Dialect.getLimitHandler()
LimitHandler	HSQLDialect.getLimitHandler()
LimitHandler	MySQLDialect.getLimitHandler()
LimitHandler	OracleDialect.getLimitHandler()
LimitHandler	PostgreSQLDialect.getLimitHandler()
LimitHandler	SpannerDialect.getLimitHandler()
LimitHandler	SQLServerDialect.getLimitHandler()
LimitHandler	SybaseASEDialect.getLimitHandler()

Uses of LimitHandler in org.hibernate.dialect.pagination

Classes in org.hibernate.dialect.pagination 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.
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.
class	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.
class	FetchLimitHandler	A LimitHandler for databases which support the ANSI SQL standard syntax FETCH FIRST m ROWS ONLY but not OFFSET n ROWS.
class	LegacyDB2LimitHandler	A LimitHandler for DB2.
class	LegacyHSQLLimitHandler	A LimitHandler for HSQL prior to 2.0.
class	LegacyOracleLimitHandler	A LimitHandler for Oracle prior to 12c, which uses ROWNUM.
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.
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.
class	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.
class	SQLServer2005LimitHandler	A LimitHandler compatible with SQL Server 2005 and later that uses top() and rownumber().
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.
class	TopLimitHandler	A LimitHandler for Transact SQL and similar databases which support the syntax SELECT TOP n.

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

Modifier and Type	Field	Description
static LimitHandler	AbstractLimitHandler.NO_LIMIT

Uses of LimitHandler in org.hibernate.sql.results.jdbc.internal

Methods in org.hibernate.sql.results.jdbc.internal that return LimitHandler

Modifier and Type	Method	Description
LimitHandler	DeferredResultSetAccess.getLimitHandler()