Uses of Interface
oracle.javatools.db.Database

Packages that use Database

Package	Description
oracle.ide.db.panels.sql.tester	UI classes for testing a SQLQuery against a database.
oracle.javatools.db	Contains a metadata API for describing database objects, and retrieving them from a provider of database objects - for example a database.
oracle.javatools.db.datatypes	Classes related to datatypes in the database API.
oracle.javatools.db.ddl	API for generating DDL in the database API.
oracle.javatools.db.dictionary	Contains a Database implementation (DictionaryDatabase) that retrieves information for retrieving object information using dictionary queries (instead of the JDBC metadata).
oracle.javatools.db.execute	Utility classes for executing statements, queries and pl/sql against a database.
oracle.javatools.db.extension	Contains classes for extending the object support that comes as standard in the database api (e.g.
oracle.javatools.db.hive
oracle.javatools.db.ora	Contains the database api implementation for Oracle databases, and additional DBObject implementations for objects specific to Oracle.
oracle.javatools.db.ora.lite	Contains extensions to the database API to support Oracle Database Lite.
oracle.javatools.db.sqlite
oracle.jdeveloper.db	Classes for accessing database connections in JDeveloper (and other FCP products).
oracle.jdeveloper.db.model	Utility classes for dealing with database Node implementations in JDeveloper (e.g.
oracle.jdeveloper.db.navigator	Utilities for using the "Database Navigator" that SQL Developer provides in JDeveloper, to avoid referencing SQL Developer code directly.
oracle.jdeveloper.db.panels	UI panels that are useful when listing, selecting or displaying database connections in dialogs and wizards.
oracle.jdeveloper.offlinedb.model	Classes that define an offline database's settings and properties.
oracle.jdeveloper.offlinedb.panels	UI panels that can be used to define / select offline databases in JDeveloper.

Uses of Database in oracle.ide.db.panels.sql.tester

Methods in oracle.ide.db.panels.sql.tester with parameters of type Database

Modifier and Type	Method and Description
protected java.util.Map<java.lang.String,?>	TesterComponent.getBindVariables(Database db, java.lang.String sqlText) Gets the bind variable names and values for the query.
protected java.util.Map<java.lang.String,?>	TesterComponent.DelegateTesterComponent.getBindVariables(Database db, java.lang.String sqlText)
abstract void	TesterComponent.testSQL(Database db, java.lang.String sqlQuery) Sets the sql query text that the component will show.
void	TesterComponent.DelegateTesterComponent.testSQL(Database db, java.lang.String sqlQuery)

Constructors in oracle.ide.db.panels.sql.tester with parameters of type Database

Constructor and Description
SQLQueryTester(Database db) Creates a Tester that includes all tester component panels that are registered by extension in the product.
SQLQueryTester(Database db, boolean dbOnly) Creates a Tester that optionally contains only db specific tester components.

Uses of Database in oracle.javatools.db

Subinterfaces of Database in oracle.javatools.db

Modifier and Type	Interface and Description
interface	JdbcDatabase Implementation of the Database interface for JDBC Databases.

Classes in oracle.javatools.db that implement Database

Modifier and Type	Class and Description
class	AbstractDatabase Base implementation of the Database interface.

Methods in oracle.javatools.db that return Database

Modifier and Type	Method and Description
static Database	DatabaseFactory.createDatabase(java.lang.String connName, DatabaseFactory.ConnectionCreator factory) Creates a Database using the given ConnectionCreator to create a connection for the given connection name.
protected abstract Database	DatabaseFactory.DatabaseCreator.createDatabaseImpl(java.lang.String connStore, java.lang.String name, java.sql.Connection conn)
static Database	DatabaseFactory.createStandaloneDatabase(java.lang.String name, java.sql.Connection conn) Creates a standalone Database for the given Connection.
Database	DatabaseFactory.ConnectionCreator.findDatabase(java.lang.String connName)
static Database	DatabaseFactory.findOrCreateDatabase(java.lang.String name, java.sql.Connection conn) Deprecated. - use DatabaseFactory.createStandaloneDatabase(java.lang.String, java.sql.Connection) to create a Database for an isolated connection. If a Database is required for a given connection name in the product use the appropriate connection store (e.g. Application Connections, or central IDE Connections).
static Database	DatabaseFactory.findOrCreateDatabase(java.lang.String storeName, java.lang.String connName) Utility method that calls DBObjectProvider.findOrCreateProvider with the correcty provider type for Databases, and a fully qualified name encoded from the given store name and connection name.
Database	DatabaseFactory.ConnectionCreator.uncacheDatabase(java.lang.String connName)

Methods in oracle.javatools.db that return types with arguments of type Database

Modifier and Type	Method and Description
static java.util.Collection<java.lang.Class<? extends Database>>	DatabaseFactory.getClasses() Deprecated. use DatabaseRegistry instead. This loads all the extensions that plug Database implementations in to the api which is bad.
protected java.lang.Class<? extends Database>	DatabaseDescriptor.getDatabaseClass() Gets the Class of Database class that is being describing (provided by the subclass on construction).
java.lang.Class<? extends Database>	DatabaseRegistry.loadDatabaseClass(java.lang.String clzName) Attempts to load the given database class name.

Methods in oracle.javatools.db with parameters of type Database

Modifier and Type	Method and Description
protected void	DatabaseFactory.ConnectionCreator.cacheDatabase(java.lang.String connName, Database db)
static java.sql.Connection	DatabaseFactory.createConnection(Database db) This will return a new Connection for the given database if possible.
static DatabaseFactory.ConnectionCreator	DatabaseFactory.findConnectionCreator(Database db) Deprecated.
static DatabaseDescriptor	DatabaseFactory.getDatabaseDescriptor(Database db) Returns a DatabaseDescriptor for the given database.
protected DatabaseDescriptor	DatabaseFactory.DatabaseCreator.getDatabaseDescriptorImpl(Database db) Called when a Database needs its own descriptor.
DBObject	DBReferenceID.resolveReference(Database db) Deprecated. Use DBUtil.resolveInOtherProvider(oracle.javatools.db.BaseObjectID, oracle.javatools.db.DBObjectProvider)
DBObject	ReferenceID.resolveReference(Database db) Deprecated.
boolean	DatabaseFactory.ConnectionCreator.shouldClearCaches(java.sql.Connection oldConn, java.sql.Connection newConn, Database db) Called on reconnect to test whether a Database should clear its caches of objects and privileges before using the new conenction.

Method parameters in oracle.javatools.db with type arguments of type Database

Modifier and Type	Method and Description
static DatabaseDescriptor	DatabaseFactory.getDatabaseDescriptor(java.lang.Class<? extends Database> providerClass) Returns a DatabaseDescriptor for the given provider class.
static java.lang.String	DatabaseFactory.getDatabaseName(java.lang.Class<? extends Database> dbClz) Deprecated. use DatabaseRegistry instead.
boolean	DatabaseDescriptor.isCompatibleUpgrade(java.lang.Class<? extends Database> dbClz, java.lang.Class<? extends Database> testClz) Deprecated. and replaced with DatabaseDescriptor.isCompatibleWith(oracle.javatools.db.DatabaseDescriptor).
boolean	DatabaseDescriptor.isCompatibleUpgrade(java.lang.Class<? extends Database> dbClz, java.lang.Class<? extends Database> testClz) Deprecated. and replaced with DatabaseDescriptor.isCompatibleWith(oracle.javatools.db.DatabaseDescriptor).
static void	DatabaseFactory.registerProviderClass(java.lang.Class<? extends Database> clz, java.lang.String name) Deprecated. use DatabaseRegistry instead.

Constructor parameters in oracle.javatools.db with type arguments of type Database

Constructor and Description
DatabaseDescriptor(java.lang.Class<? extends Database> clz) Constructs a new descriptor for the given Database implementation class.

Uses of Database in oracle.javatools.db.datatypes

Method parameters in oracle.javatools.db.datatypes with type arguments of type Database

Modifier and Type	Method and Description
DataType	DataTypeRegistry.createUserDataType(java.lang.String name, java.lang.Class<? extends Database> proClz) Deprecated. use DataTypeRegistry.createUserDataType(String,DBObjectProvider).
DataType	DataTypeRegistry.getMappedType(java.lang.String ansiTypeName, java.lang.Class<? extends Database> provider) Deprecated. with no replacement
boolean	DataTypeRegistry.isRegistered(java.lang.Class<? extends Database> dbClz) Tests whether the given database implementation has reigstered datatypes with the registry.
void	DataTypeRegistry.registerComplexType(Type type, java.lang.Class<? extends Database> provider) Deprecated. compex types are no longer registered here. See DatabaseDescriptor.listBuiltInObjects(oracle.javatools.db.DBObjectCriteria<T>)
void	DataTypeRegistry.registerDataType(DataType type, java.lang.Class<? extends Database> provider) Registers a DataType against the given provider class.
void	DataTypeRegistry.registerDataType(DataType type, java.lang.Class<? extends Database> provider, DataType ansiType) Registers a DataType against the given provider class and includes the ANSI equivalent of this type.
void	DataTypeRegistry.registerProvider(DataTypeRegistry.Registerer reg, java.lang.Class<? extends Database> provider) Registers a class responsible for registering all datatypes for the given provider class.
void	DataTypeRegistry.registerSynonym(DataType synonymType, DataType baseType, java.lang.Class<? extends Database> provider) Registers a DataType as a synonym for the given base DataType in the given provider.
DataType	DataTypeRegistry.registerSynonym(java.lang.String synonym, DataType baseType, java.lang.Class<? extends Database> provider) Registers a new synonym for the given DataType in the given provider.

Uses of Database in oracle.javatools.db.ddl

Classes in oracle.javatools.db.ddl that implement Database

Modifier and Type	Class and Description
class	DDLDatabase Database implementation that uses a DDLGenerator to create, update and delete objects.

Constructor parameters in oracle.javatools.db.ddl with type arguments of type Database

Constructor and Description
BundleDDLGenerator(java.lang.Class<? extends Database> databaseClass, DBObjectProvider pro, java.lang.String... resourceNames) Note the second parameter is a DBObjectProvider, not a Database.
TokenDDLGenerator(java.lang.Class<? extends Database> databaseClass, DBObjectProvider pro) Constructs a new DDLGenerator.

Uses of Database in oracle.javatools.db.dictionary

Classes in oracle.javatools.db.dictionary that implement Database

Modifier and Type	Class and Description
class	DictionaryDatabase Database implementation that uses a DictionaryQueries object to provide the queries on the database's dictionary.

Uses of Database in oracle.javatools.db.execute

Methods in oracle.javatools.db.execute that return Database

Modifier and Type	Method and Description
protected Database	StatementWrapper.getDatabase() Returns the Database that this wrapper is executing on.

Methods in oracle.javatools.db.execute with parameters of type Database

Modifier and Type	Method and Description
protected static DBSQLException	StatementWrapper.createDBSQLException(Database db, DBObject obj, java.lang.String text, java.sql.SQLException sqe) Creates a DBSQLException to wrap the encountered SQLException.
protected void	StatementWrapper.setDatabase(Database db) Sets the wrappers database.

Constructors in oracle.javatools.db.execute with parameters of type Database

Constructor and Description
ConnectionWrapper(Database db, java.lang.String desc) Creates a ConnectionWrapper using the given Database.
PlSqlWrapper(Database db, java.lang.String plsql, java.lang.Object... params) Creates a new wrapper for executing pl/sql, specifying the pl/sql itself and any IN parameters.
QueryWrapper(Database db, java.lang.String query) Creates a wrapper for a query with no parameters.
QueryWrapper(Database db, java.lang.String query, java.util.List params) Creates a wrapper for the given query text.
QueryWrapper(Database db, java.lang.String query, java.lang.Object... params) Creates a wrapper for the given query text.
StatementWrapper(Database db, boolean reconnectFirst, java.lang.String... statements) Creates a new wrapper for executing statements against the given Database.
StatementWrapper(Database db, java.lang.String... statements) Creates a new StatementWrapper for executing the given statements against a Database.

Uses of Database in oracle.javatools.db.extension

Methods in oracle.javatools.db.extension with parameters of type Database

Modifier and Type	Method and Description
java.util.Map<java.lang.String,DDLGenerator>	DBObjectRegistry.getDDLGenerators(Database db)

Method parameters in oracle.javatools.db.extension with type arguments of type Database

Modifier and Type	Method and Description
java.util.Map<java.lang.String,DDLGenerator>	DBObjectRegistry.getDDLGenerators(java.lang.String dbType, int version, java.lang.Class<? extends Database> dbClz, DBObjectProvider pro)

Constructor parameters in oracle.javatools.db.extension with type arguments of type Database

Constructor and Description
DelegateDDLGenerator(DDLGenerator base, DatabaseDescriptor desc, java.lang.Class<? extends Database> databaseClass, DBObjectProvider pro) Constructs a DDLGenerator that will check the DBObjectRegistry for a registered DDLGenerator to delegate to for a given object type, and if there isn't one delegates to the base generator given on construction.

Uses of Database in oracle.javatools.db.hive

Subinterfaces of Database in oracle.javatools.db.hive

Modifier and Type	Interface and Description
interface	HiveDatabase Specialisation of Database for implementations that connect to a Hive metastore.

Uses of Database in oracle.javatools.db.ora

Subinterfaces of Database in oracle.javatools.db.ora

Modifier and Type	Interface and Description
interface	OracleDatabase Extension of the Database interface for Oracle specific implementations.
interface	OracleDatabaseXE Extension of OracleDatabase for the XE version of the database.

Methods in oracle.javatools.db.ora that return Database

Modifier and Type	Method and Description
Database	OracleDatabase.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.

Uses of Database in oracle.javatools.db.ora.lite

Subinterfaces of Database in oracle.javatools.db.ora.lite

Modifier and Type	Interface and Description
interface	OracleDatabaseLite Extension of OracleDatabase for the Lite version of the database.

Uses of Database in oracle.javatools.db.sqlite

Subinterfaces of Database in oracle.javatools.db.sqlite

Modifier and Type	Interface and Description
interface	SQLiteDatabase

Uses of Database in oracle.jdeveloper.db

Methods in oracle.jdeveloper.db that return Database

Modifier and Type	Method and Description
Database	DatabaseConnectionStores.getCurrentDatabase(Context ideContext) Will return the current Database that is selected in the IDE.
Database	ConnectionsEvent.getDatabase() Gets the Database that the event is fired for.
Database	ConnectionInfo.getDatabase() Returns a Database for the connection.
Database	DatabaseConnections.getDatabase(java.lang.String connName) Returns a Database for the given connection name.
Database	DatabaseConnections.getDatabase(java.lang.String connName, boolean create) Returns a Database for the given connection name if one is already cached, and only creates a new one if create == true.

Uses of Database in oracle.jdeveloper.db.model

Methods in oracle.jdeveloper.db.model that return Database

Modifier and Type	Method and Description
static Database	AppDBDropHelper.ensureConnectionInApp(DBObjectProviderNode node, Context ideContext) Tests if the given node is in the current Application.

Uses of Database in oracle.jdeveloper.db.navigator

Methods in oracle.jdeveloper.db.navigator with parameters of type Database

Modifier and Type	Method and Description
static DatabaseNode	DatabaseNavigatorHelper.findConnectionNode(Database db) Gets the node in the Database Navigator that respresents the given database.
static DBObjectNode	DatabaseNavigatorHelper.findObjectNode(Database db, SystemObject obj) Gets the node in the Database Navigator for the given object within the given Database.
static DBObjectTypeNode	DatabaseNavigatorHelper.findTypeNode(Database db, Schema schema, java.lang.String type) Gets the given type folder in the Database Navigator (e.g.

Uses of Database in oracle.jdeveloper.db.panels

Methods in oracle.jdeveloper.db.panels that return Database

Modifier and Type	Method and Description
static Database	DatabaseFinder.findDatabase(java.lang.String connString) Returns the Database class for the given connection name.
static Database	DatabaseFinder.findDatabaseEx(java.lang.String connString) Finds the Database for the given qualified connection String.

Methods in oracle.jdeveloper.db.panels with parameters of type Database

Modifier and Type	Method and Description
void	ExplainPlanPanel.showExplainPlan(Database db, java.lang.String sql)

Uses of Database in oracle.jdeveloper.offlinedb.model

Methods in oracle.jdeveloper.offlinedb.model that return types with arguments of type Database

Modifier and Type	Method and Description
java.lang.Class<? extends Database>	DataTypeSettings.getSource() Deprecated. the class is not longer used - replaced by DataTypeSettings.getDatabaseDescriptor()
static java.lang.Class<? extends Database>	DataTypeSettings.getSource(DBObjectProvider otherProvider) Deprecated. source class is no longer used, DatabaseDescriptor is used instead.
static java.util.Collection<java.lang.Class<? extends Database>>	DataTypeSettings.getUpgradePaths(java.lang.Class<? extends Database> dbClass) Deprecated. use the compatability methods on DatabaseDescriptor instead.

Method parameters in oracle.jdeveloper.offlinedb.model with type arguments of type Database

Modifier and Type	Method and Description
static java.lang.String	DataTypeSettings.getSourceName(java.lang.Class<? extends Database> clz) Deprecated. use DatabaseDescriptor.getDatabaseName()
static java.util.Collection<java.lang.Class<? extends Database>>	DataTypeSettings.getUpgradePaths(java.lang.Class<? extends Database> dbClass) Deprecated. use the compatability methods on DatabaseDescriptor instead.
void	DataTypeSettings.setSource(java.lang.Class<? extends Database> clz) Deprecated. use DataTypeSettings.setDatabaseDescriptor(oracle.javatools.db.DatabaseDescriptor) instead.

Uses of Database in oracle.jdeveloper.offlinedb.panels

Methods in oracle.jdeveloper.offlinedb.panels with parameters of type Database

Modifier and Type	Method and Description
void	OfflineDBChooserPanel.setOnlineDatabase(Database db) Deprecated. use OfflineDBChooserPanel.setOtherProvider(DBObjectProvider)