net.sf.jkniv.whinstone.jpa2.dialect

Class JpaDialect

java.lang.Object

net.sf.jkniv.sqlegance.dialect.AnsiDialect

net.sf.jkniv.whinstone.jpa2.dialect.JpaDialect

All Implemented Interfaces:

SqlDialect

public class JpaDialect
extends AnsiDialect

Dialect to JPA

Limit clause: select name from author LIMIT 1

• Supports limits? true
• Supports limit off set? true
• 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
JpaDialect()

Method Summary

Modifier and Type	Method and Description
String	buildQueryPaging(String sqlText, int offset, int max) Build a paginate query accordingly data base dialect
String	buildQueryPaging(String sqlText, int offset, int max, String bookmark) Build a paginate query accordingly data base dialect

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

addFeature, buildQueryCount, countOccurrencesOf, getAccessId, getAccessRevision, getMaxOfParameters, getSqlPatternCount, getSqlPatternPaging, 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

JpaDialect

public JpaDialect()

Method Detail

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

buildQueryPaging

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

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.

bookmark - a page selected marked the reader's place

Returns:

paginate query for specific data base dialect