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 |
static DataType |
ANSI_BIT |
static DataType |
ANSI_BIT_VARYING |
static DataType |
ANSI_BLOB |
static DataType |
ANSI_BOOLEAN |
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 |
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 |
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 |
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 |
static DataType |
ANSI_ROW |
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 java.lang.String |
BIGINT |
static java.lang.String |
BINARY_LARGE_OBJECT |
static java.lang.String |
BIT |
static java.lang.String |
BIT_VARYING |
static java.lang.String |
BLOB |
static java.lang.String |
BOOLEAN |
static java.lang.String |
CHAR |
static java.lang.String |
CHAR_LARGE_OBJECT |
static java.lang.String |
CHAR_VARYING |
static java.lang.String |
CHARACTER |
static java.lang.String |
CHARACTER_LARGE_OBJECT |
static java.lang.String |
CHARACTER_VARYING |
static java.lang.String |
CLOB |
static java.lang.String |
DATE |
static java.lang.String |
DEC |
static java.lang.String |
DECIMAL |
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 |
static java.lang.String |
DOUBLE_PRECISION |
static java.lang.String |
FLOAT |
static java.lang.String |
INT |
static java.lang.String |
INTEGER |
static java.lang.String |
INTERVAL |
static java.lang.String |
NATIONAL_CHAR |
static java.lang.String |
NATIONAL_CHAR_VARYING |
static java.lang.String |
NATIONAL_CHARACTER |
static java.lang.String |
NATIONAL_CHARACTER_LARGE_OBJECT |
static java.lang.String |
NATIONAL_CHARACTER_VARYING |
static java.lang.String |
NCHAR |
static java.lang.String |
NCHAR_LARGE_OBJECT |
static java.lang.String |
NCHAR_VARYING |
static java.lang.String |
NCLOB |
static java.lang.String |
NUMERIC |
static java.lang.String |
NVARCHAR |
static java.lang.String |
REAL |
static java.lang.String |
REF |
static java.lang.String |
ROW |
static java.lang.String |
SMALLINT |
static java.lang.String |
TIME |
static java.lang.String |
TIME_WITH_TIME_ZONE |
static java.lang.String |
TIME_WITHOUT_TIME_ZONE |
static java.lang.String |
TIMESTAMP |
static java.lang.String |
TIMESTAMP_WITH_TIME_ZONE |
static java.lang.String |
TIMESTAMP_WITHOUT_TIME_ZONE |
static java.lang.String |
VARCHAR |
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, 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 java.lang.String BIGINT
static final java.lang.String BINARY_LARGE_OBJECT
static final java.lang.String BIT_VARYING
static final java.lang.String BIT
static final java.lang.String BLOB
static final java.lang.String BOOLEAN
static final java.lang.String CHAR_LARGE_OBJECT
static final java.lang.String CHAR_VARYING
static final java.lang.String CHAR
static final java.lang.String CHARACTER_LARGE_OBJECT
static final java.lang.String CHARACTER_VARYING
static final java.lang.String CHARACTER
static final java.lang.String CLOB
static final java.lang.String DATE
static final java.lang.String DEC
static final java.lang.String DECIMAL
static final java.lang.String DOUBLE_PRECISION
static final java.lang.String FLOAT
static final java.lang.String INT
static final java.lang.String INTEGER
static final java.lang.String INTERVAL
static final java.lang.String NATIONAL_CHAR_VARYING
static final java.lang.String NATIONAL_CHAR
static final java.lang.String NATIONAL_CHARACTER_LARGE_OBJECT
static final java.lang.String NATIONAL_CHARACTER_VARYING
static final java.lang.String NATIONAL_CHARACTER
static final java.lang.String NCHAR_LARGE_OBJECT
static final java.lang.String NCHAR_VARYING
static final java.lang.String NCHAR
static final java.lang.String NCLOB
static final java.lang.String NUMERIC
static final java.lang.String NVARCHAR
static final java.lang.String REAL
static final java.lang.String REF
static final java.lang.String ROW
static final java.lang.String SMALLINT
static final java.lang.String TIME_WITH_TIME_ZONE
static final java.lang.String TIME_WITHOUT_TIME_ZONE
static final java.lang.String TIME
static final java.lang.String TIMESTAMP_WITH_TIME_ZONE
static final java.lang.String TIMESTAMP_WITHOUT_TIME_ZONE
static final java.lang.String TIMESTAMP
static final java.lang.String VARCHAR
static final DataType ANSI_CHAR
static final DataType ANSI_CHARACTER
static final DataType ANSI_VARCHAR
static final DataType ANSI_CHAR_VARYING
static final DataType ANSI_CHARACTER_VARYING
static final DataType ANSI_CLOB
static final DataType ANSI_CHAR_LARGE_OBJECT
static final DataType ANSI_CHARACTER_LARGE_OBJECT
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_NCLOB
static final DataType ANSI_NATIONAL_CHARACTER_LARGE_OBJECT
static final DataType ANSI_NCHAR_LARGE_OBJECT
static final DataType ANSI_BLOB
static final DataType ANSI_BINARY_LARGE_OBJECT
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)