net.sf.jkniv.whinstone.jdbc.dialect

Class Derby10o7Dialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.Derby10o4Dialect

net.sf.jkniv.whinstone.jdbc.dialect.Derby10o7Dialect

All Implemented Interfaces:

SqlDialect

public class Derby10o7Dialect
extends Derby10o4Dialect

Dialect to Derby version 10.7

Limit clause: select name from author OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY

• 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
Derby10o7Dialect()

Method Summary

Modifier and Type	Method and Description
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, buildQueryPaging, countOccurrencesOf, getAccessId, getAccessRevision, getMaxOfParameters, 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

Derby10o7Dialect

public Derby10o7Dialect()

Method Detail

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:

a string template, like that: %1$s LIMIT %2$s, %3$s