Uses of Interface
org.hibernate.dialect.pagination.LimitHandler
Packages that use LimitHandler
Package
Description
This package abstracts over the multifarious dialects of SQL
understood by the databases supported by Hibernate.
Support for
Dialect-specific pagination strategies.-
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()Obtain aLimitHandlerthat implements pagination support forQuery.setMaxResults(int)andQuery.setFirstResult(int).H2Dialect.getLimitHandler()HANADialect.getLimitHandler()HSQLDialect.getLimitHandler()MySQLDialect.getLimitHandler()OracleDialect.getLimitHandler()PostgreSQLDialect.getLimitHandler()SpannerDialect.getLimitHandler()SQLServerDialect.getLimitHandler()SybaseASEDialect.getLimitHandler() -
Uses of LimitHandler in org.hibernate.dialect.pagination
Classes in org.hibernate.dialect.pagination 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.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.classALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYbut notOFFSET n ROWS.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.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.classALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYandOFFSET n ROWS FETCH NEXT m ROWS ONLY.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.classALimitHandlerfor Transact SQL and similar databases which support the syntaxSELECT TOP n.Fields in org.hibernate.dialect.pagination declared as LimitHandler -
Uses of LimitHandler in org.hibernate.sql.results.jdbc.internal
Methods in org.hibernate.sql.results.jdbc.internal that return LimitHandler