org.kepler.util.sql

Class Oracle

java.lang.Object

org.kepler.util.sql.DatabaseType

org.kepler.util.sql.Oracle

public class Oracle
extends DatabaseType

An implementation of DatabaseType for Oracle.

Author:

Daniel Crawl

Field Summary

Fields inherited from class org.kepler.util.sql.DatabaseType

_connection, _createIndexes, VERSION_TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	Oracle() Only this package (DatabaseFactory) can instantiate.

Method Summary

Modifier and Type	Method and Description
protected boolean	_areForeignKeysIndexed() Returns true if foreign keys are automatically indexed.
protected boolean	_arePrimaryKeysIndexed() Returns true if primary keys are automatically indexed.
protected java.lang.String	_getDriverName() Get the driver class name.
protected java.lang.String	_getJDBCUrl(java.lang.String hostName, java.lang.String port, java.lang.String databaseName) Get a JDBC URL.
protected java.lang.String	_getTypeString(Column column) Get the SQL string of a column type.
protected boolean	_hasGeneratedKeys() Returns true if database supports auto-generated keys in its prepared statements.
protected boolean	_isIdentifierTooLong(java.lang.String identifier) Returns true if identifier is too long.
protected boolean	_needCapitalColumnNames() Returns true if column names should be capitalized.
protected boolean	_needCapitalTableNames() Returns true if table names should be capitalized.
protected boolean	_needSequencesForAutoInc() Returns true if need to use sequences for autoincrement columns.
java.lang.String	getColumnName(java.lang.String columnName) Adjust the name of a column.
java.lang.String	getDefaultTimeStr() Get a string representing the default time.
java.lang.String	getName() Get the name of the type.
void	renameColumn(java.lang.String oldName, Column newColumn, java.lang.String tableName) Rename a column.
void	setColumnNotNull(Column column, java.lang.String tableName) Set not null constraint to a column.
void	setColumnNull(Column column, java.lang.String tableName) Change a column to allow null values.

Methods inherited from class org.kepler.util.sql.DatabaseType

_combineHostAndPort, _connectInitialize, _executeSQL, _getConnection, _getConnection, _getCreateTableSuffix, _getPort, _hasCatalog, _isAutoIncResultReferencedByName, _isTableCached, _needIdentityForAutoInc, addMinorVersion, changeColumnType, commit, connect, copyColumn, createColumn, createColumn, createColumn, createIndex, createIndex, createTables, createTables, createVersionTable, deleteColumn, disconnect, getColumnAlterStr, getColumnDefinition, getColumnDefinition, getColumnNames, getColumnSize, getConnection, getFalseValue, getMajorVersion, getMinorVersion, getPrepStatement, getPrimaryFileExtension, getSQLDelete, getSQLInsert, getSQLInsert, getSQLSelect, getSQLSelect, getSQLUpdate, getStatement, getTableName, getTrueValue, getVersionString, hasNewerSchema, hasOlderSchema, insert, needAbsolutePathForName, needHostForConnect, needPasswordForConnect, needUserForConnect, procedureExists, rollback, setAutoCommit, tableExists, tableExists, updateMinorVersion

Methods inherited from class java.lang.Object

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

Constructor Detail

Oracle

protected Oracle()

Only this package (DatabaseFactory) can instantiate.

Method Detail

getColumnName

public java.lang.String getColumnName(java.lang.String columnName)

Adjust the name of a column.

Overrides:

getColumnName in class DatabaseType

getDefaultTimeStr

public java.lang.String getDefaultTimeStr()

Get a string representing the default time.

Overrides:

getDefaultTimeStr in class DatabaseType

getName

public java.lang.String getName()

Get the name of the type.

Specified by:

getName in class DatabaseType

renameColumn

public void renameColumn(java.lang.String oldName,
                         Column newColumn,
                         java.lang.String tableName)
                  throws java.sql.SQLException

Rename a column.

Specified by:

renameColumn in class DatabaseType

Throws:

java.sql.SQLException

setColumnNull

public void setColumnNull(Column column,
                          java.lang.String tableName)
                   throws java.sql.SQLException

Change a column to allow null values.

Specified by:

setColumnNull in class DatabaseType

Throws:

java.sql.SQLException

setColumnNotNull

public void setColumnNotNull(Column column,
                             java.lang.String tableName)
                      throws java.sql.SQLException

Set not null constraint to a column.

Specified by:

setColumnNotNull in class DatabaseType

Throws:

java.sql.SQLException

_areForeignKeysIndexed

protected boolean _areForeignKeysIndexed()

Returns true if foreign keys are automatically indexed.

Overrides:

_areForeignKeysIndexed in class DatabaseType

_arePrimaryKeysIndexed

protected boolean _arePrimaryKeysIndexed()

Returns true if primary keys are automatically indexed.

Overrides:

_arePrimaryKeysIndexed in class DatabaseType

_getDriverName

protected java.lang.String _getDriverName()

Get the driver class name.

Specified by:

_getDriverName in class DatabaseType

_getJDBCUrl

protected java.lang.String _getJDBCUrl(java.lang.String hostName,
                                       java.lang.String port,
                                       java.lang.String databaseName)
                                throws java.sql.SQLException

Get a JDBC URL.

Specified by:

_getJDBCUrl in class DatabaseType

Throws:

java.sql.SQLException

_getTypeString

protected java.lang.String _getTypeString(Column column)

Get the SQL string of a column type.

Specified by:

_getTypeString in class DatabaseType

_hasGeneratedKeys

protected boolean _hasGeneratedKeys()

Returns true if database supports auto-generated keys in its prepared statements.

Specified by:

_hasGeneratedKeys in class DatabaseType

_isIdentifierTooLong

protected boolean _isIdentifierTooLong(java.lang.String identifier)

Returns true if identifier is too long.

Overrides:

_isIdentifierTooLong in class DatabaseType

_needCapitalColumnNames

protected boolean _needCapitalColumnNames()

Returns true if column names should be capitalized.

Overrides:

_needCapitalColumnNames in class DatabaseType

_needCapitalTableNames

protected boolean _needCapitalTableNames()

Returns true if table names should be capitalized.

Overrides:

_needCapitalTableNames in class DatabaseType

_needSequencesForAutoInc

protected boolean _needSequencesForAutoInc()

Returns true if need to use sequences for autoincrement columns.

Overrides:

_needSequencesForAutoInc in class DatabaseType