public class TopLimitHandler extends AbstractLimitHandler
Constructor and Description |
---|
TopLimitHandler(boolean supportsVariableLimit,
boolean bindLimitParametersFirst) |
Modifier and Type | Method and Description |
---|---|
boolean |
bindLimitParametersFirst()
Does the <tt>LIMIT</tt> clause come at the start of the
<tt>SELECT</tt> statement, rather than at the end?
|
String |
processSql(String sql,
RowSelection selection)
Return processed SQL query.
|
boolean |
supportsLimit()
Does this handler support some form of limiting query results
via a SQL clause?
|
boolean |
supportsLimitOffset()
Does this handler’s LIMIT support (if any) additionally
support specifying an offset?
|
boolean |
supportsVariableLimit()
Does this handler support bind variables (i.e., prepared statement
parameters) for its limit/offset?
|
boolean |
useMaxForLimit()
Does the <tt>LIMIT</tt> clause take a "maximum" row number instead
of a total number of returned rows?
<p/>
This is easiest understood via an example.
|
bindLimitParameters, bindLimitParametersAtEndOfQuery, bindLimitParametersAtStartOfQuery, bindLimitParametersInReverseOrder, convertToFirstRowValue, forceLimitUsage, getMaxOrLimit, setMaxRows
public TopLimitHandler(boolean supportsVariableLimit, boolean bindLimitParametersFirst)
public boolean supportsLimit()
LimitHandler
Does this handler support some form of limiting query results via a SQL clause?
supportsLimit
in interface LimitHandler
supportsLimit
in class AbstractLimitHandler
public boolean useMaxForLimit()
AbstractLimitHandler
Does the <tt>LIMIT</tt> clause take a "maximum" row number instead of a total number of returned rows? <p/> This is easiest understood via an example. Consider you have a table with 20 rows, but you only want to retrieve rows number 11 through 20. Generally, a limit with offset would say that the offset = 11 and the limit = 10 (we only want 10 rows at a time); this is specifying the total number of returned rows. Some dialects require that we instead specify offset = 11 and limit = 20, where 20 is the "last" row we want relative to offset (i.e. total number of rows = 20 - 11 = 9) <p/> So essentially, is limit relative from offset? Or is limit absolute?
useMaxForLimit
in class AbstractLimitHandler
public boolean supportsLimitOffset()
LimitHandler
Does this handler’s LIMIT support (if any) additionally support specifying an offset?
supportsLimitOffset
in interface LimitHandler
supportsLimitOffset
in class AbstractLimitHandler
public boolean supportsVariableLimit()
AbstractLimitHandler
Does this handler support bind variables (i.e., prepared statement parameters) for its limit/offset?
supportsVariableLimit
in class AbstractLimitHandler
public boolean bindLimitParametersFirst()
AbstractLimitHandler
Does the <tt>LIMIT</tt> clause come at the start of the <tt>SELECT</tt> statement, rather than at the end?
bindLimitParametersFirst
in class AbstractLimitHandler
public String processSql(String sql, RowSelection selection)
LimitHandler
Return processed SQL query.
processSql
in interface LimitHandler
processSql
in class AbstractLimitHandler
sql
- the SQL query to process.selection
- the selection criteria for rows.Copyright © 2001-2018 Red Hat, Inc. All Rights Reserved.