com.toolsverse.etl.metadata.oracle

Class OracleMetadata

Object

com.toolsverse.etl.metadata.BaseMetadata

com.toolsverse.etl.metadata.JdbcMetadata

com.toolsverse.etl.metadata.oracle.OracleMetadata

All Implemented Interfaces:

Metadata, ExtensionModule, Comparable<ExtensionModule>

public class OracleMetadata
extends JdbcMetadata

The Oracle implementation of the Metadata interface.

Since:

1.0

Version:

2.0

Nested Class Summary

Nested classes/interfaces inherited from class com.toolsverse.etl.metadata.JdbcMetadata

JdbcMetadata.DbMetadata

Field Summary

Fields

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.

Fields inherited from class com.toolsverse.etl.metadata.JdbcMetadata

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

Fields inherited from class com.toolsverse.etl.metadata.BaseMetadata

TYPES_SUPPORT_REFRESH

Fields inherited from interface com.toolsverse.etl.metadata.Metadata

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

Fields inherited from interface com.toolsverse.ext.ExtensionModule

APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET

Constructor Summary

Constructors

Constructor and Description
OracleMetadata()

Method Summary

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.

Methods inherited from class com.toolsverse.etl.metadata.JdbcMetadata

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

Methods inherited from class com.toolsverse.etl.metadata.BaseMetadata

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

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ORACLE_TYPE_METHODS

protected static Map<String,String> ORACLE_TYPE_METHODS

The Oracle type methods.

ORACLE_METADATA_METHODS

protected static Map<String,String> ORACLE_METADATA_METHODS

The Oracle metadata methods.

ORACLE_TYPES_BY_PARENT

protected static Map<String,String> ORACLE_TYPES_BY_PARENT

The Oracle types by parent.

ORACLE_TYPE_SUPPORT_AS_TEXT

protected static Map<String,String> ORACLE_TYPE_SUPPORT_AS_TEXT

The Oracle object types which support asText.

ORACLE_TYPE_SUPPORT_EXECUTE_AS_TEXT

protected static Map<String,String> ORACLE_TYPE_SUPPORT_EXECUTE_AS_TEXT

The oracle type support execute as text map.

Constructor Detail

OracleMetadata

public OracleMetadata()

Method Detail

getConstraintType

public static String getConstraintType(Object type)

Gets the constraint type.

Parameters:

type - the type

Returns:

the constraint type

asTextMethod

public String asTextMethod(String type)

Description copied from class: JdbcMetadata

asText method name for the type.

Overrides:

asTextMethod in class JdbcMetadata

Parameters:

type - the type

Returns:

the string

createAsText

public String createAsText(String sql,
                           String catalog,
                           String schema,
                           String pattern,
                           String type)

Description copied from interface: Metadata

Shows object create DDL.

Specified by:

createAsText in interface Metadata

Overrides:

createAsText in class JdbcMetadata

Parameters:

sql - the sql

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the string

executeAsText

public String executeAsText(String catalog,
                            String schema,
                            String pattern,
                            String type,
                            String metadataId)
                     throws Exception

Description copied from interface: Metadata

Shows object execute SQL.

Specified by:

executeAsText in interface Metadata

Overrides:

executeAsText in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

metadataId - the metadata id

Returns:

the string

Throws:

Exception - in case of any error

getConstraints

public DataSet getConstraints(String catalog,
                              String schema,
                              String pattern,
                              String type)
                       throws Exception

Gets table or view constraints.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the constraints

Throws:

Exception - the exception

getDbLinks

public DataSet getDbLinks(String catalog,
                          String schema,
                          String pattern,
                          String type)
                   throws Exception

Gets the database links.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the database links

Throws:

Exception - in case of any error

getDbObjectTypes

public List<String> getDbObjectTypes()
                              throws Exception

Description copied from class: JdbcMetadata

Gets the database object types.

Overrides:

getDbObjectTypes in class JdbcMetadata

Returns:

the database object types

Throws:

Exception - in case of any error

getDdl

public String getDdl(String schema,
                     String name,
                     String type)
              throws Exception

Gets the ddl for the object.

Parameters:

schema - the schema

name - the name

type - the type

Returns:

the ddl for the object

