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

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

public class OracleDictionary

extends DBDictionary

Dictionary for Oracle.

Field Summary

Fields inherited from class com.solarmetric.rd.kodo.impl.jdbc.schema.DBDictionary

CENTI, DECI, MICRO, MILLI, NANO, SEC

Constructor Summary

OracleDictionary()

Method Summary

boolean	generateForeignKeys(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group, java.lang.String schemaName, java.lang.String tableName, java.sql.Connection conn, java.sql.DatabaseMetaData meta) By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema.
boolean	generateIndexes(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group, java.lang.String schemaName, java.lang.String tableName, java.sql.Connection conn, java.sql.DatabaseMetaData meta) By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema.
boolean	generatePrimaryKeys(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group, java.lang.String schemaName, java.lang.String tableName, java.sql.Connection conn, java.sql.DatabaseMetaData meta) By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema.
java.lang.String	getClobString(java.sql.ResultSet rs, int column) Convert the specified column of the SQL ResultSet to the proper java type.
int	getJDBCType(java.lang.String typeName) Return the corresponding JDBC type for a given unhandled type (e.g.
java.lang.String	getPlatform() Return the database platform for this dictionary.
int	getPreferredType(int type) Return the preferred Types type for the given one.
com.solarmetric.rd.kodo.impl.jdbc.meta.FieldMapping	replaceMapping(com.solarmetric.rd.kodo.impl.jdbc.meta.FieldMapping mapping) Replace the given mapping with one suited to this database, or return the original if no replacement is needed.
com.solarmetric.rd.kodo.impl.jdbc.meta.MappingFactory	replaceMappingFactory(com.solarmetric.rd.kodo.impl.jdbc.meta.MappingFactory factory) Replace the given factory with one suited to this database, or return the original if no replacement is needed.
com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaFactory	replaceSchemaFactory(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaFactory factory) Replace the given factory with one suited to this database, or return the original if no replacement is needed.
void	setNull(java.sql.PreparedStatement stmnt, int idx, int colType) Set the given value as a parameters to the statement.
boolean	supportsUpdateCountsForBatch() Return true if the database returns meaningful update counts on batched statements.
com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer	toSelect(com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer select, java.lang.String tables, com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer where, com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer order, boolean distinct, boolean forUpdate) Create a SELECT statement for this database.

Methods inherited from class com.solarmetric.rd.kodo.impl.jdbc.schema.DBDictionary

addSystemSchema, addSystemTable, generateTables, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getArray, getAsciiStream, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getByte, getBytes, getChar, getCharacterStream, getClob, getConfiguration, getCreateIndexSQL, getCreateTableSQL, getDate, getDate, getDatePrecision, getDBMetaData, getDeclareColumnSQL, getDouble, getDropColumnSQL, getDropForeignKeySQL, getDropIndexSQL, getDropPrimaryKeySQL, getDropTableSQL, getFloat, getForeignKeyActionName, getForeignKeyConstraintSQL, getInt, getJDBCType, getLocale, getLong, getObject, getPrimaryKeyConstraintSQL, getRef, getShort, getSimulateLocking, getStoreCharsAsNumbers, getStoreLargeNumbersAsStrings, getString, getSystemSchemas, getSystemTables, getTime, getTimestamp, getTypeName, getValidColumnName, getValidForeignKeyName, getValidIndexName, getValidPrimaryKeyName, getValidTableName, isSystemIndex, isSystemTable, makeNameValid, setArray, setAsciiStream, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setByte, setBytes, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDBMetaData, setDouble, setFloat, setInt, setLocale, setLong, setObject, setRef, setShort, setSimulateLocking, setStoreCharsAsNumbers, setStoreLargeNumbersAsStrings, setString, setSystemSchemas, setSystemTables, setTime, setTimestamp, supportsDeferredConstraints, supportsForeignKeyDeleteAction, supportsSelectForUpdate, wrapConnection

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDictionary

public OracleDictionary()

Method Detail

getPlatform

public java.lang.String getPlatform()

Description copied from class: DBDictionary

Return the database platform for this dictionary.

Overrides:

getPlatform in class DBDictionary

supportsUpdateCountsForBatch

public boolean supportsUpdateCountsForBatch()

Description copied from class: DBDictionary

Return true if the database returns meaningful update counts on batched statements. Returns true by default.

Overrides:

supportsUpdateCountsForBatch in class DBDictionary

getPreferredType

public int getPreferredType(int type)

Description copied from class: DBDictionary

Return the preferred Types type for the given one. Returns the given type by default.

Overrides:

getPreferredType in class DBDictionary

getJDBCType

public int getJDBCType(java.lang.String typeName)

Description copied from class: DBDictionary

Return the corresponding JDBC type for a given unhandled type (e.g. for Types.OTHER). Currently, the system will only query on OTHER. Returns Types.OTHER by default.

Overrides:

getJDBCType in class DBDictionary

Parameters:

typeName - corresponds to DatabaseMetaData.getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String) TYPE_NAME column

