public class OracleMetadata extends JdbcMetadata
JdbcMetadata.DbMetadata
Modifier and Type | Field and Description |
---|---|
protected static Map<String,String> |
ORACLE_METADATA_METHODS
The Oracle metadata methods.
|
protected static Map<String,String> |
ORACLE_TYPE_METHODS
The Oracle type methods.
|
protected static Map<String,String> |
ORACLE_TYPE_SUPPORT_AS_TEXT
The Oracle object types which support asText.
|
protected static Map<String,String> |
ORACLE_TYPE_SUPPORT_EXECUTE_AS_TEXT
The oracle type support execute as text map.
|
protected static Map<String,String> |
ORACLE_TYPES_BY_PARENT
The Oracle types by parent.
|
ALLOWED_FOR_SCHEMA_CATALOG, ALLOWED_FOR_TABLE, ALLOWED_TOP_LEVEL, METADATA_METHODS, TYPE_METHODS, TYPE_SUPPORT_AS_TEXT, TYPE_SUPPORT_DROP_AS_TEXT, TYPES_BY_PARENT
TYPES_SUPPORT_REFRESH
ALL_REFS, ALL_TYPES, BASE_CLASS_PATH, DB_DELIMITER, DEFAULT_METHOD, DEFAULT_TYPE, ID_FIELD, METADATA_DELIMITER, SYNONYMS_DATASET_TYPE, TABLE_PRIV, TABLE_PRIVS, TABLES_DATASET_TYPE, TYPE_ALIAS, TYPE_ALIASES, TYPE_ASSEMBLIES, TYPE_ASSEMBLY, TYPE_CATALOG, TYPE_CLASS, TYPE_COLUMN, TYPE_COLUMNS, TYPE_CONSTRAINTS, TYPE_DATA_SET, TYPE_DB_LINK, TYPE_DB_LINKS, TYPE_DBFUNCT, TYPE_DBFUNCTIONS, TYPE_DBINFO, TYPE_DBPROP, TYPE_DBPROPS, TYPE_DIRECTORIES, TYPE_DIRECTORY, TYPE_EK, TYPE_EK_COLUMN, TYPE_EK_COLUMNS, TYPE_EKS, TYPE_EXEC_METHOD, TYPE_EXEC_METHODS, TYPE_FILE, TYPE_FK, TYPE_FK_COLUMN, TYPE_FK_COLUMNS, TYPE_FKS, TYPE_FUNCT, TYPE_FUNCT_PARAMETERS, TYPE_FUNCTS, TYPE_GLOBAL_TEMPORARIES, TYPE_INDEX, TYPE_INDEX_COLUMN, TYPE_INDEX_COLUMNS, TYPE_INDEXES, TYPE_JAVA_CLASSES, TYPE_LOCAL_TEMPORARIES, TYPE_NICKNAME, TYPE_PACKAGE, TYPE_PACKAGE_BODY, TYPE_PACKAGES, TYPE_PARAMETER, TYPE_PARAMETERS, TYPE_PK, TYPE_PK_COLUMN, TYPE_PK_COLUMNS, TYPE_PKS, TYPE_PROC, TYPE_PROC_PARAMETERS, TYPE_PROCS, TYPE_PROCS_FUNCS, TYPE_QUEUE, TYPE_QUEUE_TABLE, TYPE_QUEUE_TABLES, TYPE_QUEUES, TYPE_RECYCLE_BIN, TYPE_RECYCLE_BIN_ITEM, TYPE_SCHEMA, TYPE_SEQUENCE, TYPE_SEQUENCES, TYPE_SYNONYM, TYPE_SYNONYMS, TYPE_SYSTEM_TABLES, TYPE_SYSTEM_VIEWS, TYPE_TABLE, TYPE_TABLES, TYPE_TEMPORARY_TABLES, TYPE_TEMPORARY_VIEWS, TYPE_TRIGGER, TYPE_TRIGGERS, TYPE_TYPE, TYPE_TYPES, TYPE_USER_TYPE, TYPE_USER_TYPES, TYPE_VIEW, TYPE_VIEWS, TYPE_WORKSHEET, TYPE_WORKSHEETS, TYPE_XML_SCHEMA, TYPE_XML_SCHEMAS, VIEWS_DATASET_TYPE
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
OracleMetadata() |
Modifier and Type | Method and Description |
---|---|
String |
asTextMethod(String type)
asText method name for the type.
|
String |
createAsText(String sql,
String catalog,
String schema,
String pattern,
String type)
Shows object create DDL.
|
String |
executeAsText(String catalog,
String schema,
String pattern,
String type,
String metadataId)
Shows object execute SQL.
|
DataSet |
getConstraints(String catalog,
String schema,
String pattern,
String type)
Gets table or view constraints.
|
static String |
getConstraintType(Object type)
Gets the constraint type.
|
DataSet |
getDbLinks(String catalog,
String schema,
String pattern,
String type)
Gets the database links.
|
List<String> |
getDbObjectTypes()
Gets the database object types.
|
String |
getDdl(String schema,
String name,
String type)
Gets the ddl for the object.
|
DataSet |
getDirectories(String catalog,
String schema,
String pattern,
String type)
Gets the directories.
|
String |
getDropClassAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop java class SQL.
|
List<String> |
getFunctMetadataTypes()
Gets the function metadata types.
|
DataSet |
getFuncts(String catalog,
String schema,
String pattern,
String type)
Gets the functions.
|
String |
getIndexAsText(String catalog,
String schema,
String pattern,
String type)
Gets the index as text.
|
DataSet |
getIndexColumns(String catalog,
String schema,
String pattern,
String type)
Gets the index columns.
|
String |
getJavaClassAsText(String catalog,
String schema,
String pattern,
String type)
Gets the Java class as text.
|
DataSet |
getJavaClasses(String catalog,
String schema,
String pattern,
String type)
Gets the Java classes.
|
String |
getLicensePropertyName()
Gets the name of the license property.
|
Map<String,String> |
getMetadataMethods()
Gets the metadata methods.
|
String |
getName()
Gets the name.
|
KeyValue[] |
getObjectTypes()
Gets the object types.
|
String |
getPackageAsText(String catalog,
String schema,
String pattern,
String type)
Gets the package as text.
|
DataSet |
getPackageBody(String catalog,
String schema,
String pattern,
String type)
Gets the package body.
|
String |
getPackageBodyAsText(String catalog,
String schema,
String pattern,
String type)
Gets the package body as text.
|
List<String> |
getPackageBodyMetadataTypes()
Gets the package metadata types.
|
List<String> |
getPackageMetadataTypes()
Gets the package body metadata types.
|
DataSet |
getPackages(String catalog,
String schema,
String pattern,
String type)
Gets the packages.
|
DataSet |
getParameters(String catalog,
String schema,
String pattern,
String type,
String metadataId) |
String |
getProcAsText(String catalog,
String schema,
String pattern,
String type,
String metadataId)
Gets the procedure as text.
|
List<String> |
getProcMetadataTypes()
Gets the procedure metadata types.
|
DataSet |
getProcs(String catalog,
String schema,
String pattern,
String type)
Gets the procedures.
|
DataSet |
getQueues(String catalog,
String schema,
String pattern,
String type)
Gets the queues.
|
DataSet |
getQueueTables(String catalog,
String schema,
String pattern,
String type)
Gets the queue tables.
|
DataSet |
getRecycleBinItems(String catalog,
String schema,
String pattern,
String type)
Gets the recycle bin items.
|
String |
getSequenceAsText(String catalog,
String schema,
String pattern,
String type)
Gets the sequence as text.
|
DataSet |
getSequences(String catalog,
String schema,
String pattern,
String type)
Gets the sequences.
|
String |
getSynonymAsText(String catalog,
String schema,
String pattern,
String type)
Gets the synonym as text.
|
DataSet |
getSynonyms(String catalog,
String schema,
String pattern)
Gets the synonyms.
|
String |
getTableAsText(String catalog,
String schema,
String pattern,
String type)
Gets the table as text.
|
DataSet |
getTableColumns(String catalog,
String schema,
String pattern,
String type)
Gets the table columns.
|
DataSet |
getTableIndexes(String catalog,
String schema,
String pattern,
String type)
Gets the table indexes.
|
List<String> |
getTableMetadataTypes()
Gets the table metadata types.
|
String |
getTableNameAsText(String catalog,
String schema,
String pattern,
String type,
String name)
Gets the table name as text.
|
DataSet |
getTablesByType(String catalog,
String schema,
String pattern,
String type)
Gets the tables by type.
|
List<String> |
getTableTypes()
Gets the table types.
|
String |
getTriggerAsText(String catalog,
String schema,
String pattern,
String type)
Gets the trigger as text.
|
DataSet |
getTriggers(String catalog,
String schema,
String pattern,
String type)
Gets the triggers.
|
String |
getTypeByTypeFieldValue(String value)
Gets the type by type field value.
|
String |
getTypeField()
Gets the type field.
|
Map<String,String> |
getTypeMethods()
Gets the type methods.
|
Map<String,String> |
getTypesByParent()
Gets the types by parent.
|
String |
getUserTypeAsText(String catalog,
String schema,
String pattern,
String type)
Gets the user defined type as text.
|
DataSet |
getUserTypes(String catalog,
String schema,
String pattern,
String type)
Gets the user defined types.
|
String |
getVendor()
Gets the vendor.
|
String |
getViewAsText(String catalog,
String schema,
String pattern,
String type)
Gets the view as text.
|
List<String> |
getViewMetadataTypes()
Gets the view metadata types.
|
DataSet |
getViews(String catalog,
String schema,
String pattern)
Gets the views.
|
DataSet |
getXmlSchemas(String catalog,
String schema,
String pattern,
String type)
Gets the xml schemas.
|
boolean |
needToPopulate(String type)
Checks if metadata node needs to be populatet.
|
DataSet |
searchDatabase(DatabaseFilter filter)
Search database objects.
|
boolean |
supportsAsText(String type)
Checks if metadata driver supports asText method for the type.
|
boolean |
supportsExecute(String type)
Checks if metadata driver supports executeAsText method for the type.
|
boolean |
supportsSearchDatabase()
Checks if metadata driver supports search database.
|
allowNotDefault, asText, chooseBestIndex, discoverDatabaseTypes, dropAsText, dropAsTextMethod, free, getAllowedSchema, getAllRefs, getCatalogs, getCatalogSchemaAndPattern, getCatalogSchemaMetadataAllowed, getDbFunctions, getDbInfoObjects, getDbMetadata, getDbObjectsByWildcard, getDbProps, getDeleteRule, getDropAliasAsText, getDropAssemblyAsText, getDropDbLinkAsText, getDropFunctionAsText, getDropIndexAsText, getDropPackageAsText, getDropProcAsText, getDropSequenceAsText, getDropSynonymAsText, getDropTableAsText, getDropTriggerAsText, getDropTypeAsText, getDropViewAsText, getEKColumns, getEKMetadataTypes, getFKColumns, getFkDefinitionAsText, getFKMetadataTypes, getFksAsText, getFuncParamNameForNull, getFuncParamType, getFuncRetType, getFunctParameters, getIndexDefinitionAsText, getIndexesAsText, getIndexMetadataTypes, getOwners, getParameters, getPkAsText, getPKColumns, getPKMetadataTypes, getProcParameters, getProcsRetType, getSchemas, getSuggestedKeyFields, getTableEKs, getTableEKs, getTableFKs, getTableMetadataAllowed, getTablePKs, getTablePrivs, getTopLevelAllowed, getTopLevelDbObjects, getTransIsolation, getTypes, getUpdateRule, getVersion, isOutParam, isUnique, populateTables, supportsDrop
compareTo, getColumns, getConfigFileName, getConnectionFactory, getConnectionParamsProvider, getCurrentDatabase, getDefaultColumns, getDisplayName, getDriver, getExtensionRank, getFullObjectName, getIconPath, getLocalUnitClassPath, getMetadataByType, getMetadataByTypePreserveException, getMetadataTypeByParentType, getMetadataTypes, getObjectName, getObjectOwnerName, getType, getXmlConfigFileName, hasCatalogs, hasMetadataTypes, hasSchemas, init, isDatabaseCurrent, setCurrentDatabase, setHasCatalogs, setHasSchemas, supportsRefresh
protected static Map<String,String> ORACLE_TYPE_METHODS
protected static Map<String,String> ORACLE_METADATA_METHODS
protected static Map<String,String> ORACLE_TYPES_BY_PARENT
protected static Map<String,String> ORACLE_TYPE_SUPPORT_AS_TEXT
protected static Map<String,String> ORACLE_TYPE_SUPPORT_EXECUTE_AS_TEXT
public static String getConstraintType(Object type)
type
- the typepublic String asTextMethod(String type)
JdbcMetadata
asTextMethod
in class JdbcMetadata
type
- the typepublic String createAsText(String sql, String catalog, String schema, String pattern, String type)
Metadata
createAsText
in interface Metadata
createAsText
in class JdbcMetadata
sql
- the sqlcatalog
- the catalogschema
- the schemapattern
- the patterntype
- the typepublic String executeAsText(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
Metadata
executeAsText
in interface Metadata
executeAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typemetadataId
- the metadata idException
- in case of any errorpublic DataSet getConstraints(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic DataSet getDbLinks(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getDbObjectTypes() throws Exception
JdbcMetadata
getDbObjectTypes
in class JdbcMetadata
Exception
- in case of any errorpublic String getDdl(String schema, String name, String type) throws Exception
schema
- the schemaname
- the nametype
- the typeException
- in case of any errorpublic DataSet getDirectories(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getDropClassAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic List<String> getFunctMetadataTypes()
JdbcMetadata
getFunctMetadataTypes
in class JdbcMetadata
public DataSet getFuncts(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getFuncts
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getIndexAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getIndexColumns(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getIndexColumns
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getJavaClassAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getJavaClasses(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getLicensePropertyName()
ExtensionModule
getLicensePropertyName
in interface ExtensionModule
getLicensePropertyName
in class JdbcMetadata
public Map<String,String> getMetadataMethods()
BaseMetadata
getMetadataMethods
in class JdbcMetadata
public String getName()
Metadata
getName
in interface Metadata
getName
in class JdbcMetadata
public KeyValue[] getObjectTypes()
Metadata
getObjectTypes
in interface Metadata
getObjectTypes
in class BaseMetadata
public String getPackageAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getPackageBody(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getPackageBodyAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getPackageBodyMetadataTypes()
public List<String> getPackageMetadataTypes()
public DataSet getPackages(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getParameters(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
Exception
public String getProcAsText(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typemetadataId
- the metadata idException
- in case of any errorpublic List<String> getProcMetadataTypes()
JdbcMetadata
getProcMetadataTypes
in class JdbcMetadata
public DataSet getProcs(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getProcs
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getQueues(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getQueueTables(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getRecycleBinItems(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getSequenceAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getSequences(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getSynonymAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getSynonyms(String catalog, String schema, String pattern) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patternException
- in case of any errorpublic String getTableAsText(String catalog, String schema, String pattern, String type) throws Exception
getTableAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableColumns(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getTableColumns
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableIndexes(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getTableIndexes
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getTableMetadataTypes()
JdbcMetadata
getTableMetadataTypes
in class JdbcMetadata
public String getTableNameAsText(String catalog, String schema, String pattern, String type, String name) throws Exception
JdbcMetadata
getTableNameAsText
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typename
- the nameException
- in case of any errorpublic DataSet getTablesByType(String catalog, String schema, String pattern, String type) throws Exception
JdbcMetadata
getTablesByType
in class JdbcMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getTableTypes() throws Exception
JdbcMetadata
getTableTypes
in class JdbcMetadata
Exception
- in case of any errorpublic String getTriggerAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTriggers(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getTypeByTypeFieldValue(String value)
Metadata
getTypeByTypeFieldValue
in interface Metadata
getTypeByTypeFieldValue
in class JdbcMetadata
value
- the valuepublic String getTypeField()
Metadata
getTypeField
in interface Metadata
getTypeField
in class JdbcMetadata
public Map<String,String> getTypeMethods()
Metadata
getTypeMethods
in interface Metadata
getTypeMethods
in class JdbcMetadata
public Map<String,String> getTypesByParent()
BaseMetadata
getTypesByParent
in class JdbcMetadata
public String getUserTypeAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getUserTypes(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getVendor()
ExtensionModule
getVendor
in interface ExtensionModule
getVendor
in class JdbcMetadata
public String getViewAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getViewMetadataTypes()
JdbcMetadata
getViewMetadataTypes
in class JdbcMetadata
public DataSet getViews(String catalog, String schema, String pattern) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patternException
- in case of any errorpublic DataSet getXmlSchemas(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic boolean needToPopulate(String type)
Metadata
needToPopulate
in interface Metadata
needToPopulate
in class JdbcMetadata
type
- the typepublic DataSet searchDatabase(DatabaseFilter filter) throws Exception
Metadata
searchDatabase
in interface Metadata
searchDatabase
in class BaseMetadata
filter
- the search filterException
- in case of any errorpublic boolean supportsAsText(String type)
Metadata
supportsAsText
in interface Metadata
supportsAsText
in class JdbcMetadata
type
- the typepublic boolean supportsExecute(String type)
Metadata
supportsExecute
in interface Metadata
supportsExecute
in class JdbcMetadata
type
- the typepublic boolean supportsSearchDatabase()
Metadata
supportsSearchDatabase
in interface Metadata
supportsSearchDatabase
in class BaseMetadata
Copyright © 2010-2020 Toolsverse. All Rights Reserved.