com.solarmetric.kodo.impl.jdbc.schema.dict
Class MySQLDictionary

java.lang.Object
  |
  +--com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary
        |
        +--com.solarmetric.kodo.impl.jdbc.schema.dict.MySQLDictionary

All Implemented Interfaces:

DBDictionary

public class MySQLDictionary

extends AbstractDictionary

Implementation of the DBDictionary interface for MySQL.

Fields inherited from class com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary

CENTI, DECI, meta, MICRO, MILLI, NANO, NUMBER_FORMAT, SEC

Constructor Summary

MySQLDictionary()

Method Summary

Object	blobFromSQL(ResultSet rs, int column)
SQLBuffer[]	getCreateTableSQL(Table table) Override the standard create table SQL to add a table type.
protected SQLBuffer	getDropIndexSQL(Index index) Return the SQL to drop an index.
String	getPlatform() Return the title of this database platform, used for display only.
boolean	getSupportsSelectForUpdate() Return whether this version of MySQL supports the 'SELECT FOR UPDATE' SQL clause.
String	getTableType() Return the MySQL table type to use when creating tables.
void	setSupportsSelectForUpdate(boolean supports) Set whether this version of MySQL supports the 'SELECT FOR UPDATE' SQL clause.
void	setTableType(String tableType) Set the MySQL table type to use when creating tables.
protected void	setupSQLTypeMap(SQLTypeMap map) This is the most commonly overridden method when porting to a new database.
String	stringToSQL(String string) Called from the toSQL method for Strings; by defualt escapes all single quote characters with another single quote.
boolean	supportsLocking() Returns whether or not this database supports locking (e.g., FOR UPDATE clause in SELECT).

Methods inherited from class com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary

addForUpdateClause, bigDecimalFromSQL, bigDecimalToPreparedParameter, bigDecimalToSQL, bigIntegerFromSQL, bigIntegerToPreparedParameter, bigIntegerToSQL, blobToPreparedParameter, blobToSQL, booleanFromSQL, booleanToPreparedParameter, booleanToSQL, byteFromSQL, byteToPreparedParameter, byteToSQL, characterToPreparedParameter, charFromSQL, charToSQL, clobFromSQL, clobToPreparedParameter, clobToSQL, colsToString, dateFromSQL, dateToPreparedParameter, dateToSQL, dateToTimestamp, doubleFromSQL, doubleToPreparedParameter, doubleToSQL, floatFromSQL, floatToPreparedParameter, floatToSQL, fromSQL, getAddColumnSQL, getClassMappingCandidateClasses, getColumnDeclaration, getColumns, getCreateIndexSQL, getDatePrecision, getDBMetaData, getDropColumnSQL, getDropTableSQL, getFieldMappingCandidateClasses, getMaxColumnNameLength, getMaxIndexNameLength, getMaxTableNameLength, getNameTruncationVersion, getQuoteNumbers, getSchemaName, getSimulateLocking, getSQLTypeMap, getStoreCharsAsStrings, getStoreLargeNumbersAsStrings, getTables, getValidateConnections, getValidateConnectionSQL, getValidColumnName, getValidIndexName, getValidTableName, initTypeMap, intFromSQL, intToPreparedParameter, intToSQL, isClosed, localeFromSQL, localeToPreparedParameter, localeToSQL, longFromSQL, longToPreparedParameter, longToSQL, objectFromSQL, objectToPreparedParameter, objectToSQL, prepareLargeNumberAsString, setColumnNameGenerator, setCursorName, setDBMetaData, setIndexNameGenerator, setMaxColumnNameLength, setMaxIndexNameLength, setMaxTableNameLength, setNameTruncationVersion, setNullParameter, setQuoteNumbers, setSchemaName, setSimulateLocking, setStoreCharsAsStrings, setStoreLargeNumbersAsStrings, setTableNameGenerator, setTransactionIsolation, setValidateConnections, setValidateConnectionSQL, shortFromSQL, shortToPreparedParameter, shortToSQL, stringFromSQL, stringToPreparedParameter, supportsUpdateCountsForBatch, tablesToString, toPreparedParameter, toSelect, toSelect, toSelect, toSQL

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDictionary

public MySQLDictionary()

Method Detail

getSupportsSelectForUpdate

public boolean getSupportsSelectForUpdate()

Return whether this version of MySQL supports the 'SELECT FOR UPDATE' SQL clause.

supportsLocking

public boolean supportsLocking()

Description copied from interface: DBDictionary

Returns whether or not this database supports locking (e.g., FOR UPDATE clause in SELECT).

Overrides:

supportsLocking in class AbstractDictionary

setSupportsSelectForUpdate

public void setSupportsSelectForUpdate(boolean supports)

Set whether this version of MySQL supports the 'SELECT FOR UPDATE' SQL clause. Defaults to true.

getTableType

public String getTableType()

Return the MySQL table type to use when creating tables.

setTableType

public void setTableType(String tableType)

Set the MySQL table type to use when creating tables. Defaults to null, in which case the default table type will be used.

getPlatform

public String getPlatform()

Description copied from class: AbstractDictionary

Return the title of this database platform, used for display only.

Overrides:

getPlatform in class AbstractDictionary

getCreateTableSQL

public SQLBuffer[] getCreateTableSQL(Table table)

Override the standard create table SQL to add a table type.

Overrides:

getCreateTableSQL in class AbstractDictionary

blobFromSQL

public Object blobFromSQL(ResultSet rs,
                          int column)
                   throws SQLException

Overrides:

blobFromSQL in class AbstractDictionary

stringToSQL

public String stringToSQL(String string)

Description copied from class: AbstractDictionary

Called from the toSQL method for Strings; by defualt escapes all single quote characters with another single quote.

Overrides:

stringToSQL in class AbstractDictionary

setupSQLTypeMap

protected void setupSQLTypeMap(SQLTypeMap map)

Description copied from class: AbstractDictionary

This is the most commonly overridden method when porting to a new database. Most databases have different mappings between java and SQL types; this method can be used to setup the mappings for the database being ported.

Overrides:

setupSQLTypeMap in class AbstractDictionary

getDropIndexSQL

protected SQLBuffer getDropIndexSQL(Index index)

Description copied from class: AbstractDictionary

Return the SQL to drop an index. Defaults to: DROP INDEX <index-name>

Overrides:

getDropIndexSQL in class AbstractDictionary