toSelect

public com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer toSelect(com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer select,
                                                                   java.lang.String tables,
                                                                   com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer where,
                                                                   com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer order,
                                                                   boolean distinct,
                                                                   boolean forUpdate)

Description copied from class: DBDictionary

Create a SELECT statement for this database.

Overrides:

toSelect in class DBDictionary

setNull

public void setNull(java.sql.PreparedStatement stmnt,
                    int idx,
                    int colType)
             throws java.sql.SQLException

Description copied from class: DBDictionary

Set the given value as a parameters to the statement. The column type will come from Types.

Overrides:

setNull in class DBDictionary

java.sql.SQLException

getClobString

public java.lang.String getClobString(java.sql.ResultSet rs,
                                      int column)
                               throws java.sql.SQLException

Description copied from class: DBDictionary

Convert the specified column of the SQL ResultSet to the proper java type.

Overrides:

getClobString in class DBDictionary

java.sql.SQLException

generatePrimaryKeys

public boolean generatePrimaryKeys(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group,
                                   java.lang.String schemaName,
                                   java.lang.String tableName,
                                   java.sql.Connection conn,
                                   java.sql.DatabaseMetaData meta)
                            throws java.sql.SQLException

Description copied from class: DBDictionary

By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema. If this method is implemented, it will be used instead. Return true if this method is implemented. Returns false by default.

Overrides:

generatePrimaryKeys in class DBDictionary

Parameters:

group - the schema group to add primary keys to

schemaName - the name pattern of the schema(s) to generate, or null for all schemas

tableName - the name pattern of the table(s) to generate, or null for all tables

java.sql.SQLException

generateIndexes

public boolean generateIndexes(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group,
                               java.lang.String schemaName,
                               java.lang.String tableName,
                               java.sql.Connection conn,
                               java.sql.DatabaseMetaData meta)
                        throws java.sql.SQLException

Description copied from class: DBDictionary

By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema. If this method is implemented, it will be used instead. Return true if this method is implemented. Returns false by default.

Overrides:

generateIndexes in class DBDictionary

Parameters:

group - the schema group to add indexes to

schemaName - the name pattern of the schema(s) to generate, or null for all schemas

tableName - the name pattern of the table(s) to generate, or null for all tables

java.sql.SQLException

generateForeignKeys

public boolean generateForeignKeys(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaGroup group,
                                   java.lang.String schemaName,
                                   java.lang.String tableName,
                                   java.sql.Connection conn,
                                   java.sql.DatabaseMetaData meta)
                            throws java.sql.SQLException

Description copied from class: DBDictionary

By default, the SchemaGenerator uses JDBC database metadata to reflect on the schema. If this method is implemented, it will be used instead. Return true if this method is implemented. Returns false by default.

Overrides:

generateForeignKeys in class DBDictionary

Parameters:

group - the schema group to add foreign keys to

schemaName - the name pattern of the schema(s) to generate, or null for all schemas

tableName - the name pattern of the table(s) to generate, or null for all tables

java.sql.SQLException

replaceMapping

public com.solarmetric.rd.kodo.impl.jdbc.meta.FieldMapping replaceMapping(com.solarmetric.rd.kodo.impl.jdbc.meta.FieldMapping mapping)

Description copied from class: DBDictionary

Replace the given mapping with one suited to this database, or return the original if no replacement is needed. Returns the original by default.

Overrides:

replaceMapping in class DBDictionary

replaceMappingFactory

public com.solarmetric.rd.kodo.impl.jdbc.meta.MappingFactory replaceMappingFactory(com.solarmetric.rd.kodo.impl.jdbc.meta.MappingFactory factory)

Description copied from class: DBDictionary

Replace the given factory with one suited to this database, or return the original if no replacement is needed. Returns the original by default.

Overrides:

replaceMappingFactory in class DBDictionary

replaceSchemaFactory

public com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaFactory replaceSchemaFactory(com.solarmetric.rd.kodo.impl.jdbc.schema.SchemaFactory factory)

Description copied from class: DBDictionary

Replace the given factory with one suited to this database, or return the original if no replacement is needed. Returns the original by default.

Overrides:

replaceSchemaFactory in class DBDictionary