Package org.javalite.activejdbc.dialects

Class H2Dialect

java.lang.Object

org.javalite.activejdbc.dialects.DefaultDialect

org.javalite.activejdbc.dialects.H2Dialect

All Implemented Interfaces:

Serializable, Dialect

public class H2Dialect
extends DefaultDialect

Supports features of the h2 sql dialect. h2 database sql is very standard, and the developer seems to be adding Postgres and Mysql compatibility.

Author:

Phil Suh (http://filsa.net/)

See Also:

http://www.h2database.com/html/grammar.html, Serialized Form

Field Summary

Fields inherited from class org.javalite.activejdbc.dialects.DefaultDialect

GROUP_BY_PATTERN, ORDER_BY_PATTERN

Constructor Summary

Constructors

Constructor	Description
H2Dialect()

Method Summary

Modifier and Type	Method	Description
String	formSelect(String tableName, String[] columns, String subQuery, List<String> orderBys, long limit, long offset)	Generates adds limit, offset and order bys to a sub-query

Methods inherited from class org.javalite.activejdbc.dialects.DefaultDialect

appendDate, appendEmptyRow, appendOrderBy, appendQuestions, appendSelect, appendSubQuery, appendTime, appendTimestamp, appendValue, deleteManyToManyAssociation, insert, insertManyToManyAssociation, insertParametrized, overrideDriverTypeConversion, replace, selectCount, selectCount, selectExists, selectManyToManyAssociation, selectStar, selectStar, selectStarParametrized, toArray, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

H2Dialect

public H2Dialect()

Method Details

formSelect

public String formSelect(String tableName,
 String[] columns,
 String subQuery,
 List<String> orderBys,
 long limit,
 long offset)

Generates adds limit, offset and order bys to a sub-query

Specified by:

formSelect in interface Dialect

Overrides:

formSelect in class DefaultDialect

Parameters:

tableName - name of table. If table name is null, then the subQuery parameter is considered to be a full query, and all that needs to be done is to add limit, offset and order bys

columns - not used in this implementation

subQuery - sub-query or a full query

orderBys -

limit -

offset -

Returns:

query with