Uses of Package
org.hibernate.dialect.pagination.spi
Packages that use org.hibernate.dialect.pagination.spi
Package
Description
Defines the root contracts and built-in implementations for SQL dialects.
Supported contracts and reusable families for applying pagination to
completed SQL.
-
Classes in org.hibernate.dialect.pagination.spi used by org.hibernate.dialectClassDescriptionDialect strategy for applying execution-time limit and offset to already-rendered SQL.
-
Classes in org.hibernate.dialect.pagination.spi used by org.hibernate.dialect.pagination.spiClassDescriptionDefault implementation of
LimitHandlerinterface.Superclass forLimitHandlers that don't support offsets at all.Superclass for simpleLimitHandlers that don't support specifying an offset without a limit.ALimitHandlerfor 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.ALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYbut notOFFSET n ROWS.ALimitHandlerfor DB2.Dialect strategy for applying execution-time limit and offset to already-rendered SQL.Limit handler for MySQL and CUBRID which support the syntaxLIMIT nandLIMIT m, n.ALimitHandlerfor databases like PostgreSQL, H2, and HSQL that support the syntaxLIMIT n OFFSET m.Handler not supporting query LIMIT clause.ALimitHandlerfor databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLYandOFFSET n ROWS FETCH NEXT m ROWS ONLY.ALimitHandlerfor Oracle 12c and later.Immutable JDBC execution instructions produced by aLimitHandlertogether with paginated SQL.Immutable input supplied by Hibernate to aLimitHandlerfor applying execution-time pagination to completed SQL.Immutable result returned byLimitHandler.processSql(PaginationRequest), pairing completed SQL with all JDBC and result-set work required by its pagination.ALimitHandlercompatible 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.ALimitHandlerfor Transact SQL and similar databases which support the syntaxSELECT TOP n.