Package com.blazebit.persistence.impl.dialect

Class AbstractDbmsLimitHandler

java.lang.Object

com.blazebit.persistence.impl.dialect.AbstractDbmsLimitHandler

All Implemented Interfaces:

DbmsLimitHandler

Direct Known Subclasses:

DB2DbmsLimitHandler, DefaultDbmsLimitHandler, MSSQL2012DbmsLimitHandler, MySQLDbmsLimitHandler, OracleDbmsLimitHandler, SQL2008DbmsLimitHandler

public abstract class AbstractDbmsLimitHandler
extends Object
implements DbmsLimitHandler

Since:

1.2.0

Author:

Christian Beikov

Constructor Summary

Constructors

Constructor	Description
AbstractDbmsLimitHandler(int length)

Method Summary

Modifier and Type	Method	Description
String	applySql(String sql, boolean isSubquery, Integer limit, Integer offset)
String	applySqlInlined(String sql, boolean isSubquery, Integer limit, Integer offset)
int	bindLimitParametersAtStartOfQuery(Integer limit, Integer offset, PreparedStatement statement, int index)
boolean	limitIncludesOffset()
void	setMaxRows(Integer limit, Integer offset, PreparedStatement statement)
boolean	supportsLimit()
boolean	supportsLimitOffset()
protected abstract boolean	supportsVariableLimit()	Returns whether the dbms supports parameters for LIMIT and OFFSET via prepared statements.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.blazebit.persistence.spi.DbmsLimitHandler

applySql, bindLimitParametersAtEndOfQuery

Constructor Details

AbstractDbmsLimitHandler

public AbstractDbmsLimitHandler(int length)

Parameters:

length - The expected maximum length of the string representation for the LIMIT/OFFSET SQL

Method Details

supportsLimit

public boolean supportsLimit()

Specified by:

supportsLimit in interface DbmsLimitHandler

supportsLimitOffset

public boolean supportsLimitOffset()

Specified by:

supportsLimitOffset in interface DbmsLimitHandler

limitIncludesOffset

public boolean limitIncludesOffset()

Specified by:

limitIncludesOffset in interface DbmsLimitHandler

supportsVariableLimit

protected abstract boolean supportsVariableLimit()

Returns whether the dbms supports parameters for LIMIT and OFFSET via prepared statements.

Returns:

True if parameters allowed, otherwise false

applySql

public String applySql(String sql,
 boolean isSubquery,
 Integer limit,
 Integer offset)

Specified by:

applySql in interface DbmsLimitHandler

applySqlInlined

public String applySqlInlined(String sql,
 boolean isSubquery,
 Integer limit,
 Integer offset)

Specified by:

applySqlInlined in interface DbmsLimitHandler

bindLimitParametersAtStartOfQuery

public int bindLimitParametersAtStartOfQuery(Integer limit,
 Integer offset,
 PreparedStatement statement,
 int index)
                                      throws SQLException

Specified by:

bindLimitParametersAtStartOfQuery in interface DbmsLimitHandler

Throws:

SQLException

setMaxRows

public void setMaxRows(Integer limit,
 Integer offset,
 PreparedStatement statement)
                throws SQLException

Specified by:

setMaxRows in interface DbmsLimitHandler

Throws:

SQLException