Uses of Class
org.hibernate.dialect.pagination.spi.AbstractLimitHandler
Packages that use AbstractLimitHandler
Package
Description
Supported contracts and reusable families for applying pagination to
completed SQL.
-
Uses of AbstractLimitHandler in org.hibernate.dialect.pagination.spi
Subclasses of AbstractLimitHandler in org.hibernate.dialect.pagination.spiModifier and TypeClassDescriptionclassSuperclass 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.