Throws:

Exception - in case of any error

getDirectories

public DataSet getDirectories(String catalog,
                              String schema,
                              String pattern,
                              String type)
                       throws Exception

Gets the directories.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the directories

Throws:

Exception - in case of any error

getDropClassAsText

public String getDropClassAsText(String catalog,
                                 String schema,
                                 String pattern,
                                 String type)
                          throws Exception

Gets the drop java class SQL.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the SQL

Throws:

Exception - the exception

getFunctMetadataTypes

public List<String> getFunctMetadataTypes()

Description copied from class: JdbcMetadata

Gets the function metadata types.

Overrides:

getFunctMetadataTypes in class JdbcMetadata

Returns:

the function metadata types

getFuncts

public DataSet getFuncts(String catalog,
                         String schema,
                         String pattern,
                         String type)
                  throws Exception

Description copied from class: JdbcMetadata

Gets the functions.

Overrides:

getFuncts in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the function

Throws:

Exception - in case of any error

getIndexAsText

public String getIndexAsText(String catalog,
                             String schema,
                             String pattern,
                             String type)
                      throws Exception

Gets the index as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the index as text

Throws:

Exception - in case of any error

getIndexColumns

public DataSet getIndexColumns(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Description copied from class: JdbcMetadata

Gets the index columns.

Overrides:

getIndexColumns in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the index columns

Throws:

Exception - in case of any error

getJavaClassAsText

public String getJavaClassAsText(String catalog,
                                 String schema,
                                 String pattern,
                                 String type)
                          throws Exception

Gets the Java class as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the Java class as text

Throws:

Exception - in case of any error

getJavaClasses

public DataSet getJavaClasses(String catalog,
                              String schema,
                              String pattern,
                              String type)
                       throws Exception

Gets the Java classes.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the java classes

Throws:

Exception - in case of any error

getLicensePropertyName

public String getLicensePropertyName()

Description copied from interface: ExtensionModule

Gets the name of the license property. If not null the model is a subject of licensing.

Specified by:

getLicensePropertyName in interface ExtensionModule

Overrides:

getLicensePropertyName in class JdbcMetadata

Returns:

the name of the license property

getMetadataMethods

public Map<String,String> getMetadataMethods()

Description copied from class: BaseMetadata

Gets the metadata methods.

Overrides:

getMetadataMethods in class JdbcMetadata

Returns:

the metadata methods

getName

public String getName()

Description copied from interface: Metadata

Gets the name.

Specified by:

getName in interface Metadata

Overrides:

getName in class JdbcMetadata

Returns:

the name

getObjectTypes

public KeyValue[] getObjectTypes()

Description copied from interface: Metadata

Gets the object types.

Specified by:

getObjectTypes in interface Metadata

Overrides:

getObjectTypes in class BaseMetadata

Returns:

the object types, key = type, value = description

getPackageAsText

public String getPackageAsText(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Gets the package as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the package as text

Throws:

Exception - in case of any error

getPackageBody

public DataSet getPackageBody(String catalog,
                              String schema,
                              String pattern,
                              String type)
                       throws Exception

Gets the package body.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the package body

Throws:

Exception - in case of any error

getPackageBodyAsText

public String getPackageBodyAsText(String catalog,
                                   String schema,
                                   String pattern,
                                   String type)
                            throws Exception

Gets the package body as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the package body as text

Throws:

Exception - in case of any error

getPackageBodyMetadataTypes

public List<String> getPackageBodyMetadataTypes()

Gets the package metadata types.

Returns:

the package metadata types

getPackageMetadataTypes

public List<String> getPackageMetadataTypes()

Gets the package body metadata types.

Returns:

the package body metadata types

getPackages

public DataSet getPackages(String catalog,
                           String schema,
                           String pattern,
                           String type)
                    throws Exception

Gets the packages.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the packages

Throws:

Exception - in case of any error

getParameters

public DataSet getParameters(String catalog,
                             String schema,
                             String pattern,
                             String type,
                             String metadataId)
                      throws Exception

Throws:

Exception

getProcAsText

public String getProcAsText(String catalog,
                            String schema,
                            String pattern,
                            String type,
                            String metadataId)
                     throws Exception

Gets the procedure as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

metadataId - the metadata id

Returns:

the procedure as text

Throws:

Exception - in case of any error

getProcMetadataTypes

public List<String> getProcMetadataTypes()

Description copied from class: JdbcMetadata

Gets the procedure metadata types.

Overrides:

getProcMetadataTypes in class JdbcMetadata

Returns:

the procedure metadata types

getProcs

public DataSet getProcs(String catalog,
                        String schema,
                        String pattern,
                        String type)
                 throws Exception

Description copied from class: JdbcMetadata

Gets the procedures.

Overrides:

getProcs in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the procedures

Throws:

Exception - in case of any error

getQueues

public DataSet getQueues(String catalog,
                         String schema,
                         String pattern,
                         String type)
                  throws Exception

Gets the queues.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the queues

Throws:

Exception - in case of any error

getQueueTables

public DataSet getQueueTables(String catalog,
                              String schema,
                              String pattern,
                              String type)
                       throws Exception

Gets the queue tables.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the queue tables

Throws:

Exception - in case of any error

getRecycleBinItems

public DataSet getRecycleBinItems(String catalog,
                                  String schema,
                                  String pattern,
                                  String type)
                           throws Exception

Gets the recycle bin items.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the recycle bin items

Throws:

Exception - in case of any error

getSequenceAsText

public String getSequenceAsText(String catalog,
                                String schema,
                                String pattern,
                                String type)
                         throws Exception

Gets the sequence as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the sequence as text

Throws:

Exception - in case of any error

getSequences

public DataSet getSequences(String catalog,
                            String schema,
                            String pattern,
                            String type)
                     throws Exception

Gets the sequences.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the sequences

Throws:

Exception - in case of any error

getSynonymAsText

public String getSynonymAsText(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Gets the synonym as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the synonym as text

Throws:

Exception - in case of any error

getSynonyms

public DataSet getSynonyms(String catalog,
                           String schema,
                           String pattern)
                    throws Exception

Gets the synonyms.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

Returns:

the views

Throws:

Exception - in case of any error

getTableAsText

public String getTableAsText(String catalog,
                             String schema,
                             String pattern,
                             String type)
                      throws Exception

Gets the table as text.

Overrides:

getTableAsText in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the table as text

Throws:

Exception - in case of any error

getTableColumns

public DataSet getTableColumns(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Description copied from class: JdbcMetadata

Gets the table columns.

Overrides:

getTableColumns in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the table columns

Throws:

Exception - in case of any error

getTableIndexes

public DataSet getTableIndexes(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Description copied from class: JdbcMetadata

Gets the table indexes.

Overrides:

getTableIndexes in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the table indexes

Throws:

Exception - in case of any error

getTableMetadataTypes

public List<String> getTableMetadataTypes()

Description copied from class: JdbcMetadata

Gets the table metadata types.

Overrides:

getTableMetadataTypes in class JdbcMetadata

Returns:

the table metadata types

getTableNameAsText

public String getTableNameAsText(String catalog,
                                 String schema,
                                 String pattern,
                                 String type,
                                 String name)
                          throws Exception

Description copied from class: JdbcMetadata

Gets the table name as text.

Overrides:

getTableNameAsText in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

name - the name

Returns:

the table name as text

Throws:

Exception - in case of any error

getTablesByType

public DataSet getTablesByType(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Description copied from class: JdbcMetadata

Gets the tables by type.

Overrides:

getTablesByType in class JdbcMetadata

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the tables by type

Throws:

Exception - in case of any error

getTableTypes

public List<String> getTableTypes()
                           throws Exception

Description copied from class: JdbcMetadata

Gets the table types.

Overrides:

getTableTypes in class JdbcMetadata

Returns:

the table types

Throws:

Exception - in case of any error

getTriggerAsText

public String getTriggerAsText(String catalog,
                               String schema,
                               String pattern,
                               String type)
                        throws Exception

Gets the trigger as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the trigger as text

Throws:

Exception - in case of any error

getTriggers

public DataSet getTriggers(String catalog,
                           String schema,
                           String pattern,
                           String type)
                    throws Exception

Gets the triggers.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the triggers

Throws:

Exception - in case of any error

getTypeByTypeFieldValue

public String getTypeByTypeFieldValue(String value)

Description copied from interface: Metadata

Gets the type by type field value.

Specified by:

getTypeByTypeFieldValue in interface Metadata

Overrides:

getTypeByTypeFieldValue in class JdbcMetadata

Parameters:

value - the value

Returns:

the type by type field value

getTypeField

public String getTypeField()

Description copied from interface: Metadata

Gets the type field.

Specified by:

getTypeField in interface Metadata

Overrides:

getTypeField in class JdbcMetadata

Returns:

the type field

getTypeMethods

public Map<String,String> getTypeMethods()

Description copied from interface: Metadata

Gets the type methods.

Specified by:

getTypeMethods in interface Metadata

Overrides:

getTypeMethods in class JdbcMetadata

Returns:

the type methods

getTypesByParent

public Map<String,String> getTypesByParent()

Description copied from class: BaseMetadata

Gets the types by parent.

Overrides:

getTypesByParent in class JdbcMetadata

Returns:

the types by parent

getUserTypeAsText

public String getUserTypeAsText(String catalog,
                                String schema,
                                String pattern,
                                String type)
                         throws Exception

Gets the user defined type as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the user defined type as text

Throws:

Exception - in case of any error

getUserTypes

public DataSet getUserTypes(String catalog,
                            String schema,
                            String pattern,
                            String type)
                     throws Exception

Gets the user defined types.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the user defined types

Throws:

Exception - in case of any error

getVendor

public String getVendor()

Description copied from interface: ExtensionModule

Gets the vendor.

Specified by:

getVendor in interface ExtensionModule

Overrides:

getVendor in class JdbcMetadata

Returns:

the vendor

getViewAsText

public String getViewAsText(String catalog,
                            String schema,
                            String pattern,
                            String type)
                     throws Exception

Gets the view as text.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the view as text

Throws:

Exception - in case of any error

getViewMetadataTypes

public List<String> getViewMetadataTypes()

Description copied from class: JdbcMetadata

Gets the view metadata types.

Overrides:

getViewMetadataTypes in class JdbcMetadata

Returns:

the view metadata types

getViews

public DataSet getViews(String catalog,
                        String schema,
                        String pattern)
                 throws Exception

Gets the views.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

Returns:

the views

Throws:

Exception - in case of any error

getXmlSchemas

public DataSet getXmlSchemas(String catalog,
                             String schema,
                             String pattern,
                             String type)
                      throws Exception

Gets the xml schemas.

Parameters:

catalog - the catalog

schema - the schema

pattern - the pattern

type - the type

Returns:

the xml schemas

Throws:

Exception - in case of any error

needToPopulate

public boolean needToPopulate(String type)

Description copied from interface: Metadata

Checks if metadata node needs to be populatet.

Specified by:

needToPopulate in interface Metadata

Overrides:

needToPopulate in class JdbcMetadata

Parameters:

type - the type

Returns:

true, if successful

searchDatabase

public DataSet searchDatabase(DatabaseFilter filter)
                       throws Exception

Description copied from interface: Metadata

Search database objects.

Specified by:

searchDatabase in interface Metadata

Overrides:

searchDatabase in class BaseMetadata

Parameters:

filter - the search filter

Returns:

the data set

Throws:

Exception - in case of any error

supportsAsText

public boolean supportsAsText(String type)

Description copied from interface: Metadata

Checks if metadata driver supports asText method for the type.

Specified by:

supportsAsText in interface Metadata

Overrides:

supportsAsText in class JdbcMetadata

Parameters:

type - the type

Returns:

true, if successful

supportsExecute

public boolean supportsExecute(String type)

Description copied from interface: Metadata

Checks if metadata driver supports executeAsText method for the type.

Specified by:

supportsExecute in interface Metadata

Overrides:

supportsExecute in class JdbcMetadata

Parameters:

type - the type

Returns:

true, if successful

supportsSearchDatabase

public boolean supportsSearchDatabase()

Description copied from interface: Metadata

Checks if metadata driver supports search database.

Specified by:

supportsSearchDatabase in interface Metadata

Overrides:

supportsSearchDatabase in class BaseMetadata

Returns:

true, if successful