| 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.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.ora | 
 Contains the database api implementation for Oracle databases, and additional DBObject implementations for objects specific to Oracle. 
 | 
| 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. 
 | 
| 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)  | 
| Constructor and Description | 
|---|
SQLQueryTester(Database db)  | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DatabaseDescriptor<T extends Database>
Interface used to describe the behaviour of a Database. 
 | 
| Modifier and Type | Interface and Description | 
|---|---|
interface  | 
JdbcDatabase
Implementation of the  
Database interface for JDBC Databases. | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
AbstractDatabase
Base implementation of the  
Database interface. | 
| 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)  | 
| 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. | 
java.lang.Class<? extends Database> | 
DatabaseRegistry.loadDatabaseClass(java.lang.String clzName)
Attempts to load the given database class name. 
 | 
| 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)  | 
DBObject | 
ReferenceID.resolveReference(Database db)
Deprecated.  
 | 
DBObject | 
DBReferenceID.resolveReference(Database db)
 | 
| 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. | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DDLDatabase
Database implementation that uses a DDLGenerator to create, update and delete objects. 
 | 
| Constructor and Description | 
|---|
BundleDDLGenerator(java.lang.Class<? extends Database> databaseClass, DBObjectProvider pro, java.lang.String... resourceNames)
Note the first parameter is a DBObjectProvider, not a Database. 
 | 
TokenDDLGenerator(java.lang.Class<? extends Database> databaseClass, DBObjectProvider pro)
Constructs a new DDLGenerator. 
 | 
| Modifier and Type | Class and Description | 
|---|---|
class  | 
DictionaryDatabase
Database implementation that uses a DictionaryQueries object to provide the queries on the database's dictionary. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
protected Database | 
StatementWrapper.getDatabase()
Returns the Database that this wrapper is executing on. 
 | 
| 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. 
 | 
| 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. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
java.util.Map<java.lang.String,DDLGenerator> | 
DBObjectRegistry.getDDLGenerators(Database db)  | 
| 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 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. 
 | 
| 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. 
 | 
| Modifier and Type | Interface and Description | 
|---|---|
interface  | 
SQLiteDatabase  | 
| 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 is true. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
static Database | 
AppDBDropHelper.ensureConnectionInApp(DBObjectProviderNode node, Context ideContext)
Tests if the given node is in the current Application. 
 | 
| 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. 
 | 
| 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. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
ExplainPlanPanel.showExplainPlan(Database db, java.lang.String sql)  | 
| Modifier and Type | Method and Description | 
|---|---|
java.lang.Class<? extends Database> | 
DataTypeSettings.getSource()
Gets the source database class whose DataTypes we are supporting in this provider. 
 | 
static java.lang.Class<? extends Database> | 
DataTypeSettings.getSource(DBObjectProvider otherProvider)
Gets the source database class whose DataTypes we are supporting in the given provider. 
 | 
static java.util.Collection<java.lang.Class<? extends Database>> | 
DataTypeSettings.getUpgradePaths(java.lang.Class<? extends Database> dbClass)
Returns the possible classes that the source property can be upgraded to when changing the project property from the given value. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
static java.lang.String | 
DataTypeSettings.getSourceName(java.lang.Class<? extends Database> clz)  | 
static java.util.Collection<java.lang.Class<? extends Database>> | 
DataTypeSettings.getUpgradePaths(java.lang.Class<? extends Database> dbClass)
Returns the possible classes that the source property can be upgraded to when changing the project property from the given value. 
 | 
void | 
DataTypeSettings.setSource(java.lang.Class<? extends Database> clz)
Sets the source database class whose DataTypes we are supporting in this provider. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
void | 
OfflineDBChooserPanel.setOnlineDatabase(Database db)
Deprecated. 
 
 |