public interface JdbcDatabase extends Database
Database
interface for JDBC Databases. The JdbcDatabase
class provides support for generic JDBC databases; its implementations use the JDBC metadata layer to list and build object definitions, rather than querying the dictionary directly (DictionaryDatabase
).
This used to be a class - that implementation is now oracle.javatools.db.JdbcDatabaseImpl
Modifier and Type | Field and Description |
---|---|
static DataType |
ANSI_BIGINT |
static DataType |
ANSI_BINARY_LARGE_OBJECT
BINARY LARGE OBJECT STRING TYPES <binary_large_object_string_type> The length is specified as : <unsigned_integer> [<multiplier>] [CHARACTERS | OCTETS] | <large_object_token_length> [CHARACTERS | OCTETS]
|
static DataType |
ANSI_BIT |
static DataType |
ANSI_BIT_VARYING |
static DataType |
ANSI_BLOB |
static DataType |
ANSI_BOOLEAN
BOOLEAN TYPE <boolean_type>
|
static DataType |
ANSI_CHAR |
static DataType |
ANSI_CHAR_LARGE_OBJECT |
static DataType |
ANSI_CHAR_VARYING |
static DataType |
ANSI_CHARACTER |
static DataType |
ANSI_CHARACTER_LARGE_OBJECT |
static DataType |
ANSI_CHARACTER_VARYING |
static DataType |
ANSI_CLOB |
static DataType |
ANSI_DATE
DATETIME TYPES <datetime_type>
|
static DataType |
ANSI_DEC |
static DataType |
ANSI_DECIMAL |
static DataType |
ANSI_DOUBLE_PRECISION |
static DataType |
ANSI_FLOAT |
static DataType |
ANSI_INT |
static DataType |
ANSI_INTEGER |
static DataType |
ANSI_INTERVAL
INTERVAL TYPE <interval_type>
|
static DataType |
ANSI_NATIONAL_CHAR |
static DataType |
ANSI_NATIONAL_CHAR_VARYING |
static DataType |
ANSI_NATIONAL_CHARACTER |
static DataType |
ANSI_NATIONAL_CHARACTER_LARGE_OBJECT |
static DataType |
ANSI_NATIONAL_CHARACTER_VARYING |
static DataType |
ANSI_NCHAR
NATIONAL CHARACTER STRING TYPES <national_character_string_type> The length, where specified, can be followed by the word CHARACTERS or OCTETS.
|
static DataType |
ANSI_NCHAR_LARGE_OBJECT |
static DataType |
ANSI_NCHAR_VARYING |
static DataType |
ANSI_NCLOB |
static DataType |
ANSI_NUMERIC |
static DataType |
ANSI_NVARCHAR |
static DataType |
ANSI_REAL |
static DataType |
ANSI_REF
REFERENCE TYPE <reference_type> REF ( <path_resolved_user_defined_type_name> ) [ SCOPE <table_name> ]
|
static DataType |
ANSI_ROW
ROW TYPE <row_type> ROW ( <field_definition> [{, <field_definition>}] )
|
static DataType |
ANSI_SMALLINT |
static DataType |
ANSI_TIME |
static DataType |
ANSI_TIME_WITH_TIME_ZONE |
static DataType |
ANSI_TIME_WITHOUT_TIME_ZONE |
static DataType |
ANSI_TIMESTAMP |
static DataType |
ANSI_TIMESTAMP_WITH_TIME_ZONE |
static DataType |
ANSI_TIMESTAMP_WITHOUT_TIME_ZONE |
static DataType |
ANSI_VARCHAR |
static DataTypeAttribute |
DATATYPE_ATTRIBUTE_PRECISION
NUMERIC TYPES <numeric_type>
|
static DataTypeAttribute |
DATATYPE_ATTRIBUTE_SCALE |
static DataTypeAttribute[] |
DATATYPE_ATTRIBUTE_SIZE
CHARACTER STRING TYPES <character_string_type> The length, where specified, can be followed by the word CHARACTERS or OCTETS.
|
static java.lang.String |
DEFAULT_SCHEMA_KEY
Property used to mark that the schema is the default, and therefore only Schema in the database.
|
static int |
DOMAIN_ALL |
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 |
---|---|
boolean |
catalogIsSchema()
Tests whether the JDBC metadata catalog is the same as a Schema in the API.
|
java.lang.String |
getCatalog()
Gets the name of the catalog for the underlying connection to the database.
|
java.lang.String |
getNameForDriver(java.lang.String name)
Some databases (e.g.
|
boolean |
isUseSchema()
Tests whether this implementation uses Schemas - i.e.
|
java.lang.String |
normaliseDataTypeName(java.lang.String name)
Returns the name of the datatype as defined in the registry.
|
java.lang.String |
normaliseDefaultValue(DataType type, java.lang.String value)
Converts default value into a standard form.
|
canRestrictSchemaList, close, exists, getConnection, getConnection, getConnectionName, getConnectionStore, getDatabaseSource, getDatabaseSource, getDatabaseType, getDatabaseVersion, getIdentifierQuoteString, getQualifiedName, getUserName, hasTransaction, 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, getObjectManager, getOrCreateDataType, getPropertyManager, getProviderIdentifier, getProviderType, getSchema, getTimestamp, getTimestamp, 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 DEFAULT_SCHEMA_KEY
static final int DOMAIN_ALL
static final DataTypeAttribute[] DATATYPE_ATTRIBUTE_SIZE
static final DataType ANSI_CHAR
static final DataType ANSI_CHARACTER
static final DataType ANSI_CHAR_VARYING
static final DataType ANSI_CHARACTER_VARYING
static final DataType ANSI_VARCHAR
static final DataType ANSI_CHAR_LARGE_OBJECT
static final DataType ANSI_CHARACTER_LARGE_OBJECT
static final DataType ANSI_CLOB
static final DataType ANSI_BIT
static final DataType ANSI_BIT_VARYING
static final DataType ANSI_NCHAR
static final DataType ANSI_NATIONAL_CHAR
static final DataType ANSI_NATIONAL_CHARACTER
static final DataType ANSI_NVARCHAR
static final DataType ANSI_NCHAR_VARYING
static final DataType ANSI_NATIONAL_CHAR_VARYING
static final DataType ANSI_NATIONAL_CHARACTER_VARYING
static final DataType ANSI_NATIONAL_CHARACTER_LARGE_OBJECT
static final DataType ANSI_NCHAR_LARGE_OBJECT
static final DataType ANSI_NCLOB
static final DataType ANSI_BINARY_LARGE_OBJECT
static final DataType ANSI_BLOB
static final DataTypeAttribute DATATYPE_ATTRIBUTE_PRECISION
static final DataTypeAttribute DATATYPE_ATTRIBUTE_SCALE
static final DataType ANSI_NUMERIC
static final DataType ANSI_DECIMAL
static final DataType ANSI_DEC
static final DataType ANSI_INTEGER
static final DataType ANSI_INT
static final DataType ANSI_BIGINT
static final DataType ANSI_SMALLINT
static final DataType ANSI_FLOAT
static final DataType ANSI_REAL
static final DataType ANSI_DOUBLE_PRECISION
static final DataType ANSI_DATE
static final DataType ANSI_TIME
static final DataType ANSI_TIME_WITH_TIME_ZONE
static final DataType ANSI_TIME_WITHOUT_TIME_ZONE
static final DataType ANSI_TIMESTAMP
static final DataType ANSI_TIMESTAMP_WITH_TIME_ZONE
static final DataType ANSI_TIMESTAMP_WITHOUT_TIME_ZONE
static final DataType ANSI_BOOLEAN
static final DataType ANSI_INTERVAL
static final DataType ANSI_ROW
static final DataType ANSI_REF
boolean isUseSchema()
boolean catalogIsSchema()
java.lang.String getCatalog()
java.lang.String normaliseDataTypeName(java.lang.String name)
If DatabaseMetaData has included attribute information in the type string (e.g. NUMBER(0,38) ) then this does not need to be stripped out by this method.
dmdDataTypeName
- the value of the TYPE_NAME string from the DatabaseMetaData.DatabaseMetaData#getColumns
java.lang.String normaliseDefaultValue(DataType type, java.lang.String value)
dataType
-defaultValue
-java.lang.String getNameForDriver(java.lang.String name)