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.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.
|
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)
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.
|
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. |
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.
|
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 |
DBReferenceID.resolveReference(Database db)
|
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.
|
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 and Description |
---|
DatabaseDescriptor(java.lang.Class<? extends Database> clz)
Constructs a new descriptor for the given Database implementation
class.
|
Modifier and Type | Method and Description |
---|---|
DataType |
DataTypeRegistry.createUserDataType(java.lang.String name,
java.lang.Class<? extends Database> proClz)
Deprecated.
|
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.
|
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 second 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 |
OracleDatabaseLite
Extension of OracleDatabase for the Lite 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 == 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()
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.
|
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
DataTypeSettings.getSourceName(java.lang.Class<? extends Database> clz)
Deprecated.
|
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.
|
Modifier and Type | Method and Description |
---|---|
void |
OfflineDBChooserPanel.setOnlineDatabase(Database db)
Deprecated.
|