net.sf.jkniv.whinstone.jdbc.dialect

Class OracleDialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.OracleDialect

All Implemented Interfaces:

SqlDialect

Direct Known Subclasses:

Oracle12cDialect

public class OracleDialect
extends AnsiDialect

Default dialect do Oracle

Limit clause: select name from author LIMIT 1 OFFSET 2 select * from ( select row_.*, rownum rownum_ from (select name from author ) row_ where rownum <= 5) where rownum_ > 15

• Supports limits? true
• Supports limit off set? true
• Supports rownum? true

Since:

0.6.0

Author:

Alisson Gomes

Field Summary

Fields inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

name, patternORDER_BY

Constructor Summary

Constructors

Constructor and Description
OracleDialect()

Method Summary

Modifier and Type	Method and Description
String	buildQueryPaging(String sqlText, int offset, int max) Build a paginate query accordingly data base dialect
int	getMaxOfParameters() Return the limit of elements in an INPUT parameter the database supports.
String	getSqlPatternPaging() The template to mount the SQL paginated, using LIMIT and OFFSET clauses according the specific database

Methods inherited from class net.sf.jkniv.sqlegance.dialect.AnsiDialect

addFeature, buildQueryCount, buildQueryPaging, countOccurrencesOf, getAccessId, getAccessRevision, getSqlPatternCount, name, setMaxOfParameters, sqlEndsWithOrderBy, sqlEndWithForUpdate, sqlStartWithSelect, sqlStartWithSelectOrDistinct, supportsFeature, supportsParmMark

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

getMaxOfParameters

public int getMaxOfParameters()

Description copied from interface: SqlDialect

Return the limit of elements in an INPUT parameter the database supports.

Specified by:

getMaxOfParameters in interface SqlDialect

Overrides:

getMaxOfParameters in class AnsiDialect

Returns:

the limit of parameters from statement, default is a big number Integer.MAX_VALUE

getSqlPatternPaging

public String getSqlPatternPaging()

Description copied from interface: SqlDialect

The template to mount the SQL paginated, using LIMIT and OFFSET clauses according the specific database

Specified by:

getSqlPatternPaging in interface SqlDialect

Overrides:

getSqlPatternPaging in class AnsiDialect

Returns:

Return query pattern: select * from ( select row_.*, rownum rownum_ from (%1$s) row_ where rownum <= %2$s) where rownum_ > %3$s

buildQueryPaging

public String buildQueryPaging(String sqlText,
                               int offset,
                               int max)

Description copied from interface: SqlDialect

Build a paginate query accordingly data base dialect

Specified by:

buildQueryPaging in interface SqlDialect

Overrides:

buildQueryPaging in class AnsiDialect

Parameters:

sqlText - final SQL with parameters to bind

offset - number from first row from query result

max - maximum number of rows from query result.

Returns:

paginate query for specific data base dialect