Package org.odpi.openmetadata.adapters.connectors.integration.jdbc.transfer

Class JdbcMetadata

java.lang.Object

org.odpi.openmetadata.adapters.connectors.integration.jdbc.transfer.JdbcMetadata

public class JdbcMetadata
extends Object

JDBCResourceConnector works exclusively with JDBC API to retrieve metadata. It internally manages the connection but specific calls to open and close the connection are needed, and in some cases converts the result into specific objects.

Generic use case is: connector.open() // connector usage connector.getSchemas() // more connector usage connector.close()

Constructor Summary

Constructors

Constructor	Description
JdbcMetadata(DatabaseMetaData databaseMetaData)

Method Summary

Modifier and Type	Method	Description
List<JdbcCatalog>	getCatalogs()
List<JdbcColumn>	getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
String	getDatabaseProductName()
String	getDatabaseProductVersion()
String	getDriverName()
List<JdbcForeignKey>	getExportedKeys(String catalog, String schema, String table)
List<JdbcForeignKey>	getImportedKeys(String catalog, String schema, String table)
List<JdbcPrimaryKey>	getPrimaryKeys(String catalog, String schema, String table)
List<JdbcSchema>	getSchemas()
List<JdbcSchema>	getSchemas(String catalog, String schemaPattern)
List<JdbcTable>	getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
List<String>	getTableTypes()
String	getUrl()
String	getUserName()

Methods inherited from class java.lang.Object

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

Constructor Details

JdbcMetadata

public JdbcMetadata(DatabaseMetaData databaseMetaData)

Method Details

getUserName

public String getUserName()
                   throws SQLException

Throws:

SQLException

getDriverName

public String getDriverName()
                     throws SQLException

Throws:

SQLException

getDatabaseProductName

public String getDatabaseProductName()
                              throws SQLException

Throws:

SQLException

getUrl

public String getUrl()
              throws SQLException

Throws:

SQLException

getDatabaseProductVersion

public String getDatabaseProductVersion()
                                 throws SQLException

Throws:

SQLException

getTableTypes

public List<String> getTableTypes()
                           throws SQLException

Throws:

SQLException

getPrimaryKeys

public List<JdbcPrimaryKey> getPrimaryKeys(String catalog,
 String schema,
 String table)
                                    throws SQLException

Throws:

SQLException

getImportedKeys

public List<JdbcForeignKey> getImportedKeys(String catalog,
 String schema,
 String table)
                                     throws SQLException

Throws:

SQLException

getExportedKeys

public List<JdbcForeignKey> getExportedKeys(String catalog,
 String schema,
 String table)
                                     throws SQLException

Throws:

SQLException

getColumns

public List<JdbcColumn> getColumns(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String columnNamePattern)
                            throws SQLException

Throws:

SQLException

getTables

public List<JdbcTable> getTables(String catalog,
 String schemaPattern,
 String tableNamePattern,
 String[] types)
                          throws SQLException

Throws:

SQLException

getSchemas

public List<JdbcSchema> getSchemas(String catalog,
 String schemaPattern)
                            throws SQLException

Throws:

SQLException

getSchemas

public List<JdbcSchema> getSchemas()
                            throws SQLException

Throws:

SQLException

getCatalogs

public List<JdbcCatalog> getCatalogs()
                              throws SQLException

Throws:

SQLException