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

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

All Implemented Interfaces:

DBDictionary

public class MySQLDictionary

extends GenericDictionary

Implementation of the DBDictionary interface for MySQL.

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

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

Constructor Summary

MySQLDictionary()

Method Summary

Object	blobFromSQL(ResultSet rs, int column)
String[]	getCreateTableSQL(Table table) Override the standard create table SQL to add a table type.
protected String	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.

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

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, getSQLTypeMap, getTables, getValidColumnName, getValidIndexName, getValidTableName, intFromSQL, intToPreparedParameter, intToSQL, localeFromSQL, localeToPreparedParameter, localeToSQL, longFromSQL, longToPreparedParameter, longToSQL, objectFromSQL, objectToPreparedParameter, objectToSQL, setDBMetaData, setNameTruncationVersion, setQuoteNumbers, setSchemaName, shortFromSQL, shortToPreparedParameter, shortToSQL, stringFromSQL, stringToPreparedParameter, tablesToString, toPreparedParameter, toSelect, toSelect, toSQL, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, 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.

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: GenericDictionary

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

Overrides:

getPlatform in class GenericDictionary

getCreateTableSQL

public String[] getCreateTableSQL(Table table)

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

Overrides:

getCreateTableSQL in class GenericDictionary

blobFromSQL

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

Overrides:

blobFromSQL in class GenericDictionary

stringToSQL

public String stringToSQL(String string)

Description copied from class: GenericDictionary

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

Overrides:

stringToSQL in class GenericDictionary

setupSQLTypeMap

protected void setupSQLTypeMap(SQLTypeMap map)

Description copied from class: GenericDictionary

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 GenericDictionary

getDropIndexSQL

protected String getDropIndexSQL(Index index)

Description copied from class: GenericDictionary

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

Overrides:

getDropIndexSQL in class GenericDictionary