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

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

All Implemented Interfaces:

DBDictionary

Direct Known Subclasses:

HSQLTCKDictionary

public class HSQLDictionary

extends GenericDictionary

Implementation of the DBDictionary interface for Hypersonic SQL.

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

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

Constructor Summary

HSQLDictionary()

Method Summary

String[]	getAddColumnSQL(Column column) Return a series of SQL statements to add the given column to its table, including the addition of any indexes on the column.
String[]	getDropColumnSQL(Column column) Return a series of SQL statements to drop the given column from its table, including the deletion of any indices from the column.
String	getPlatform() Return the title of this database platform, used for display only.
String	getValidIndexName(String name) Limits index names to getMaxIndexNameLength()-1 plus an 'I' that is appended to the end of the given name to avoid SQL keyword conflicts.
protected void	setupSQLTypeMap(SQLTypeMap map) This is the most commonly overridden method when porting to a new database.
String	toSelect(String[] cols, String[] tables, String where, String order, boolean distinct, boolean update) Hsql does not understand FOR UPDATE.

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, charToSQL, clobFromSQL, clobToPreparedParameter, clobToSQL, colsToString, dateFromSQL, dateToPreparedParameter, dateToSQL, dateToTimestamp, doubleFromSQL, doubleToPreparedParameter, doubleToSQL, floatFromSQL, floatToPreparedParameter, floatToSQL, fromSQL, getClassMappingCandidateClasses, getColumnDeclaration, getColumns, getCreateIndexSQL, getCreateTableSQL, getDatePrecision, getDBMetaData, getDropIndexSQL, getDropTableSQL, getFieldMappingCandidateClasses, getMaxColumnNameLength, getMaxIndexNameLength, getMaxTableNameLength, getNameTruncationVersion, getQuoteNumbers, getSchemaName, getSQLTypeMap, getTables, getValidColumnName, 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

HSQLDictionary

public HSQLDictionary()

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

toSelect

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

Hsql does not understand FOR UPDATE.

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

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

getValidIndexName

public String getValidIndexName(String name)

Limits index names to getMaxIndexNameLength()-1 plus an 'I' that is appended to the end of the given name to avoid SQL keyword conflicts.

Overrides:

getValidIndexName in class GenericDictionary

getAddColumnSQL

public String[] getAddColumnSQL(Column column)

Description copied from interface: DBDictionary

Return a series of SQL statements to add the given column to its table, including the addition of any indexes on the column.

Overrides:

getAddColumnSQL in class GenericDictionary

getDropColumnSQL

public String[] getDropColumnSQL(Column column)

Description copied from interface: DBDictionary

Return a series of SQL statements to drop the given column from its table, including the deletion of any indices from the column.

Overrides:

getDropColumnSQL in class GenericDictionary