Package org.gridgain.cache.store.jdbc.dialect

Class MySqlDialect

java.lang.Object

org.gridgain.cache.store.jdbc.dialect.BasicJdbcDialect

org.gridgain.cache.store.jdbc.dialect.MySqlDialect

All Implemented Interfaces:

JdbcDialect

public class MySqlDialect
extends BasicJdbcDialect

A dialect compatible with the MySQL database.

Field Summary

Fields inherited from class org.gridgain.cache.store.jdbc.dialect.BasicJdbcDialect

DFLT_MAX_PARAMS_CNT, fetchSize, maxParamsCnt

Constructor Summary

Constructors

Constructor	Description
MySqlDialect()	Constructor.

Method Summary

Modifier and Type	Method	Description
String	escape(String ident)	Escape an identifier.
boolean	hasMerge()	Test if a dialect supports merge syntax.
String	loadCacheSelectRangeQuery(String fullTblName, Collection<String> keyCols)	Construct query to get ranges bounds.
String	mergeQuery(String fullTblName, Collection<String> keyCols, Collection<String> uniqCols)	Construct merge query.

Methods inherited from class org.gridgain.cache.store.jdbc.dialect.BasicJdbcDialect

getFetchSize, getMaxParameterCount, insertQuery, loadCacheQuery, loadCacheRangeQuery, loadQuery, mkString, mkString, mkString, removeQuery, repeat, setFetchSize, setMaxParameterCount, updateQuery

Methods inherited from class java.lang.Object

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

Constructor Details

MySqlDialect

public MySqlDialect()

Constructor.

Method Details

escape

public String escape(String ident)

Escape an identifier.

Specified by:

escape in interface JdbcDialect

Overrides:

escape in class BasicJdbcDialect

Parameters:

ident - SQL identifier to escape.

Returns:

Escaped SQL identifier.

loadCacheSelectRangeQuery

public String loadCacheSelectRangeQuery(String fullTblName,
 Collection<String> keyCols)

Construct query to get ranges bounds.

Specified by:

loadCacheSelectRangeQuery in interface JdbcDialect

Overrides:

loadCacheSelectRangeQuery in class BasicJdbcDialect

Parameters:

fullTblName - Full table name.

keyCols - Database key columns for order.

Returns:

Query for select count.

hasMerge

public boolean hasMerge()

Test if a dialect supports merge syntax.

Specified by:

hasMerge in interface JdbcDialect

Overrides:

hasMerge in class BasicJdbcDialect

Returns:

True if database support merge operation.

mergeQuery

public String mergeQuery(String fullTblName,
 Collection<String> keyCols,
 Collection<String> uniqCols)

Construct merge query.

Specified by:

mergeQuery in interface JdbcDialect

Overrides:

mergeQuery in class BasicJdbcDialect

Parameters:

fullTblName - Full table name.

keyCols - Database key columns.

uniqCols - Database unique value columns.

Returns:

Merge query.