sf.qof.dialect
Class OracleDialect

java.lang.Object
  sf.qof.dialect.OracleDialect

All Implemented Interfaces:

SQLDialect

public class OracleDialect
extends Object
implements SQLDialect

Implements Oracle specific SQL syntax.

Constructor Summary

OracleDialect()

Method Summary

String	getLimitString(String sql, boolean hasOffset) Returns a modified SQL select statement that allows limiting the number of rows returned.
boolean	limitAddOffset() Returns true if the offset needs to be added to maximum number of rows.
boolean	limitOffsetFirst() Returns true if the offset parameter is in front of the maximum number of rows parameter.
boolean	limitParametersBeforeQueryParameters() Returns true is the parameters to set the maximum number of rows and optionally the offset are the first parameters in the prepared select statement.

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDialect

public OracleDialect()

Method Detail

getLimitString

public String getLimitString(String sql,
                             boolean hasOffset)

Description copied from interface: SQLDialect

Returns a modified SQL select statement that allows limiting the number of rows returned. This is used to implement paging.

If hasOffset is true the SQL select statement that is returned must allow to set an offset as well as the number of rows.

Specified by:

getLimitString in interface SQLDialect

Parameters:

sql - the select SQL statement

hasOffset - true is an offset should be set

Returns:

the modified SQL statement

See Also:

Paging, SQLDialect.limitParametersBeforeQueryParameters(), SQLDialect.limitAddOffset(), SQLDialect.limitOffsetFirst()

limitParametersBeforeQueryParameters

public boolean limitParametersBeforeQueryParameters()

Description copied from interface: SQLDialect

Returns true is the parameters to set the maximum number of rows and optionally the offset are the first parameters in the prepared select statement. This is used to implement paging.

Specified by:

limitParametersBeforeQueryParameters in interface SQLDialect

Returns:

true if limitation parameters are before the query parameters

limitAddOffset

public boolean limitAddOffset()

Description copied from interface: SQLDialect

Returns true if the offset needs to be added to maximum number of rows. This is used to implement paging.

Specified by:

limitAddOffset in interface SQLDialect

Returns:

true if offset and maximum number of rows need to added

limitOffsetFirst

public boolean limitOffsetFirst()

Description copied from interface: SQLDialect

Returns true if the offset parameter is in front of the maximum number of rows parameter. This is used to implement paging.

Specified by:

limitOffsetFirst in interface SQLDialect

Returns:

true if offset is set first