Uses of Class
org.hibernate.dialect.pagination.AbstractLimitHandler
Packages that use AbstractLimitHandler
-
Uses of AbstractLimitHandler in org.hibernate.dialect.pagination
Subclasses of AbstractLimitHandler in org.hibernate.dialect.paginationModifier and TypeClassDescriptionclass
Superclass forLimitHandler
s that don't support offsets at all.class
Superclass for simpleLimitHandler
s that don't support specifying an offset without a limit.class
ALimitHandler
for DB2 11.1 which supports the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
, with the only wrinkle being that this clause comes after theFOR UPDATE
and other similar clauses.class
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
but notOFFSET n ROWS
.class
ALimitHandler
for DB2.class
ALimitHandler
for HSQL prior to 2.0.class
ALimitHandler
for Oracle prior to 12c, which usesROWNUM
.class
Limit handler for MySQL and CUBRID which support the syntaxLIMIT n
andLIMIT m, n
.class
ALimitHandler
for databases like PostgreSQL, H2, and HSQL that support the syntaxLIMIT n OFFSET m
.class
Handler not supporting query LIMIT clause.class
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
.class
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
.class
class
ALimitHandler
compatible 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 BY
clause, and with the wrinkle that bothORDER BY
and theOFFSET
clause are required.class
ALimitHandler
for Transact SQL and similar databases which support the syntaxSELECT TOP n
.