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

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

All Implemented Interfaces:

DBDictionary

public class OracleDictionary

extends GenericDictionary

Implementation of the DBDictionary interface for Oracle.

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

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

Constructor Summary

OracleDictionary()

Method Summary

Object	blobFromSQL(ResultSet rs, int column)
void	blobToPreparedParameter(PreparedStatement st, int i, Object o)
Object	blobToSQL(Object val)
String	clobFromSQL(ResultSet rs, int column)
void	clobToPreparedParameter(PreparedStatement st, int i, String str)
Object	clobToSQL(Object val)
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.
Class[]	getFieldMappingCandidateClasses() Returns a list of possible FieldMapping classes for use with this DBDictionary.
String	getPlatform() Return the title of this database platform, used for display only.
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) Appends the given pieces using standard SQL.

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

bigDecimalFromSQL, bigDecimalToPreparedParameter, bigDecimalToSQL, bigIntegerFromSQL, bigIntegerToPreparedParameter, bigIntegerToSQL, booleanFromSQL, booleanToPreparedParameter, booleanToSQL, byteFromSQL, byteToPreparedParameter, byteToSQL, characterToPreparedParameter, charFromSQL, charToSQL, colsToString, dateFromSQL, dateToPreparedParameter, dateToSQL, dateToTimestamp, doubleFromSQL, doubleToPreparedParameter, doubleToSQL, floatFromSQL, floatToPreparedParameter, floatToSQL, fromSQL, getAddColumnSQL, getClassMappingCandidateClasses, getColumnDeclaration, getColumns, getCreateIndexSQL, getCreateTableSQL, getDatePrecision, getDBMetaData, getDropIndexSQL, getDropTableSQL, 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, 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

OracleDictionary

public OracleDictionary()

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

blobToSQL

public Object blobToSQL(Object val)

Overrides:

blobToSQL in class GenericDictionary

clobToSQL

public Object clobToSQL(Object val)

Overrides:

clobToSQL in class GenericDictionary

blobFromSQL

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

Overrides:

blobFromSQL in class GenericDictionary

blobToPreparedParameter

public void blobToPreparedParameter(PreparedStatement st,
                                    int i,
                                    Object o)
                             throws SQLException

Overrides:

blobToPreparedParameter in class GenericDictionary

clobFromSQL

public String clobFromSQL(ResultSet rs,
                          int column)
                   throws SQLException

Overrides:

clobFromSQL in class GenericDictionary

clobToPreparedParameter

public void clobToPreparedParameter(PreparedStatement st,
                                    int i,
                                    String str)
                             throws SQLException

Overrides:

clobToPreparedParameter 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

toSelect

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

Description copied from class: GenericDictionary

Appends the given pieces using standard SQL.

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

getFieldMappingCandidateClasses

public Class[] getFieldMappingCandidateClasses()

Description copied from interface: DBDictionary

Returns a list of possible FieldMapping classes for use with this DBDictionary.

Overrides:

getFieldMappingCandidateClasses in class GenericDictionary