Uses of Interface
org.hibernate.dialect.pagination.spi.LimitHandler
Packages that use LimitHandler
Package
Description
Defines the root contracts and built-in implementations for SQL dialects.
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 LimitHandlerModifier and TypeMethodDescriptionCockroachDialect.getLimitHandler()DB2Dialect.getLimitHandler()DB2iDialect.getLimitHandler()DB2zDialect.getLimitHandler()Dialect.getLimitHandler()Supplies execution-time pagination for already-rendered SQL requested byQuery.setMaxResults(int)orQuery.setFirstResult(int).H2Dialect.getLimitHandler()HANADialect.getLimitHandler()HSQLDialect.getLimitHandler()MySQLDialect.getLimitHandler()OracleDialect.getLimitHandler()PostgreSQLDialect.getLimitHandler()SpannerDialect.getLimitHandler()SpannerPostgreSQLDialect.getLimitHandler()SQLServerDialect.getLimitHandler()SybaseASEDialect.getLimitHandler() -
Uses of LimitHandler in org.hibernate.dialect.pagination.spi
Classes in org.hibernate.dialect.pagination.spi that implement LimitHandlerModifier and TypeClassDescriptionclassDefault implementation ofLimitHandlerinterface.classSuperclass forLimitHandlers that don't support offsets at all.classSuperclass for simpleLimitHandlers that don't support specifying an offset without a limit.final classALimitHandlerfor DB2 11.1 which supports the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYandOFFSET n ROWS FETCH NEXT m ROWS ONLY, with the only wrinkle being that this clause comes after theFOR UPDATEand other similar clauses.final classALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYbut notOFFSET n ROWS.final classALimitHandlerfor DB2.classLimit handler for MySQL and CUBRID which support the syntaxLIMIT nandLIMIT m, n.classALimitHandlerfor databases like PostgreSQL, H2, and HSQL that support the syntaxLIMIT n OFFSET m.final classHandler not supporting query LIMIT clause.classALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYandOFFSET n ROWS FETCH NEXT m ROWS ONLY.final classALimitHandlerfor Oracle 12c and later.final classALimitHandlercompatible with SQL Server 2012 which introduced support for the ANSI SQL standard syntaxOFFSET m ROWS FETCH NEXT n ROWS ONLY, though this syntax is considered part of theORDER BYclause, and with the wrinkle that bothORDER BYand theOFFSETclause are required.final classALimitHandlerfor Transact SQL and similar databases which support the syntaxSELECT TOP n.Fields in org.hibernate.dialect.pagination.spi declared as LimitHandler