net.sf.jkniv.whinstone.jdbc.dialect

Class SqlServerDialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jdbc.dialect.SqlServerDialect

All Implemented Interfaces:

net.sf.jkniv.sqlegance.dialect.SqlDialect

public class SqlServerDialect
extends net.sf.jkniv.sqlegance.dialect.AnsiDialect

Dialect to SQLServer

Limit clause: select TOP 2 name from author

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

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

Method Summary

Modifier and Type	Method and Description
String	buildQueryPaging(String sqlText, int offset, int max)
String	getSqlPatternPaging() LIMIT clause for SqlServer, where TOP is a parameter from String.format

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

addFeature, buildQueryCount, 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

SqlServerDialect

public SqlServerDialect()

Method Detail

getSqlPatternPaging

public String getSqlPatternPaging()

LIMIT clause for SqlServer, where TOP is a parameter from String.format

Specified by:

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

Overrides:

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

Returns:

Return query pattern:

   
   WITH query AS (
           SELECT inner_query.*
                , ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) as _jkniv_rownum_
             FROM ( select ID, SERVICO from ine.configuracao ) inner_query
         )
        SELECT * FROM query WHERE _jkniv_rownum_ >= 3 AND _jkniv_rownum_ < 5 + 3
   
 

buildQueryPaging

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

Specified by:

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

Overrides:

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