Top Description Interfaces Classes

[default module]

Package org.hibernate.dialect.pagination

Support for org.hibernate.dialect.Dialect-specific pagination strategies.

See Also: org.hibernate.dialect.pagination.LimitHandler

Interface Summary

Modifier and Type	Interface and Description
public interface	LimitHandler Contract defining dialect-specific limit and offset handling.

Class Summary

Modifier and Type	Class and Description
public abstract class	AbstractLimitHandler Default implementation of `LimitHandler` interface.
public abstract class	AbstractNoOffsetLimitHandler Superclass for `LimitHandler`s that don't support offsets at all.
public abstract class	AbstractSimpleLimitHandler Superclass for simple `LimitHandler`s that don't support specifying an offset without a limit.
public 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.
public 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`.
public class	FetchLimitHandler A `LimitHandler` for databases which support the ANSI SQL standard syntax `FETCH FIRST m ROWS ONLY` but not `OFFSET n ROWS`.
public class	LegacyDB2LimitHandler A `LimitHandler` for DB2.
public class	LegacyHSQLLimitHandler A `LimitHandler` for HSQL prior to 2.0.
public class	LegacyOracleLimitHandler A `LimitHandler` for Oracle prior to 12c, which uses `ROWNUM`.
public class	LimitLimitHandler Limit handler for MySQL and CUBRID which support the syntax `LIMIT n` and `LIMIT m, n`.
public class	LimitOffsetLimitHandler A `LimitHandler` for databases like PostgreSQL, H2, and HSQL that support the syntax `LIMIT n OFFSET m`.
public class	NoopLimitHandler Handler not supporting query LIMIT clause.
public 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`.
public 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`.
public class	SQLServer2005LimitHandler A `LimitHandler` compatible with SQL Server 2005 and later that uses `top()` and `rownumber()`.
public 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.
public class	TopLimitHandler A `LimitHandler` for Transact SQL and similar databases which support the syntax `SELECT TOP n`.