public interface OracleDatabase extends Database
Modifier and Type | Field and Description |
---|---|
static int |
DOMAIN_ALL |
static int |
DOMAIN_ARGUMENT |
static int |
DOMAIN_COLUMN |
static int |
DOMAIN_VARIABLE |
static int |
LAST_ORACLE_TYPE
The latest oracle type supported by the api.
|
static java.lang.String |
NESTED_TABLE_PROPERTY
Property name for nested tables.
|
static java.lang.String |
OBJECT_TABLE_PROPERTY
Property name for Object Tables.
|
static int |
OLITE_10GR3_TYPE
Deprecated.
moved to
OracleDatabaseLite |
static int |
OLITE_TYPE
Deprecated.
moved to
OracleDatabaseLite |
static java.lang.String |
ORA_BFILE |
static java.lang.String |
ORA_BINARY_DOUBLE |
static java.lang.String |
ORA_BINARY_FLOAT |
static java.lang.String |
ORA_BLOB |
static java.lang.String |
ORA_CHAR |
static java.lang.String |
ORA_CHAR_VARYING |
static java.lang.String |
ORA_CHARACTER |
static java.lang.String |
ORA_CHARACTER_VARYING |
static java.lang.String |
ORA_CLOB |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_TIME_ZONE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_UNIT |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_BYTE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_CHAR |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_LOCAL_TIME_ZONE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_TIME_ZONE |
static java.lang.String |
ORA_DATE |
static java.lang.String |
ORA_DEC |
static java.lang.String |
ORA_DECIMAL |
static java.lang.String |
ORA_DOUBLE_PRECISION |
static java.lang.String |
ORA_FLOAT |
static java.lang.String |
ORA_INT |
static java.lang.String |
ORA_INTEGER |
static java.lang.String |
ORA_INTERVAL_DAY |
static java.lang.String |
ORA_INTERVAL_YEAR |
static java.lang.String |
ORA_LONG |
static java.lang.String |
ORA_LONG_RAW |
static java.lang.String |
ORA_LONG_VARCHAR |
static java.lang.String |
ORA_NATIONAL_CHAR |
static java.lang.String |
ORA_NATIONAL_CHAR_VARYING |
static java.lang.String |
ORA_NATIONAL_CHARACTER |
static java.lang.String |
ORA_NATIONAL_CHARACTER_VARYING |
static java.lang.String |
ORA_NCHAR |
static java.lang.String |
ORA_NCHAR_VARYING |
static java.lang.String |
ORA_NCLOB |
static java.lang.String |
ORA_NUMBER |
static java.lang.String |
ORA_NUMERIC |
static java.lang.String |
ORA_NVARCHAR2 |
static java.lang.String |
ORA_RAW |
static java.lang.String |
ORA_REAL |
static java.lang.String |
ORA_ROWID |
static java.lang.String |
ORA_SMALLINT |
static java.lang.String |
ORA_TIMESTAMP |
static java.lang.String |
ORA_UROWID |
static java.lang.String |
ORA_VARCHAR |
static java.lang.String |
ORA_VARCHAR2 |
static java.lang.String |
ORA_XMLTYPE |
static java.lang.String |
ORACLE_DATABASE_TYPE
The type string for Oracle databases.
|
static java.lang.String |
ORACLE_LITE_DATABASE_TYPE
Deprecated.
moved to
OracleDatabaseLite |
static int |
ORACLE_TYPE |
static int |
ORACLE10g_TYPE
The type for Oracle 10g R1.
|
static int |
ORACLE10gR2_TYPE
The type for Oracle 10g R2.
|
static int |
ORACLE10gR2XE_TYPE
The type for Oracle 10g R2 eXpress Edition.
|
static int |
ORACLE11g_TYPE
The type for Oracle 11g R1.
|
static int |
ORACLE11gR2_TYPE
The type for Oracle 11g R2.
|
static int |
ORACLE11gR2XE_TYPE
The type for Oracle 11g R2 eXpress Edition.
|
static int |
ORACLE12c_TYPE
The type for Oracle 12c.
|
static int |
ORACLE12cR102_TYPE
The type for Oracle 12c Release 1 (12.1.0.2).
|
static int |
ORACLE8_TYPE |
static int |
ORACLE8i_TYPE |
static int |
ORACLE9i_TYPE |
static int |
ORACLE9iR2_TYPE |
static java.lang.String |
PARTITIONED_TABLE_PROPERTY
Property name for Partitioned Tables.
|
static java.lang.String |
PASSWORD |
static java.lang.String |
PUBLIC
Name of the PUBLIC schema in Oracle Databases that "owns" PUBLIC
synonyms and database links.
|
static java.lang.String |
TABLE_COMPRESS_KEY
Deprecated.
Compression is now stored in an OracleTableProperties object in
the Table property map (as tableCompression), keyed by
OracleTableProperties.KEY
|
static java.lang.String |
TABLE_PARALLEL_KEY
Deprecated.
ParallelDegree is now stored in an OracleTableProperties object in
the Table property map, keyed by OracleTableProperties.KEY
|
static int |
UNKNOWN_TYPE |
static java.lang.String |
USER_PRIVS
Property name for user privileges.
|
static java.lang.String |
USER_ROLES
Property name for user roles.
|
FOUR_GIG, GENERIC_JDBC_DATABASE, PROVIDER_TYPE, SOURCE_TYPE_BODY, SOURCE_TYPE_SPEC, TWO_GIG
CREATE_PRIVILEDGE, DELETE_PRIVILEDGE, MODIFY_PRIVILEDGE, NEW_FROM_TEMPLATE_TYPE
Modifier and Type | Method and Description |
---|---|
void |
alterSessionParameterValue(java.lang.String parameter,
java.lang.String value)
Changes the value of given session parameter using
ALTER SESION SET parameter = value . |
Database |
createStandaloneDatabase(Schema schema)
Creates a standalone Database instance that connects to the database
with the same connection details as this instance, but will have the
given current/default schema.
|
java.lang.String |
getCompatibleLevel()
Gets the level (version) that the Database is compatible with.
|
java.util.List<oracle.javatools.db.compilation.CompilationResults> |
getCompilationResults(java.util.List<PlSqlIdentifier> plsqlIds)
Returns a List of
CompilationResults for PL/SQL objects defined by
the List of PlSqlIdentifier s. |
int |
getDatabaseVersion()
Returns the type of Oracle database for this provider.
|
MultitenantContainerInfo |
getMultitenantContainerInfo()
Tests whether this is a mutlitenant database, and if it is returns
information about the connected container - e.g.
|
int |
getOracleDatabaseType()
Deprecated.
|
java.util.Map<java.lang.String,java.lang.String> |
getSessionParameterQueries()
Gets the Map of queries used to build the Session Parameters cache.
|
java.lang.String |
getSessionParameterValue(java.lang.String parameter)
Returns the value of given parameter from the Session Parameters cache.
|
boolean |
isDatabaseChangeNotificationCompatible(java.lang.String sql,
boolean qrcn,
boolean bestEffort)
Tests whether the given sql is compatible with the Oracle JDBC driver's
Database Change Notification (DCN) feature.
|
java.lang.String[] |
listTablespaces()
Deprecated.
listObjects now supports Tablespaces and Schemas
|
void |
markSessionParametersDirty()
Allows the Session Paramters cache to be marked as dirty so that the
next time a value is requested, the cache will be requeried from the database.
|
oracle.javatools.db.compilation.CompilationResults |
submitDatabaseSource(java.lang.String schemaName,
java.lang.String source)
Convenience method for submitting a single source.
|
java.util.List<oracle.javatools.db.compilation.CompilationResults> |
submitDatabaseSources(java.lang.String schemaName,
java.util.List<java.lang.String> sources)
Submits a List of plsql sources to the database to be compiled in the
current schema (or the given schemaName if not null).
|
boolean |
supportsDatabaseChangeNotification()
Tests whether this OracleDatabase supports the Oracle JDBC "Database
Change Notification" (DCN) feature.
|
boolean |
supportsJava()
Returns true if this Oracle version supports java in the database.
|
boolean |
supportsPartitioning()
Returns true if this Oracle instance supports partitioning of tables.
|
canRestrictSchemaList, close, exists, getConnection, getConnection, getConnectionName, getConnectionStore, getDatabaseSource, getDatabaseSource, getDatabaseType, getIdentifierQuoteString, getQualifiedName, getUserName, hasTransaction, isConnectionAlive, isConnectionAlive, isConnectionClosed, isObjectValid, supportsDebugging, testSQLStatement
addObjectListener, addObjectListener, addObjectListener, addProviderListener, addProviderListener, canCreate, canDelete, canUpdate, commitTransaction, createObject, createObjects, createSchema, deleteObject, deleteObjects, deleteSchema, getCascadeManager, getDataType, getDDLGenerator, getDefaultSchema, getDefaultTemplateForType, getDescription, getDescriptor, getDiffEngine, getExternalName, getExternalName, getInternalName, getInternalName, getName, getObject, getObject, getObjectFactory, getOrCreateDataType, getPropertyManager, getProviderIdentifier, getProviderType, getSchema, getTimestamp, getTimestamp, getUniqueName, getUniqueName, hasObjectPrivilege, hasPriviledge, hasSystemPrivilege, isEditable, isNewFromTemplateType, isValidName, isValidName, listObjects, listObjects, listObjects, listObjects, listObjects, listObjectTypes, listSchemas, listSchemas, listSupportedDataTypes, quoteIdentifier, removeObjectListener, removeProviderListener, removeProviderListener, setDefaultTemplateForType, supportsObjectType, supportsTimestamps, undeleteObject, undeleteObjects, updateObject, updateObjects, updateObjects, updateSchema, validateName, validateName, validateObject, validateObject, validateObject, validateObject, validateObjectProperty, validateObjectProperty, validateObjectProperty, validateObjectProperty, validateSchema, validateSchema, validateUniqueName, validateUniqueName
static final java.lang.String ORACLE_DATABASE_TYPE
Database.getDatabaseType()
,
Constant Field Values@Deprecated static final java.lang.String ORACLE_LITE_DATABASE_TYPE
OracleDatabaseLite
static final java.lang.String OBJECT_TABLE_PROPERTY
getProperty
on a Table
with this String for the property name will return
Boolean.TRUE
if and only if the Table is an Object Table.static final java.lang.String NESTED_TABLE_PROPERTY
getProperty
on a table
with this String for the property name will return
Boolean.TRUE
if and only if the table is a nested table.static final java.lang.String PARTITIONED_TABLE_PROPERTY
getProperty
on a Table
with this String for the property name will return
Boolean.TRUE
if and only if the Table is a Partitioned Table.@Deprecated static final java.lang.String TABLE_COMPRESS_KEY
@Deprecated static final java.lang.String TABLE_PARALLEL_KEY
static final java.lang.String USER_PRIVS
getProperty
on a Schema
with this String for the property name will return
a Set
containing the privileges granted to that
Schema.static final java.lang.String USER_ROLES
getProperty
on a Schema
with this String for the property name will return
a Set
containing the privileges granted to that
Schema.static final java.lang.String PASSWORD
static final java.lang.String PUBLIC
static final int UNKNOWN_TYPE
@Deprecated static final int OLITE_TYPE
OracleDatabaseLite
@Deprecated static final int OLITE_10GR3_TYPE
OracleDatabaseLite
static final int ORACLE_TYPE
static final int ORACLE8_TYPE
static final int ORACLE8i_TYPE
static final int ORACLE9i_TYPE
static final int ORACLE9iR2_TYPE
static final int ORACLE10g_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE10gR2XE_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE10gR2_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE11g_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE11gR2XE_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE11gR2_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE12c_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int ORACLE12cR102_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int LAST_ORACLE_TYPE
getDatabaseVersion()
,
Constant Field Valuesstatic final int DOMAIN_ALL
static final int DOMAIN_COLUMN
static final int DOMAIN_VARIABLE
static final int DOMAIN_ARGUMENT
static final java.lang.String ORA_BLOB
static final java.lang.String ORA_BFILE
static final java.lang.String ORA_BINARY_DOUBLE
static final java.lang.String ORA_BINARY_FLOAT
static final java.lang.String ORA_CHAR
static final java.lang.String ORA_CHAR_VARYING
static final java.lang.String ORA_CHARACTER
static final java.lang.String ORA_CHARACTER_VARYING
static final java.lang.String ORA_CLOB
static final java.lang.String ORA_DATE
static final java.lang.String ORA_DEC
static final java.lang.String ORA_DECIMAL
static final java.lang.String ORA_DOUBLE_PRECISION
static final java.lang.String ORA_FLOAT
static final java.lang.String ORA_INT
static final java.lang.String ORA_INTEGER
static final java.lang.String ORA_INTERVAL_DAY
static final java.lang.String ORA_INTERVAL_YEAR
static final java.lang.String ORA_LONG
static final java.lang.String ORA_LONG_RAW
static final java.lang.String ORA_LONG_VARCHAR
static final java.lang.String ORA_NATIONAL_CHAR
static final java.lang.String ORA_NATIONAL_CHAR_VARYING
static final java.lang.String ORA_NATIONAL_CHARACTER
static final java.lang.String ORA_NATIONAL_CHARACTER_VARYING
static final java.lang.String ORA_NCHAR
static final java.lang.String ORA_NCHAR_VARYING
static final java.lang.String ORA_NCLOB
static final java.lang.String ORA_NUMBER
static final java.lang.String ORA_NUMERIC
static final java.lang.String ORA_NVARCHAR2
static final java.lang.String ORA_RAW
static final java.lang.String ORA_REAL
static final java.lang.String ORA_ROWID
static final java.lang.String ORA_SMALLINT
static final java.lang.String ORA_TIMESTAMP
static final java.lang.String ORA_UROWID
static final java.lang.String ORA_VARCHAR
static final java.lang.String ORA_VARCHAR2
static final java.lang.String ORA_XMLTYPE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_LOCAL_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_UNIT
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_CHAR
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_BYTE
@Deprecated int getOracleDatabaseType()
getDatabaseVersion()
int getDatabaseVersion()
getDatabaseVersion
in interface Database
ORACLE11g_TYPE
,
ORACLE10gR2_TYPE
,
ORACLE10g_TYPE
@Deprecated java.lang.String[] listTablespaces()
boolean supportsJava()
boolean supportsPartitioning()
java.lang.String getCompatibleLevel()
COMPATIBLE
initialization parameter.Version
java.lang.String getSessionParameterValue(java.lang.String parameter)
getSessionParameterQueries()
.void alterSessionParameterValue(java.lang.String parameter, java.lang.String value) throws DBException
ALTER SESION SET parameter = value
. parameter
- value
- DBException
- if the set failsvoid markSessionParametersDirty()
alterSessionParameterValue(java.lang.String, java.lang.String)
as its value cannot be changed with
ALTER SESSION for example.java.util.Map<java.lang.String,java.lang.String> getSessionParameterQueries()
markSessionParametersDirty()
).java.util.List<oracle.javatools.db.compilation.CompilationResults> submitDatabaseSources(java.lang.String schemaName, java.util.List<java.lang.String> sources)
If the submit of the sources for compilation fails for any reason (including cancellation) then CompilationResults.isSubmitFailed will return true.
CompilationResults
.oracle.javatools.db.compilation.CompilationResults submitDatabaseSource(java.lang.String schemaName, java.lang.String source)
submitDatabaseSources(java.lang.String, java.util.List<java.lang.String>)
for details.java.util.List<oracle.javatools.db.compilation.CompilationResults> getCompilationResults(java.util.List<PlSqlIdentifier> plsqlIds)
CompilationResults
for PL/SQL objects defined by
the List of PlSqlIdentifier
s.boolean supportsDatabaseChangeNotification()
boolean isDatabaseChangeNotificationCompatible(java.lang.String sql, boolean qrcn, boolean bestEffort) throws DBException
sql
- the sql to testqrcn
- if true, the sql is tested for compatability with
"Query Result Change Notification" (QRCN), if false
"Object Chang Notification" (OCN).bestEffort
- if true uses "Best Effort" mode for QRCN rather than
"Guaranteed" mode.DBException
- if the sql is not valid, DCN is not supported, or
a connection problem is encountered.supportsDatabaseChangeNotification()
MultitenantContainerInfo getMultitenantContainerInfo()
Database createStandaloneDatabase(Schema schema) throws DBException
The returned Database must be managed by the caller (i.e. closed when finished with) to ensure that the underyling Connection is cleaned up.
schema
- the current/default schema for the new standalone
databaseDBException
- if a new Connection is attempted, but fails