Uses of Interface
org.hibernate.dialect.pagination.LimitHandler
-
Packages that use LimitHandler Package Description org.hibernate.dialect This package abstracts over the multifarious dialects of SQL understood by the databases supported by Hibernate.org.hibernate.dialect.pagination Support forDialect
-specific pagination strategies.org.hibernate.sql.results.jdbc.internal -
-
Uses of LimitHandler in org.hibernate.dialect
Methods in org.hibernate.dialect that return LimitHandler Modifier and Type Method Description LimitHandler
AbstractHANADialect. getLimitHandler()
LimitHandler
CockroachDialect. getLimitHandler()
LimitHandler
DB2400Dialect. getLimitHandler()
Deprecated.LimitHandler
DB2Dialect. getLimitHandler()
LimitHandler
DB2iDialect. getLimitHandler()
LimitHandler
DB2zDialect. getLimitHandler()
LimitHandler
DerbyDialect. getLimitHandler()
LimitHandler
Dialect. getLimitHandler()
Obtain aLimitHandler
that implements pagination support forQuery.setMaxResults(int)
andQuery.setFirstResult(int)
.LimitHandler
DialectDelegateWrapper. getLimitHandler()
LimitHandler
H2Dialect. getLimitHandler()
LimitHandler
HSQLDialect. getLimitHandler()
LimitHandler
MySQLDialect. getLimitHandler()
LimitHandler
OracleDialect. getLimitHandler()
LimitHandler
PostgreSQLDialect. getLimitHandler()
LimitHandler
SpannerDialect. getLimitHandler()
LimitHandler
SQLServerDialect. getLimitHandler()
LimitHandler
SybaseASEDialect. getLimitHandler()
-
Uses of LimitHandler in org.hibernate.dialect.pagination
Classes in org.hibernate.dialect.pagination that implement LimitHandler Modifier and Type Class Description class
AbstractLimitHandler
Default implementation ofLimitHandler
interface.class
AbstractNoOffsetLimitHandler
Superclass forLimitHandler
s that don't support offsets at all.class
AbstractSimpleLimitHandler
Superclass for simpleLimitHandler
s that don't support specifying an offset without a limit.class
DB2LimitHandler
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
DerbyLimitHandler
ALimitHandler
for Apache Derby, which fully supports the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
.class
FetchLimitHandler
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
but notOFFSET n ROWS
.class
LegacyDB2LimitHandler
ALimitHandler
for DB2.class
LegacyHSQLLimitHandler
ALimitHandler
for HSQL prior to 2.0.class
LegacyOracleLimitHandler
ALimitHandler
for Oracle prior to 12c, which usesROWNUM
.class
LimitLimitHandler
Limit handler for MySQL and CUBRID which support the syntaxLIMIT n
andLIMIT m, n
.class
LimitOffsetLimitHandler
ALimitHandler
for databases like PostgreSQL, H2, and HSQL that support the syntaxLIMIT n OFFSET m
.class
NoopLimitHandler
Handler not supporting query LIMIT clause.class
OffsetFetchLimitHandler
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
.class
Oracle12LimitHandler
ALimitHandler
for databases which support the ANSI SQL standard syntaxFETCH FIRST m ROWS ONLY
andOFFSET n ROWS FETCH NEXT m ROWS ONLY
.class
SQLServer2005LimitHandler
class
SQLServer2012LimitHandler
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
TopLimitHandler
ALimitHandler
for Transact SQL and similar databases which support the syntaxSELECT TOP n
.Fields in org.hibernate.dialect.pagination declared as LimitHandler Modifier and Type Field Description static LimitHandler
AbstractLimitHandler. NO_LIMIT
-
Uses of LimitHandler in org.hibernate.sql.results.jdbc.internal
Methods in org.hibernate.sql.results.jdbc.internal that return LimitHandler Modifier and Type Method Description LimitHandler
DeferredResultSetAccess. getLimitHandler()
-