Class Context
java.lang.Object
com.github.jinahya.database.metadata.bind.Context
A class for retrieving information from an instance of
DatabaseMetaData
.- Author:
- Jin Kwon <jinahya_at_gmail.com>
-
Method Summary
Modifier and TypeMethodDescriptiongetAttributes
(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) InvokesDatabaseMetaData.getAttributes(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.getBestRowIdentifier
(String catalog, String schema, String table, int scope, boolean nullable) InvokesDatabaseMetaData.getBestRowIdentifier(java.lang.String, java.lang.String, java.lang.String, int, boolean)
method with given arguments, and returns a list of bound values.InvokesDatabaseMetaData.getCatalogs()
method, and returns a list of bound values.InvokesDatabaseMetaData.getClientInfoProperties()
method, and returns a list of bound values.getColumnPrivileges
(String catalog, String schema, String table, String columnNamePattern) InvokesDatabaseMetaData.getColumnPrivileges(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.getColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) InvokesgetColumns(catalog, schemaPattern, * tableNamePattern, columnNamePattern)
method with given arguments, and returns a list of bound values.getCrossReference
(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) InvokesDatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.getExportedKeys
(String catalog, String schema, String table) InvokesDatabaseMetaData.getExportedKeys(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.getFunctionColumns
(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) InvokesDatabaseMetaData.getFunctionColumns(String, String, String, String)
method with specified arguments, and returns a list of bound values.getFunctions
(String catalog, String schemaPattern, String functionNamePattern) InvokesDatabaseMetaData.getFunctions(String, String, String)
method with given arguments, and returns a list of bound values.getImportedKeys
(String catalog, String schema, String table) InvokesDatabaseMetaData.getImportedKeys(String, String, String)
method with given arguments, and returns a list of bound values.getIndexInfo
(String catalog, String schema, String table, boolean unique, boolean approximate) InvokesDatabaseMetaData.getIndexInfo(String, String, String, boolean, boolean)
method with specified arguments, and returns a list of bound values.getPrimaryKeys
(String catalog, String schema, String table) InvokesDatabaseMetaData.getPrimaryKeys(String, String, String)
method with given arguments, and returns a list of bound values.getProcedureColumns
(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) InvokesDatabaseMetaData.getProcedureColumns(String, String, String, String)
method with given arguments , and returns a list of bound values.getProcedures
(String catalog, String schemaPattern, String procedureNamePattern) InvokesDatabaseMetaData.getProcedures(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a lsit of bound values.getPseudoColumns
(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) InvokesDatabaseMetaData.getPseudoColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.InvokesDatabaseMetaData.getSchemas()
method, and returns a list of bound values.getSchemas
(String catalog, String schemaPattern) InvokesDatabaseMetaData.getSchemas(String, String)
method with given arguments, and returns a list of bound values.getSuperTables
(String catalog, String schemaPattern, String tableNamePattern) InvokesDatabaseMetaData.getSuperTables(String, String, String)
method with given arguments and adds bounds values to specified collection.getSuperTypes
(String catalog, String schemaPattern, String typeNamePattern) InvokesDatabaseMetaData.getSuperTypes(String, String, String)
method with given arguments, and returns a list of bound values.getTablePrivileges
(String catalog, String schemaPattern, String tableNamePattern) InvokesDatabaseMetaData.getTablePrivileges(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.InvokesgetTables(catalog, schemaPattern, tableNamePattern, types)
method with given arguments, and returns a list of bound values.<C extends Collection<? super Table>>
CgetTables
(String catalog, String schemaPattern, String tableNamePattern, String[] types, C collection) InvokesgetTables(catalog, schemaPattern, tableNamePattern, types)
method with given arguments, and adds each bound values to specified collection.InvokesDatabaseMetaData.getTableTypes()
method, and returns a list of bound values.InvokesDatabaseMetaData.getTypeInfo()
method, and returns a list of bound values.InvokesDatabaseMetaData.getUDTs(java.lang.String, java.lang.String, java.lang.String, int[])
method with given arguments, and returns a list of bound values.getVersionColumns
(String catalog, String schema, String table) InvokesDatabaseMetaData.getVersionColumns(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.static Context
newInstance
(Connection connection) Creates a new instance from specified connection.
-
Method Details
-
newInstance
Creates a new instance from specified connection.- Parameters:
connection
- the connection.- Returns:
- a new instance.
- Throws:
SQLException
- if a database error occurs.
-
getAttributes
public List<Attribute> getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException InvokesDatabaseMetaData.getAttributes(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.typeNamePattern
- a value fortypeNamePattern
parameter.attributeNamePattern
- a value forattributeNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getBestRowIdentifier
public List<BestRowIdentifier> getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException InvokesDatabaseMetaData.getBestRowIdentifier(java.lang.String, java.lang.String, java.lang.String, int, boolean)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.scope
- a value forscope
parameter.nullable
- a value fornullable
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getCatalogs
InvokesDatabaseMetaData.getCatalogs()
method, and returns a list of bound values.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getClientInfoProperties
InvokesDatabaseMetaData.getClientInfoProperties()
method, and returns a list of bound values.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getColumnPrivileges
public List<ColumnPrivilege> getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException InvokesDatabaseMetaData.getColumnPrivileges(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.columnNamePattern
- a value forcolumnNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getColumns
public List<Column> getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException InvokesgetColumns(catalog, schemaPattern, * tableNamePattern, columnNamePattern)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.tableNamePattern
- a value fortableNameSchema
parameter.columnNamePattern
- a value forcolumnNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getCrossReference
public List<CrossReference> getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException InvokesDatabaseMetaData.getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
parentCatalog
- a value forparentCatalog
parameterparentSchema
- a value forparentSchema
parameterparentTable
- a value forparentTable
parameterforeignCatalog
- a value forforeignCatalog
parameterforeignSchema
- av value forforeignSchema
parameterforeignTable
- a value forforeignTable
parameter- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getExportedKeys
public List<ExportedKey> getExportedKeys(String catalog, String schema, String table) throws SQLException InvokesDatabaseMetaData.getExportedKeys(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getFunctions
public List<Function> getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException InvokesDatabaseMetaData.getFunctions(String, String, String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.functionNamePattern
- a value forfunctionNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getFunctionColumns
public List<FunctionColumn> getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException InvokesDatabaseMetaData.getFunctionColumns(String, String, String, String)
method with specified arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.functionNamePattern
- a value forfunctionNamePattern
parameter.columnNamePattern
- a value forcolumnNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getImportedKeys
public List<ImportedKey> getImportedKeys(String catalog, String schema, String table) throws SQLException InvokesDatabaseMetaData.getImportedKeys(String, String, String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getIndexInfo
public List<IndexInfo> getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException InvokesDatabaseMetaData.getIndexInfo(String, String, String, boolean, boolean)
method with specified arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.unique
- a value forunique
parameter.approximate
- a value forapproximate
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getPrimaryKeys
public List<PrimaryKey> getPrimaryKeys(String catalog, String schema, String table) throws SQLException InvokesDatabaseMetaData.getPrimaryKeys(String, String, String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getProcedureColumns
public List<ProcedureColumn> getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException InvokesDatabaseMetaData.getProcedureColumns(String, String, String, String)
method with given arguments , and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.procedureNamePattern
- a value forprocedureNamePattern
parameter.columnNamePattern
- a value forcolumnNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getProcedures
public List<Procedure> getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException InvokesDatabaseMetaData.getProcedures(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a lsit of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.procedureNamePattern
- a value forprocedureNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getPseudoColumns
public List<PseudoColumn> getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException InvokesDatabaseMetaData.getPseudoColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.tableNamePattern
- a value fortableNamePattern
parameter.columnNamePattern
- a value forcolumnNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getSchemas
InvokesDatabaseMetaData.getSchemas()
method, and returns a list of bound values.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getSchemas
InvokesDatabaseMetaData.getSchemas(String, String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getSuperTables
public List<SuperTable> getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException InvokesDatabaseMetaData.getSuperTables(String, String, String)
method with given arguments and adds bounds values to specified collection.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
paramter.tableNamePattern
- a value fortableNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getSuperTypes
public List<SuperType> getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException InvokesDatabaseMetaData.getSuperTypes(String, String, String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.typeNamePattern
- a value fortypeNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getTablePrivileges
public List<TablePrivilege> getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException InvokesDatabaseMetaData.getTablePrivileges(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.tableNamePattern
- a value fortableNamePattern
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getTableTypes
InvokesDatabaseMetaData.getTableTypes()
method, and returns a list of bound values.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getTables
public <C extends Collection<? super Table>> C getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types, C collection) throws SQLException InvokesgetTables(catalog, schemaPattern, tableNamePattern, types)
method with given arguments, and adds each bound values to specified collection.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.tableNamePattern
- a value fortableNamePattern
parameter.types
- a value fortypes
parameter.collection
- the collection to which bound values are added.- Returns:
- given
collection
. - Throws:
SQLException
- if a database error occurs.- See Also:
-
getTables(String, String, String, String[], Consumer)
-
getTables
public List<Table> getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException InvokesgetTables(catalog, schemaPattern, tableNamePattern, types)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parameter.tableNamePattern
- a value fortableNamePattern
parameter.types
- a value fortypes
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getTypeInfo
InvokesDatabaseMetaData.getTypeInfo()
method, and returns a list of bound values.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getUDTs
public List<UDT> getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException InvokesDatabaseMetaData.getUDTs(java.lang.String, java.lang.String, java.lang.String, int[])
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schemaPattern
- a value forschemaPattern
parametertypeNamePattern
- a value fortypeNamePattern
parameter.types
- a value fortype
parameter- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database error occurs.
-
getVersionColumns
public List<VersionColumn> getVersionColumns(String catalog, String schema, String table) throws SQLException InvokesDatabaseMetaData.getVersionColumns(java.lang.String, java.lang.String, java.lang.String)
method with given arguments, and returns a list of bound values.- Parameters:
catalog
- a value forcatalog
parameter.schema
- a value forschema
parameter.table
- a value fortable
parameter.- Returns:
- a list of bound values.
- Throws:
SQLException
- if a database access error occurs.
-