Package nz.co.gregs.dbvolution.databases

Class Oracle11XEDB

java.lang.Object

nz.co.gregs.dbvolution.databases.DBDatabaseImplementation

nz.co.gregs.dbvolution.databases.OracleDB

nz.co.gregs.dbvolution.databases.Oracle11XEDB

All Implemented Interfaces:

Serializable, AutoCloseable, Cloneable, DBDatabase, SupportsPolygonDatatype

public class Oracle11XEDB
extends OracleDB

Implements support for version 11 and prior of the Oracle database.

Author:

Gregory Graham

See Also:

OracleDB, Oracle12DB, OracleDBDefinition, Oracle11XEDBDefinition, Oracle12DBDefinition, Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class nz.co.gregs.dbvolution.databases.DBDatabaseImplementation

DBDatabaseImplementation.ResponseToException, DBDatabaseImplementation.RunRegularProcessors

Field Summary

Fields

Modifier and Type	Field	Description
static long	serialVersionUID

Fields inherited from class nz.co.gregs.dbvolution.databases.DBDatabaseImplementation

storedConnection

Fields inherited from class nz.co.gregs.dbvolution.databases.OracleDB

DEFAULT_PORT, ORACLE_JDBC_DRIVER

Constructor Summary

Constructors

Constructor	Description
Oracle11XEDB(String host, int port, String serviceName, String username, String password)	Deprecated.
Oracle11XEDB(String jdbcURL, String username, String password)	Creates a DBDatabase instance tweaked for Oracle 11.
Oracle11XEDB(String driverName, String jdbcURL, String username, String password)	Deprecated.
Oracle11XEDB(DataSource dataSource)	Creates a DBDatabase instance tweaked for Oracle 11 and above.
Oracle11XEDB(DatabaseConnectionSettings dcs)	Creates an Oracle connection for the DatabaseConnectionSettings.
Oracle11XEDB(Oracle11XEDBDefinition defn, DatabaseConnectionSettings dcs)	Creates an Oracle connection for the DatabaseConnectionSettings.
Oracle11XEDB(OracleDBDefinition definition, String driverName, String jdbcURL, String username, String password)	Deprecated.
Oracle11XEDB(Oracle11XESettingsBuilder dcs)	Creates an Oracle connection for the DatabaseConnectionSettings.

Method Summary

Modifier and Type	Method	Description
void	addDatabaseSpecificFeatures(Statement statement)	Used By Subclasses To Inject Datatypes, Functions, Etc Into the Database.
DBDatabase	clone()	Clones the DBDatabase.
Oracle11XESettingsBuilder	getURLInterpreter()

Methods inherited from interface nz.co.gregs.dbvolution.databases.DBDatabase

getCount, getDBMigration, getRows, print, test

Methods inherited from class nz.co.gregs.dbvolution.databases.DBDatabaseImplementation

addRegularProcess, backupToDBDatabase, batchSQLStatementsWhenPossible, checkMetaDataForTable, checkTableExistsViaQuery, close, commitTransaction, copy, createForeignKeyConstraints, createIndexesOnAllFields, createOrUpdateTable, createTable, createTable, createTableNoExceptions, createTableNoExceptions, createTablesNoExceptions, createTablesNoExceptions, createTablesWithForeignKeysNoExceptions, createTableWithForeignKeys, delete, delete, deleteAllRowsFromTable, discardConnection, doReadOnlyTransaction, doTransaction, doTransaction, doTransactionWithoutCompleting, dropDatabase, dropDatabase, dropTable, dropTableIfExists, dropTableNoExceptions, equals, executeDBAction, executeDBQuery, get, get, get, get, get, getAllRows, getBaseDBDatabaseClass, getBatchSQLStatementsWhenPossible, getByExample, getByExample, getByExamples, getConnection, getConnectionFromDriverManager, getCount, getCurrentInstant, getCurrentLocalDatetime, getDatabaseInstance, getDatabaseName, getDatabaseSpecificDBConnection, getDataSource, getDBDatabaseMetaData, getDBQuery, getDBQuery, getDBQuery, getDBQuery, getDBQueryInsert, getDBRecursiveQuery, getDBStatement, getDBTable, getDBTransactionStatement, getDefinition, getDriverName, getExtras, getHost, getJdbcURL, getLabel, getLastException, getLowLevelStatement, getPassword, getPort, getPreventAccidentalDroppingOfDatabases, getPreventAccidentalDroppingOfTables, getPrintSQLBeforeExecuting, getQuietExceptionsPreference, getRegularProcessors, getRegularThreadPool, getSchema, getSettings, getSettingsFromJDBCURL, getSQLForDBQuery, getUrlFromSettings, getUsername, handleErrorDuringExecutingSQL, hasCreatedRequiredTables, hashCode, implement, initDatabase, insert, insert, insert, insertOrUpdate, insertOrUpdate, isDBDatabaseCluster, isMemoryDatabase, isPrintSQLBeforeExecuting, preventAccidentalDDLDuringTransaction, preventAccidentalDeletingAllRowsFromTable, preventAccidentalDroppingOfDatabases, preventAccidentalDroppingOfTables, preventDroppingOfDatabases, preventDroppingOfTables, printSQLIfRequested, printSQLIfRequested, removeForeignKeyConstraints, removeRegularProcess, requiredToProduceEmptyStringForNull, rollbackTransaction, save, save, save, setBatchSQLStatementsWhenPossible, setDatabaseName, setDefinition, setDefinitionBasedOnConnectionMetaData, setDriverName, setHasCreatedRequiredTables, setJdbcURL, setLabel, setLastException, setPassword, setPreventAccidentalDeletingAllRowsFromTable, setPrintSQLBeforeExecuting, setQuietExceptionsPreference, setSettings, setUsername, startServerIfRequired, stop, supportsDifferenceBetweenNullAndEmptyString, supportsGeometryTypesFullyInSchema, supportsMicrosecondPrecision, supportsNanosecondPrecision, supportsPolygonDatatype, supportsPooledConnections, tableExists, tableExists, toString, unusedConnection, update, update, updateTableToMatchDBRow, willCreateBlankQuery

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from class nz.co.gregs.dbvolution.databases.OracleDB

