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:

net.sf.jkniv.sqlegance.dialect.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()

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

Specified by:

getSqlPatternPaging in interface net.sf.jkniv.sqlegance.dialect.SqlDialect

Overrides:

getSqlPatternPaging in class net.sf.jkniv.sqlegance.dialect.AnsiDialect