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

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

All Implemented Interfaces:

DBDictionary

public class DB2Dictionary

extends GenericDictionary

Implementation of the DBDictionary interface for IBM DB2.

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

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

Constructor Summary

DB2Dictionary()

Method Summary

Object	charToSQL(char val) Convert data into SQL for the current database platform.
String[]	getDropColumnSQL(Column column) DB2 can't deal with dropping columns.
int	getMaxIndexNameLength()
int	getMaxTableNameLength()
String	getPlatform() Return the title of this database platform, used for display only.
protected void	setupSQLTypeMap(SQLTypeMap map) This limits the upper size on BLOB and CLOB to 1 megabyte.
String	toSelect(String[] cols, String[] tables, String where, String order, boolean distinct, boolean update) This could probably be done better.

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

bigDecimalFromSQL, bigDecimalToPreparedParameter, bigDecimalToSQL, bigIntegerFromSQL, bigIntegerToPreparedParameter, bigIntegerToSQL, blobFromSQL, blobToPreparedParameter, blobToSQL, booleanFromSQL, booleanToPreparedParameter, booleanToSQL, byteFromSQL, byteToPreparedParameter, byteToSQL, characterToPreparedParameter, charFromSQL, clobFromSQL, clobToPreparedParameter, clobToSQL, colsToString, dateFromSQL, dateToPreparedParameter, dateToSQL, dateToTimestamp, doubleFromSQL, doubleToPreparedParameter, doubleToSQL, floatFromSQL, floatToPreparedParameter, floatToSQL, fromSQL, getAddColumnSQL, getClassMappingCandidateClasses, getColumnDeclaration, getColumns, getCreateIndexSQL, getCreateTableSQL, getDatePrecision, getDBMetaData, getDropIndexSQL, getDropTableSQL, getFieldMappingCandidateClasses, getMaxColumnNameLength, 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, stringToSQL, tablesToString, toPreparedParameter, toSelect, toSQL, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

DB2Dictionary

public DB2Dictionary()

Method Detail

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

getDropColumnSQL

public String[] getDropColumnSQL(Column column)

DB2 can't deal with dropping columns.

Overrides:

getDropColumnSQL in class GenericDictionary

setupSQLTypeMap

protected void setupSQLTypeMap(SQLTypeMap map)

This limits the upper size on BLOB and CLOB to 1 megabyte.

Overrides:

setupSQLTypeMap in class GenericDictionary

getMaxTableNameLength

public int getMaxTableNameLength()

Overrides:

getMaxTableNameLength in class GenericDictionary

Following copied from class: com.solarmetric.kodo.impl.jdbc.schema.dict.GenericDictionary

Returns:

The maximum length of table names allowed in this database. Defaults to 30.

getMaxIndexNameLength

public int getMaxIndexNameLength()

Overrides:

getMaxIndexNameLength in class GenericDictionary

Following copied from class: com.solarmetric.kodo.impl.jdbc.schema.dict.GenericDictionary

Returns:

The maximum length of index names allowed in this database. Defaults to 30.

toSelect

public String toSelect(String[] cols,
                       String[] tables,
                       String where,
                       String order,
                       boolean distinct,
                       boolean update)

This could probably be done better. DB2 does understand FOR UPDATE sometimes, but not always. ### this means that pessimistic locking is broken.

Overrides:

toSelect in class GenericDictionary

Following copied from interface: com.solarmetric.kodo.impl.jdbc.schema.DBDictionary

Parameters:

cols - list of values the columns to select

tables - list of the tables to select from

where - the WHERE conditions; may be null if none

order - the ORDER BY conditions; may be null if none

distinct - if true, this should be a SELECT DISTINCT-equivalent query

update - if true this should be a SELECT FOR UPDATE-equivalent query

charToSQL

public Object charToSQL(char val)

Description copied from interface: DBDictionary

Convert data into SQL for the current database platform.

Overrides:

charToSQL in class GenericDictionary