addFeatureToFixException, getDefaultPort

Field Detail

serialVersionUID

public static final long serialVersionUID

See Also:

Constant Field Values

Constructor Detail

Oracle11XEDB

public Oracle11XEDB(DataSource dataSource)
             throws SQLException

Creates a DBDatabase instance tweaked for Oracle 11 and above.

Parameters:

dataSource - a datasource to an Oracle database

Throws:

SQLException - database errors

Oracle11XEDB

public Oracle11XEDB(DatabaseConnectionSettings dcs)
             throws SQLException

Creates an Oracle connection for the DatabaseConnectionSettings.

Parameters:

dcs - dcs

Throws:

SQLException - database errors

Oracle11XEDB

public Oracle11XEDB(Oracle11XESettingsBuilder dcs)
             throws SQLException

Creates an Oracle connection for the DatabaseConnectionSettings.

Parameters:

dcs - dcs

Throws:

SQLException - database errors

Oracle11XEDB

public Oracle11XEDB(Oracle11XEDBDefinition defn,
                    DatabaseConnectionSettings dcs)
             throws SQLException

Creates an Oracle connection for the DatabaseConnectionSettings.

Parameters:

dcs - dcs

defn - the oracle database definition

Throws:

SQLException - database errors

Oracle11XEDB

@Deprecated
public Oracle11XEDB(OracleDBDefinition definition,
                    String driverName,
                    String jdbcURL,
                    String username,
                    String password)
             throws SQLException

Deprecated.

Creates a DBDatabase instance tweaked for Oracle 11.

Parameters:

definition - definition

jdbcURL - jdbcURL

driverName - driverName

password - password

username - the database account's username

Throws:

SQLException - database errors

Oracle11XEDB

@Deprecated
public Oracle11XEDB(String driverName,
                    String jdbcURL,
                    String username,
                    String password)
             throws SQLException

Deprecated.

Creates a DBDatabase instance tweaked for Oracle 11.

Parameters:

driverName - driverName

jdbcURL - jdbcURL

username - username

password - password

Throws:

SQLException - database errors

Oracle11XEDB

public Oracle11XEDB(String jdbcURL,
                    String username,
                    String password)
             throws SQLException

Creates a DBDatabase instance tweaked for Oracle 11.

Parameters:

jdbcURL - jdbcURL

username - username

password - password

Throws:

SQLException - database errors

Oracle11XEDB

@Deprecated
public Oracle11XEDB(String host,
                    int port,
                    String serviceName,
                    String username,
                    String password)
             throws SQLException

Deprecated.

Creates a DBDatabase instance tweaked for Oracle 11.

Parameters:

host - host

port - port

serviceName - serviceName

password - password

username - username

Throws:

SQLException - database errors

Method Detail

clone

public DBDatabase clone()
                 throws CloneNotSupportedException

Description copied from class: DBDatabaseImplementation

Clones the DBDatabase.

Specified by:

clone in interface DBDatabase

Overrides:

clone in class OracleDB

Returns:

a clone of the DBDatabase.

Throws:

CloneNotSupportedException - not likely

addDatabaseSpecificFeatures

public void addDatabaseSpecificFeatures(Statement statement)
                                 throws ExceptionDuringDatabaseFeatureSetup

Description copied from interface: DBDatabase

Used By Subclasses To Inject Datatypes, Functions, Etc Into the Database.

Specified by:

addDatabaseSpecificFeatures in interface DBDatabase

Overrides:

addDatabaseSpecificFeatures in class OracleDB

Parameters:

statement - the statement to use when adding features, DO NOT CLOSE THIS STATEMENT.

Throws:

ExceptionDuringDatabaseFeatureSetup - database exceptions may occur

See Also:

PostgresDB, H2DB, SQLiteDB, OracleDB, MSSQLServerDB, MySQLDB

getURLInterpreter

public Oracle11XESettingsBuilder getURLInterpreter()