public class MariaDbDatabaseMetaData extends Object implements DatabaseMetaData
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, functionColumnIn, functionColumnInOut, functionColumnOut, functionColumnResult, functionColumnUnknown, functionNoNulls, functionNoTable, functionNullable, functionNullableUnknown, functionResultUnknown, functionReturn, functionReturnsTable, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
Constructor and Description |
---|
MariaDbDatabaseMetaData(Connection connection,
String user,
String url)
Constructor.
|
Modifier and Type | Method and Description |
---|---|
boolean |
allProceduresAreCallable() |
boolean |
allTablesAreSelectable() |
boolean |
autoCommitFailureClosesAllResultSets() |
boolean |
dataDefinitionCausesTransactionCommit() |
boolean |
dataDefinitionIgnoredInTransactions() |
boolean |
deletesAreDetected(int type) |
boolean |
doesMaxRowSizeIncludeBlobs() |
boolean |
generatedKeyAlwaysReturned() |
ResultSet |
getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and
catalog.
|
ResultSet |
getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
|
ResultSet |
getCatalogs() |
String |
getCatalogSeparator() |
String |
getCatalogTerm() |
ResultSet |
getClientInfoProperties() |
ResultSet |
getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Retrieves a description of the access rights for a table's columns.
|
ResultSet |
getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Retrieves a description of table columns available in the specified catalog.
|
Connection |
getConnection() |
ResultSet |
getCrossReference(String parentCatalog,
String parentSchema,
String parentTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a
unique constraint of the parent table (could be the same or a different table).
|
int |
getDatabaseMajorVersion() |
int |
getDatabaseMinorVersion() |
String |
getDatabaseProductName() |
String |
getDatabaseProductVersion() |
int |
getDefaultTransactionIsolation() |
int |
getDriverMajorVersion() |
int |
getDriverMinorVersion() |
String |
getDriverName() |
String |
getDriverVersion() |
ResultSet |
getExportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
|
String |
getExtraNameCharacters() |
ResultSet |
getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's system or user function parameters and return type.
|
ResultSet |
getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
Retrieves a description of the system and user functions available in the given catalog.
|
String |
getIdentifierQuoteString() |
ResultSet |
getImportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a
table).
|
static ResultSet |
getImportedKeys(String tableDef,
String tableName,
String catalog,
MariaDbConnection connection)
Get imported keys.
|
ResultSet |
getImportedKeysUsingInformationSchema(String catalog,
String schema,
String table)
GetImportedKeysUsingInformationSchema.
|
ResultSet |
getImportedKeysUsingShowCreateTable(String catalog,
String schema,
String table)
GetImportedKeysUsingShowCreateTable.
|
ResultSet |
getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Retrieves a description of the given table's indices and statistics.
|
int |
getJDBCMajorVersion() |
int |
getJDBCMinorVersion() |
int |
getMaxBinaryLiteralLength() |
int |
getMaxCatalogNameLength() |
int |
getMaxCharLiteralLength() |
int |
getMaxColumnNameLength() |
int |
getMaxColumnsInGroupBy() |
int |
getMaxColumnsInIndex() |
int |
getMaxColumnsInOrderBy() |
int |
getMaxColumnsInSelect() |
int |
getMaxColumnsInTable() |
int |
getMaxConnections() |
int |
getMaxCursorNameLength() |
int |
getMaxIndexLength() |
int |
getMaxProcedureNameLength() |
int |
getMaxRowSize() |
int |
getMaxSchemaNameLength() |
int |
getMaxStatementLength() |
int |
getMaxStatements() |
int |
getMaxTableNameLength() |
int |
getMaxTablesInSelect() |
int |
getMaxUserNameLength() |
String |
getNumericFunctions() |
ResultSet |
getPrimaryKeys(String catalog,
String schema,
String table)
Retrieves a description of the given table's primary key columns.
|
ResultSet |
getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's stored procedure parameter and result columns.
|
ResultSet |
getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
Retrieves a description of the stored procedures available in the given catalog.
|
String |
getProcedureTerm() |
ResultSet |
getPseudoColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.
|
int |
getResultSetHoldability() |
RowIdLifetime |
getRowIdLifetime() |
ResultSet |
getSchemas() |
ResultSet |
getSchemas(String catalog,
String schemaPattern) |
String |
getSchemaTerm() |
String |
getSearchStringEscape() |
String |
getSQLKeywords()
Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.
|
int |
getSQLStateType() |
String |
getStringFunctions() |
ResultSet |
getSuperTables(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular schema in this database.
|
ResultSet |
getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
|
String |
getSystemFunctions() |
ResultSet |
getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the access rights for each table available in a catalog.
|
ResultSet |
getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
Retrieves a description of the tables available in the given catalog.
|
ResultSet |
getTableTypes() |
String |
getTimeDateFunctions() |
ResultSet |
getTypeInfo()
Retrieves a description of all the data types supported by this database.
|
ResultSet |
getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
|
String |
getURL() |
String |
getUserName() |
ResultSet |
getVersionColumns(String catalog,
String schema,
String table)
Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
|
boolean |
insertsAreDetected(int type) |
boolean |
isCatalogAtStart() |
boolean |
isReadOnly() |
boolean |
isWrapperFor(Class<?> iface) |
boolean |
locatorsUpdateCopy() |
boolean |
nullPlusNonNullIsNull() |
boolean |
nullsAreSortedAtEnd() |
boolean |
nullsAreSortedAtStart() |
boolean |
nullsAreSortedHigh() |
boolean |
nullsAreSortedLow() |
boolean |
othersDeletesAreVisible(int type) |
boolean |
othersInsertsAreVisible(int type) |
boolean |
othersUpdatesAreVisible(int type) |
boolean |
ownDeletesAreVisible(int type) |
boolean |
ownInsertsAreVisible(int type) |
boolean |
ownUpdatesAreVisible(int type) |
boolean |
storesLowerCaseIdentifiers() |
boolean |
storesLowerCaseQuotedIdentifiers() |
boolean |
storesMixedCaseIdentifiers() |
boolean |
storesMixedCaseQuotedIdentifiers() |
boolean |
storesUpperCaseIdentifiers() |
boolean |
storesUpperCaseQuotedIdentifiers() |
boolean |
supportsAlterTableWithAddColumn() |
boolean |
supportsAlterTableWithDropColumn() |
boolean |
supportsANSI92EntryLevelSQL() |
boolean |
supportsANSI92FullSQL() |
boolean |
supportsANSI92IntermediateSQL() |
boolean |
supportsBatchUpdates() |
boolean |
supportsCatalogsInDataManipulation() |
boolean |
supportsCatalogsInIndexDefinitions() |
boolean |
supportsCatalogsInPrivilegeDefinitions() |
boolean |
supportsCatalogsInProcedureCalls() |
boolean |
supportsCatalogsInTableDefinitions() |
boolean |
supportsColumnAliasing() |
boolean |
supportsConvert() |
boolean |
supportsConvert(int fromType,
int toType) |
boolean |
supportsCoreSQLGrammar() |
boolean |
supportsCorrelatedSubqueries() |
boolean |
supportsDataDefinitionAndDataManipulationTransactions() |
boolean |
supportsDataManipulationTransactionsOnly() |
boolean |
supportsDifferentTableCorrelationNames() |
boolean |
supportsExpressionsInOrderBy() |
boolean |
supportsExtendedSQLGrammar() |
boolean |
supportsFullOuterJoins() |
boolean |
supportsGetGeneratedKeys() |
boolean |
supportsGroupBy() |
boolean |
supportsGroupByBeyondSelect() |
boolean |
supportsGroupByUnrelated() |
boolean |
supportsIntegrityEnhancementFacility() |
boolean |
supportsLikeEscapeClause() |
boolean |
supportsLimitedOuterJoins() |
boolean |
supportsMinimumSQLGrammar() |
boolean |
supportsMixedCaseIdentifiers() |
boolean |
supportsMixedCaseQuotedIdentifiers() |
boolean |
supportsMultipleOpenResults() |
boolean |
supportsMultipleResultSets() |
boolean |
supportsMultipleTransactions() |
boolean |
supportsNamedParameters() |
boolean |
supportsNonNullableColumns() |
boolean |
supportsOpenCursorsAcrossCommit() |
boolean |
supportsOpenCursorsAcrossRollback() |
boolean |
supportsOpenStatementsAcrossCommit() |
boolean |
supportsOpenStatementsAcrossRollback() |
boolean |
supportsOrderByUnrelated() |
boolean |
supportsOuterJoins() |
boolean |
supportsPositionedDelete() |
boolean |
supportsPositionedUpdate() |
boolean |
supportsResultSetConcurrency(int type,
int concurrency) |
boolean |
supportsResultSetHoldability(int holdability) |
boolean |
supportsResultSetType(int type) |
boolean |
supportsSavepoints() |
boolean |
supportsSchemasInDataManipulation() |
boolean |
supportsSchemasInIndexDefinitions() |
boolean |
supportsSchemasInPrivilegeDefinitions() |
boolean |
supportsSchemasInProcedureCalls() |
boolean |
supportsSchemasInTableDefinitions() |
boolean |
supportsSelectForUpdate() |
boolean |
supportsStatementPooling() |
boolean |
supportsStoredFunctionsUsingCallSyntax() |
boolean |
supportsStoredProcedures() |
boolean |
supportsSubqueriesInComparisons() |
boolean |
supportsSubqueriesInExists() |
boolean |
supportsSubqueriesInIns() |
boolean |
supportsSubqueriesInQuantifieds() |
boolean |
supportsTableCorrelationNames() |
boolean |
supportsTransactionIsolationLevel(int level)
Retrieves whether this database supports the given transaction isolation level.
|
boolean |
supportsTransactions()
Retrieves whether this database supports transactions.
|
boolean |
supportsUnion() |
boolean |
supportsUnionAll() |
<T> T |
unwrap(Class<T> iface) |
boolean |
updatesAreDetected(int type) |
boolean |
usesLocalFilePerTable() |
boolean |
usesLocalFiles() |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getMaxLogicalLobSize, supportsRefCursors
public MariaDbDatabaseMetaData(Connection connection, String user, String url)
connection
- connectionuser
- userNameurl
- connection String url.public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException
Each primary key column description has the following columns:
=>
primary key table catalog being
imported (may be null
) =>
primary key table schema being imported (may be
null
) =>
primary key table name being imported =>
primary key column name being imported =>
foreign key table catalog (may be null
)
=>
foreign key table schema (may be null
) =>
foreign key table name =>
foreign key column name =>
sequence number
within a foreign key( a value of 1 represents the first column of the foreign key, a value of 2 would represent the second column within the
foreign key). =>
What happens to a foreign key when the primary key is updated: NULL
if its primary key has been updated =>
What happens to the foreign key when primary is deleted. =>
foreign key name (may be null
) =>
primary key
name (may be null
) =>
can the evaluation of foreign key constraints be deferred until
commit getImportedKeys
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in the databaseResultSet
- each row is a primary key column descriptionSQLException
- if a database access error occursgetExportedKeys(java.lang.String, java.lang.String, java.lang.String)
public static ResultSet getImportedKeys(String tableDef, String tableName, String catalog, MariaDbConnection connection) throws ParseException
tableDef
- table definiationtableName
- table namecatalog
- catalogconnection
- connectionParseException
- exceptionpublic ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException
Each primary key column description has the following columns:
=>
table catalog (may be
null
) =>
table schema (may be null
) =>
table name =>
column name =>
sequence number within primary key( a value
of 1 represents the first column of the primary key, a value of 2 would represent the second column within the primary key). =>
primary key name (may be null
) getPrimaryKeys
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in the databaseResultSet
- each row is a primary key column descriptionSQLException
- if a database access error occurspublic ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
TABLE_TYPE
, TABLE_CAT
, TABLE_SCHEM
and
TABLE_NAME
.
Each table description has the following columns: =>
table catalog (may be null
)
=>
table schema (may be null
) =>
table name
=>
table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY",
"ALIAS", "SYNONYM". =>
explanatory comment on the table =>
the types
catalog (may be null
) =>
the types schema (may be null
) =>
type name (may be null
) =>
name of the designated
"identifier" column of a typed table (may be null
) =>
specifies how values in
SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null
) Note: Some databases may not return information for all tables.
getTables
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtableNamePattern
- a table name pattern; must match the table name as it is stored in the databasetypes
- a list of table types, which must be from the list of table types returned from getTableTypes()
,to include;
null
returns all typesResultSet
- each row is a table descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by
TABLE_CAT
,TABLE_SCHEM
, TABLE_NAME
, and ORDINAL_POSITION
.
Each column description has the following columns:
=>
table catalog (may be null
)
=>
table schema (may be null
) =>
table name
=>
column name =>
SQL type from java.sql.Types =>
Data source dependent type name, for a UDT the type name is fully qualified =>
column
size. =>
the number of fractional digits. Null is returned for data
types where DECIMAL_DIGITS is not applicable. =>
Radix (typically either 10 or 2) =>
is NULL allowed. NULL
values NULL
values =>
comment describing column
(may be null
) =>
default value for the column, which should be interpreted as a string when
the value is enclosed in single quotes (may be null
) =>
unused =>
unused =>
for char types the maximum number of bytes in the column
=>
index of column in table (starting at 1) =>
ISO rules are
used to determine the nullability for a column. =>
catalog of table that is the scope of a reference attribute (null
if DATA_TYPE isn't REF) =>
schema of table that is the scope of a reference attribute (null
if the DATA_TYPE isn't REF) =>
table name that this the scope of a reference attribute (null
if the DATA_TYPE isn't REF)
=>
source type of a distinct type or user-generated Ref type, SQL type from java.sql.Types
(null
if DATA_TYPE isn't DISTINCT or user-generated REF) =>
Indicates whether this
column is auto incremented =>
Indicates whether this is a generated column The COLUMN_SIZE column specifies the column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getColumns
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtableNamePattern
- a table name pattern; must match the table name as it is stored in the databasecolumnNamePattern
- a column name pattern; must match the column name as it is stored in the databaseResultSet
- each row is a column descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException
Each foreign key column description has the following columns:
=>
primary key table catalog (may
be null
) =>
primary key table schema (may be null
) =>
primary key table name =>
primary key column name =>
foreign key table catalog (may be null
) being exported (may be null
) =>
foreign key table schema (may be null
) being exported (may be null
) =>
foreign key table name being exported =>
foreign key column name being exported =>
sequence number within foreign key( a value of 1 represents the first column of the foreign key, a value of 2 would represent
the second column within the foreign key). =>
What happens to foreign key when primary is updated: NULL
if its primary key has been updated =>
What happens to the foreign key when primary is
deleted. NULL
if its primary key has been deleted =>
foreign key name (may be null
) =>
primary key name (may be null
) =>
can the evaluation of foreign key
constraints be deferred until commit getExportedKeys
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in this database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in this databaseResultSet
object in which each row is a foreign key column descriptionSQLException
- if a database access error occursgetImportedKeys(java.lang.String, java.lang.String, java.lang.String)
public ResultSet getImportedKeysUsingInformationSchema(String catalog, String schema, String table) throws SQLException
catalog
- catalogschema
- schematable
- tableSQLException
- exceptionpublic ResultSet getImportedKeysUsingShowCreateTable(String catalog, String schema, String table) throws Exception
catalog
- catalogschema
- schematable
- tableSQLException
- exceptionException
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
Each column description has the following columns:
=>
actual scope of result =>
column name =>
SQL data type from
java.sql.Types =>
Data source dependent type name, for a UDT the type name is fully qualified
=>
precision =>
not used =>
scale - Null is returned for data types where DECIMAL_DIGITS is not applicable. =>
is this a pseudo
column like an Oracle ROWID The COLUMN_SIZE column represents the specified column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getBestRowIdentifier
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in the databasescope
- the scope of interest; use same values as SCOPEnullable
- include columns that are nullable.ResultSet
- each row is a column descriptionSQLException
- if a database access error occurspublic boolean generatedKeyAlwaysReturned() throws SQLException
generatedKeyAlwaysReturned
in interface DatabaseMetaData
SQLException
public ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by
TABLE_CAT
,TABLE_SCHEM
, TABLE_NAME
and COLUMN_NAME
.
Each column description has the following columns:
=>
table catalog (may be null
)
=>
table schema (may be null
) =>
table name
=>
column name =>
SQL type from java.sql.Types =>
column size. =>
the number of fractional digits. Null is returned for data types where
DECIMAL_DIGITS is not applicable. =>
Radix (typically either 10 or 2) =>
The allowed usage for the column. The value returned will correspond to the enum name returned by PseudoColumnUsage.name()
=>
comment describing column (may be null
)
=>
for char types the maximum number of bytes in the column =>
ISO rules are used to determine the nullability for a column. The COLUMN_SIZE column specifies the column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getPseudoColumns
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtableNamePattern
- a table name pattern; must match the table name as it is stored in the databasecolumnNamePattern
- a column name pattern; must match the column name as it is stored in the databaseResultSet
- each row is a column descriptionSQLException
- if a database access error occursPseudoColumnUsage
public boolean allProceduresAreCallable() throws SQLException
allProceduresAreCallable
in interface DatabaseMetaData
SQLException
public boolean allTablesAreSelectable() throws SQLException
allTablesAreSelectable
in interface DatabaseMetaData
SQLException
public String getURL() throws SQLException
getURL
in interface DatabaseMetaData
SQLException
public String getUserName() throws SQLException
getUserName
in interface DatabaseMetaData
SQLException
public boolean isReadOnly() throws SQLException
isReadOnly
in interface DatabaseMetaData
SQLException
public boolean nullsAreSortedHigh() throws SQLException
nullsAreSortedHigh
in interface DatabaseMetaData
SQLException
public boolean nullsAreSortedLow() throws SQLException
nullsAreSortedLow
in interface DatabaseMetaData
SQLException
public boolean nullsAreSortedAtStart() throws SQLException
nullsAreSortedAtStart
in interface DatabaseMetaData
SQLException
public boolean nullsAreSortedAtEnd() throws SQLException
nullsAreSortedAtEnd
in interface DatabaseMetaData
SQLException
public String getDatabaseProductName() throws SQLException
getDatabaseProductName
in interface DatabaseMetaData
SQLException
public String getDatabaseProductVersion() throws SQLException
getDatabaseProductVersion
in interface DatabaseMetaData
SQLException
public String getDriverName() throws SQLException
getDriverName
in interface DatabaseMetaData
SQLException
public String getDriverVersion() throws SQLException
getDriverVersion
in interface DatabaseMetaData
SQLException
public int getDriverMajorVersion()
getDriverMajorVersion
in interface DatabaseMetaData
public int getDriverMinorVersion()
getDriverMinorVersion
in interface DatabaseMetaData
public boolean usesLocalFiles() throws SQLException
usesLocalFiles
in interface DatabaseMetaData
SQLException
public boolean usesLocalFilePerTable() throws SQLException
usesLocalFilePerTable
in interface DatabaseMetaData
SQLException
public boolean supportsMixedCaseIdentifiers() throws SQLException
supportsMixedCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesUpperCaseIdentifiers() throws SQLException
storesUpperCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesLowerCaseIdentifiers() throws SQLException
storesLowerCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesMixedCaseIdentifiers() throws SQLException
storesMixedCaseIdentifiers
in interface DatabaseMetaData
SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
supportsMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
storesUpperCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
storesLowerCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
storesMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
SQLException
public String getIdentifierQuoteString() throws SQLException
getIdentifierQuoteString
in interface DatabaseMetaData
SQLException
public String getSQLKeywords() throws SQLException
getSQLKeywords
in interface DatabaseMetaData
SQLException
- if a database access error occurspublic String getNumericFunctions() throws SQLException
getNumericFunctions
in interface DatabaseMetaData
SQLException
public String getStringFunctions() throws SQLException
getStringFunctions
in interface DatabaseMetaData
SQLException
public String getSystemFunctions() throws SQLException
getSystemFunctions
in interface DatabaseMetaData
SQLException
public String getTimeDateFunctions() throws SQLException
getTimeDateFunctions
in interface DatabaseMetaData
SQLException
public String getSearchStringEscape() throws SQLException
getSearchStringEscape
in interface DatabaseMetaData
SQLException
public String getExtraNameCharacters() throws SQLException
getExtraNameCharacters
in interface DatabaseMetaData
SQLException
public boolean supportsAlterTableWithAddColumn() throws SQLException
supportsAlterTableWithAddColumn
in interface DatabaseMetaData
SQLException
public boolean supportsAlterTableWithDropColumn() throws SQLException
supportsAlterTableWithDropColumn
in interface DatabaseMetaData
SQLException
public boolean supportsColumnAliasing() throws SQLException
supportsColumnAliasing
in interface DatabaseMetaData
SQLException
public boolean nullPlusNonNullIsNull() throws SQLException
nullPlusNonNullIsNull
in interface DatabaseMetaData
SQLException
public boolean supportsConvert() throws SQLException
supportsConvert
in interface DatabaseMetaData
SQLException
public boolean supportsConvert(int fromType, int toType) throws SQLException
supportsConvert
in interface DatabaseMetaData
SQLException
public boolean supportsTableCorrelationNames() throws SQLException
supportsTableCorrelationNames
in interface DatabaseMetaData
SQLException
public boolean supportsDifferentTableCorrelationNames() throws SQLException
supportsDifferentTableCorrelationNames
in interface DatabaseMetaData
SQLException
public boolean supportsExpressionsInOrderBy() throws SQLException
supportsExpressionsInOrderBy
in interface DatabaseMetaData
SQLException
public boolean supportsOrderByUnrelated() throws SQLException
supportsOrderByUnrelated
in interface DatabaseMetaData
SQLException
public boolean supportsGroupBy() throws SQLException
supportsGroupBy
in interface DatabaseMetaData
SQLException
public boolean supportsGroupByUnrelated() throws SQLException
supportsGroupByUnrelated
in interface DatabaseMetaData
SQLException
public boolean supportsGroupByBeyondSelect() throws SQLException
supportsGroupByBeyondSelect
in interface DatabaseMetaData
SQLException
public boolean supportsLikeEscapeClause() throws SQLException
supportsLikeEscapeClause
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleResultSets() throws SQLException
supportsMultipleResultSets
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleTransactions() throws SQLException
supportsMultipleTransactions
in interface DatabaseMetaData
SQLException
public boolean supportsNonNullableColumns() throws SQLException
supportsNonNullableColumns
in interface DatabaseMetaData
SQLException
public boolean supportsMinimumSQLGrammar() throws SQLException
supportsMinimumSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsCoreSQLGrammar() throws SQLException
supportsCoreSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsExtendedSQLGrammar() throws SQLException
supportsExtendedSQLGrammar
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92EntryLevelSQL() throws SQLException
supportsANSI92EntryLevelSQL
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92IntermediateSQL() throws SQLException
supportsANSI92IntermediateSQL
in interface DatabaseMetaData
SQLException
public boolean supportsANSI92FullSQL() throws SQLException
supportsANSI92FullSQL
in interface DatabaseMetaData
SQLException
public boolean supportsIntegrityEnhancementFacility() throws SQLException
supportsIntegrityEnhancementFacility
in interface DatabaseMetaData
SQLException
public boolean supportsOuterJoins() throws SQLException
supportsOuterJoins
in interface DatabaseMetaData
SQLException
public boolean supportsFullOuterJoins() throws SQLException
supportsFullOuterJoins
in interface DatabaseMetaData
SQLException
public boolean supportsLimitedOuterJoins() throws SQLException
supportsLimitedOuterJoins
in interface DatabaseMetaData
SQLException
public String getSchemaTerm() throws SQLException
getSchemaTerm
in interface DatabaseMetaData
SQLException
public String getProcedureTerm() throws SQLException
getProcedureTerm
in interface DatabaseMetaData
SQLException
public String getCatalogTerm() throws SQLException
getCatalogTerm
in interface DatabaseMetaData
SQLException
public boolean isCatalogAtStart() throws SQLException
isCatalogAtStart
in interface DatabaseMetaData
SQLException
public String getCatalogSeparator() throws SQLException
getCatalogSeparator
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInDataManipulation() throws SQLException
supportsSchemasInDataManipulation
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInProcedureCalls() throws SQLException
supportsSchemasInProcedureCalls
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInTableDefinitions() throws SQLException
supportsSchemasInTableDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInIndexDefinitions() throws SQLException
supportsSchemasInIndexDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
supportsSchemasInPrivilegeDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInDataManipulation() throws SQLException
supportsCatalogsInDataManipulation
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInProcedureCalls() throws SQLException
supportsCatalogsInProcedureCalls
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInTableDefinitions() throws SQLException
supportsCatalogsInTableDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInIndexDefinitions() throws SQLException
supportsCatalogsInIndexDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
supportsCatalogsInPrivilegeDefinitions
in interface DatabaseMetaData
SQLException
public boolean supportsPositionedDelete() throws SQLException
supportsPositionedDelete
in interface DatabaseMetaData
SQLException
public boolean supportsPositionedUpdate() throws SQLException
supportsPositionedUpdate
in interface DatabaseMetaData
SQLException
public boolean supportsSelectForUpdate() throws SQLException
supportsSelectForUpdate
in interface DatabaseMetaData
SQLException
public boolean supportsStoredProcedures() throws SQLException
supportsStoredProcedures
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInComparisons() throws SQLException
supportsSubqueriesInComparisons
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInExists() throws SQLException
supportsSubqueriesInExists
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInIns() throws SQLException
supportsSubqueriesInIns
in interface DatabaseMetaData
SQLException
public boolean supportsSubqueriesInQuantifieds() throws SQLException
supportsSubqueriesInQuantifieds
in interface DatabaseMetaData
SQLException
public boolean supportsCorrelatedSubqueries() throws SQLException
supportsCorrelatedSubqueries
in interface DatabaseMetaData
SQLException
public boolean supportsUnion() throws SQLException
supportsUnion
in interface DatabaseMetaData
SQLException
public boolean supportsUnionAll() throws SQLException
supportsUnionAll
in interface DatabaseMetaData
SQLException
public boolean supportsOpenCursorsAcrossCommit() throws SQLException
supportsOpenCursorsAcrossCommit
in interface DatabaseMetaData
SQLException
public boolean supportsOpenCursorsAcrossRollback() throws SQLException
supportsOpenCursorsAcrossRollback
in interface DatabaseMetaData
SQLException
public boolean supportsOpenStatementsAcrossCommit() throws SQLException
supportsOpenStatementsAcrossCommit
in interface DatabaseMetaData
SQLException
public boolean supportsOpenStatementsAcrossRollback() throws SQLException
supportsOpenStatementsAcrossRollback
in interface DatabaseMetaData
SQLException
public int getMaxBinaryLiteralLength() throws SQLException
getMaxBinaryLiteralLength
in interface DatabaseMetaData
SQLException
public int getMaxCharLiteralLength() throws SQLException
getMaxCharLiteralLength
in interface DatabaseMetaData
SQLException
public int getMaxColumnNameLength() throws SQLException
getMaxColumnNameLength
in interface DatabaseMetaData
SQLException
public int getMaxColumnsInGroupBy() throws SQLException
getMaxColumnsInGroupBy
in interface DatabaseMetaData
SQLException
public int getMaxColumnsInIndex() throws SQLException
getMaxColumnsInIndex
in interface DatabaseMetaData
SQLException
public int getMaxColumnsInOrderBy() throws SQLException
getMaxColumnsInOrderBy
in interface DatabaseMetaData
SQLException
public int getMaxColumnsInSelect() throws SQLException
getMaxColumnsInSelect
in interface DatabaseMetaData
SQLException
public int getMaxColumnsInTable() throws SQLException
getMaxColumnsInTable
in interface DatabaseMetaData
SQLException
public int getMaxConnections() throws SQLException
getMaxConnections
in interface DatabaseMetaData
SQLException
public int getMaxCursorNameLength() throws SQLException
getMaxCursorNameLength
in interface DatabaseMetaData
SQLException
public int getMaxIndexLength() throws SQLException
getMaxIndexLength
in interface DatabaseMetaData
SQLException
public int getMaxSchemaNameLength() throws SQLException
getMaxSchemaNameLength
in interface DatabaseMetaData
SQLException
public int getMaxProcedureNameLength() throws SQLException
getMaxProcedureNameLength
in interface DatabaseMetaData
SQLException
public int getMaxCatalogNameLength() throws SQLException
getMaxCatalogNameLength
in interface DatabaseMetaData
SQLException
public int getMaxRowSize() throws SQLException
getMaxRowSize
in interface DatabaseMetaData
SQLException
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
doesMaxRowSizeIncludeBlobs
in interface DatabaseMetaData
SQLException
public int getMaxStatementLength() throws SQLException
getMaxStatementLength
in interface DatabaseMetaData
SQLException
public int getMaxStatements() throws SQLException
getMaxStatements
in interface DatabaseMetaData
SQLException
public int getMaxTableNameLength() throws SQLException
getMaxTableNameLength
in interface DatabaseMetaData
SQLException
public int getMaxTablesInSelect() throws SQLException
getMaxTablesInSelect
in interface DatabaseMetaData
SQLException
public int getMaxUserNameLength() throws SQLException
getMaxUserNameLength
in interface DatabaseMetaData
SQLException
public int getDefaultTransactionIsolation() throws SQLException
getDefaultTransactionIsolation
in interface DatabaseMetaData
SQLException
public boolean supportsTransactions() throws SQLException
commit
is a noop, and the isolation level is
TRANSACTION_NONE
.supportsTransactions
in interface DatabaseMetaData
true
if transactions are supported; false
otherwiseSQLException
- if a database access error occurspublic boolean supportsTransactionIsolationLevel(int level) throws SQLException
supportsTransactionIsolationLevel
in interface DatabaseMetaData
level
- one of the transaction isolation levels defined in java.sql.Connection
true
if so; false
otherwiseSQLException
- if a database access error occursConnection
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
supportsDataDefinitionAndDataManipulationTransactions
in interface DatabaseMetaData
SQLException
public boolean supportsDataManipulationTransactionsOnly() throws SQLException
supportsDataManipulationTransactionsOnly
in interface DatabaseMetaData
SQLException
public boolean dataDefinitionCausesTransactionCommit() throws SQLException
dataDefinitionCausesTransactionCommit
in interface DatabaseMetaData
SQLException
public boolean dataDefinitionIgnoredInTransactions() throws SQLException
dataDefinitionIgnoredInTransactions
in interface DatabaseMetaData
SQLException
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
PROCEDURE_CAT
,
PROCEDURE_SCHEM
, PROCEDURE_NAME
and SPECIFIC_ NAME
.
Each procedure description has the the following columns:
=>
procedure catalog (may be
null
) =>
procedure schema (may be null
) =>
procedure name =>
explanatory comment on the procedure =>
kind of procedure: =>
The name which uniquely identifies this procedure within its schema.
getProcedures
getProcedures
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchprocedureNamePattern
- a procedure name pattern; must match the procedure name as it is stored in the databaseResultSet
- each row is a procedure descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME and SPECIFIC_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description or column description with the following fields:
=>
procedure catalog (may be null
) =>
procedure
schema (may be null
) =>
procedure name =>
column/parameter name =>
kind of column/parameter: ResultSet
=>
SQL
type from java.sql.Types =>
SQL type name, for a UDT type the type name is fully qualified
=>
precision =>
length in bytes of data =>
scale
- null is returned for data types where SCALE is not applicable. =>
radix =>
can it contain NULL. =>
comment describing parameter/column
=>
default value for the column, which should be interpreted as a string when the value is enclosed in
single quotes (may be null
) =>
reserved for future use =>
reserved for future use =>
the maximum length of binary and character based columns. For any other
datatype the returned value is a NULL =>
the ordinal position, starting from 1, for the input and
output parameters for a procedure. A value of 0 is returned if this row describes the procedure's return value. For result set columns, it is
the ordinal position of the column in the result set starting from 1. If there are multiple result sets, the column ordinal positions are
implementation defined. =>
ISO rules are used to determine the nullability for a column. =>
the name which uniquely identifies this procedure within its schema. Note: Some databases may not return the column descriptions for a procedure.
The PRECISION column represents the specified column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getProcedureColumns
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchprocedureNamePattern
- a procedure name pattern; must match the procedure name as it is stored in the databasecolumnNamePattern
- a column name pattern; must match the column name as it is stored in the databaseResultSet
- each row describes a stored procedure parameter or columnSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException
Only descriptions matching the schema, function and parameter name criteria are returned. They are ordered by FUNCTION_CAT
,
FUNCTION_SCHEM
, FUNCTION_NAME
and SPECIFIC_ NAME
. Within this, the return value, if any, is first. Next
are the parameter descriptions in call order. The column descriptions follow in column number order.
Each row in the ResultSet
is a parameter description, column description or return type description with the following fields:
=>
function catalog (may be null
) =>
function
schema (may be null
) =>
function name. This is the name used to invoke the function
=>
column/parameter name =>
kind of column/parameter: ResultSet
=>
SQL type from java.sql.Types =>
SQL
type name, for a UDT type the type name is fully qualified =>
precision =>
length in bytes of data =>
scale - null is returned for data types where SCALE is not applicable.
=>
radix =>
can it contain NULL. =>
comment describing column/parameter =>
the maximum length of binary and character based
parameters or columns. For any other datatype the returned value is a NULL =>
the ordinal position,
starting from 1, for the input and output parameters. A value of 0 is returned if this row describes the function's return value. For result
set columns, it is the ordinal position of the column in the result set starting from 1. =>
ISO rules
are used to determine the nullability for a parameter or column. =>
the name which uniquely identifies this function within its schema. This is a user
specified, or DBMS generated, name that may be different then the FUNCTION_NAME
for example with overload functions The PRECISION column represents the specified column size for the given parameter or column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getFunctionColumns
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchfunctionNamePattern
- a procedure name pattern; must match the function name as it is stored in the databasecolumnNamePattern
- a parameter name pattern; must match the parameter or column name as it is stored in the databaseResultSet
- each row describes a user function parameter, column or return typeSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getSchemas() throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException
getSchemas
in interface DatabaseMetaData
SQLException
public ResultSet getCatalogs() throws SQLException
getCatalogs
in interface DatabaseMetaData
SQLException
public ResultSet getTableTypes() throws SQLException
getTableTypes
in interface DatabaseMetaData
SQLException
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilege description has the following columns:
=>
table catalog (may be null
)
=>
table schema (may be null
) =>
table name
=>
column name =>
grantor of access (may be null
)
=>
grantee of access =>
name of access (SELECT, INSERT, UPDATE,
REFRENCES, ...) =>
"YES" if grantee is permitted to grant to others; "NO" if not; null
if
unknown getColumnPrivileges
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in the databasecolumnNamePattern
- a column name pattern; must match the column name as it is stored in the databaseResultSet
- each row is a column privilege descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_CAT
,
TABLE_SCHEM
, TABLE_NAME
, and PRIVILEGE
.
Each privilege description has the following columns:
=>
table catalog (may be null
)
=>
table schema (may be null
) =>
table name
=>
grantor of access (may be null
) =>
grantee of access
=>
name of access (SELECT, INSERT, UPDATE, REFRENCES, ...) =>
"YES"
if grantee is permitted to grant to others; "NO" if not; null
if unknown getTablePrivileges
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtableNamePattern
- a table name pattern; must match the table name as it is stored in the databaseResultSet
- each row is a table privilege descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException
Each column description has the following columns:
=>
is not used =>
column name =>
SQL data type from java.sql.Types
=>
Data
source-dependent type name =>
precision =>
length of column value in
bytes =>
scale - Null is returned for data types where DECIMAL_DIGITS is not applicable.
=>
whether this is pseudo column like an Oracle ROWID The COLUMN_SIZE column represents the specified column size for the given column. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getVersionColumns
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in the databaseResultSet
object in which each row is a column descriptionSQLException
- if a database access error occurspublic ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
Each foreign key column description has the following columns:
=>
parent key table catalog (may
be null
) =>
parent key table schema (may be null
) =>
parent key table name =>
parent key column name =>
foreign key table catalog (may be null
) being exported (may be null
) =>
foreign key table schema (may be null
) being exported (may be null
) =>
foreign
key table name being exported =>
foreign key column name being exported =>
sequence number within foreign key( a value of 1 represents the first column of the foreign key, a value of 2 would represent the second
column within the foreign key). =>
What happens to foreign key when parent key is updated: NULL
if its parent key has been updated =>
What happens to the foreign key when parent key is deleted. NULL
if its primary key has been deleted =>
foreign key name (may be null
) =>
parent key name
(may be null
) =>
can the evaluation of foreign key constraints be deferred until commit
getCrossReference
in interface DatabaseMetaData
parentCatalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaparentSchema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means drop schema name from the selection criteriaparentTable
- the name of the table that exports the key; must match the table name as it is stored in the databaseforeignCatalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means drop catalog name from the selection criteriaforeignSchema
- a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means drop schema name from the selection criteriaforeignTable
- the name of the table that imports the key; must match the table name as it is stored in the databaseResultSet
- each row is a foreign key column descriptionSQLException
- if a database access error occursgetImportedKeys(java.lang.String, java.lang.String, java.lang.String)
public ResultSet getTypeInfo() throws SQLException
If the database supports SQL distinct types, then getTypeInfo() will return a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of Types.DISTINCT. If the database supports SQL structured types, then getTypeInfo() will return a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT.
If SQL distinct or structured types are supported, then information on the individual types may be obtained from the getUDTs() method.
Each type description has the following columns:
=>
Type name =>
SQL data type from java.sql.Types =>
maximum precision =>
prefix used
to quote a literal (may be null
) =>
suffix used to quote a literal (may be
null
) =>
parameters used in creating the type (may be null
)
=>
can you use NULL for this type. =>
is it case sensitive.
=>
can you use "WHERE" based on this type: =>
is it unsigned. =>
can it be a money value.
=>
can it be used for an auto-increment value. =>
localized
version of type name (may be null
) =>
minimum scale supported =>
maximum scale supported =>
unused =>
unused
=>
usually 2 or 10 The PRECISION column represents the maximum column size that the server supports for the given datatype. For numeric data, this is the maximum precision. For character data, this is the length in characters. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. Null is returned for data types where the column size is not applicable.
getTypeInfo
in interface DatabaseMetaData
ResultSet
object in which each row is an SQL type descriptionSQLException
- if a database access error occurspublic ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
Each index column description has the following columns:
=>
table catalog (may be
null
)=>
table schema (may be null
)=>
table name=>
Can index values be non-unique. false when TYPE is tableIndexStatistic=>
index catalog (may be null
); null
when TYPE is tableIndexStatistic=>
index name; null
when TYPE is tableIndexStatistic=>
index type: =>
column sequence number within index; zero when TYPE is
tableIndexStatistic=>
column name; null
when TYPE is tableIndexStatistic=>
column sort sequence, "A" =>
ascending, "D" =>
descending, may be null
if
sort sequence is not supported; null
when TYPE is tableIndexStatistic=>
When TYPE is
tableIndexStatistic, then this is the number of rows in the table; otherwise, it is the number of unique values in the index.=>
When TYPE is tableIndexStatisic then this is the number of pages used for the table, otherwise it is the
number of pages used for the current index.=>
Filter condition, if any. (may be
null
)getIndexInfo
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in this database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschema
- a schema name; must match the schema name as it is stored in this database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtable
- a table name; must match the table name as it is stored in this databaseunique
- when true, return only indices for unique values; when false, return indices regardless of whether unique or notapproximate
- when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurateResultSet
- each row is an index column descriptionSQLException
- if a database access error occurspublic boolean supportsResultSetType(int type) throws SQLException
supportsResultSetType
in interface DatabaseMetaData
SQLException
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException
supportsResultSetConcurrency
in interface DatabaseMetaData
SQLException
public boolean ownUpdatesAreVisible(int type) throws SQLException
ownUpdatesAreVisible
in interface DatabaseMetaData
SQLException
public boolean ownDeletesAreVisible(int type) throws SQLException
ownDeletesAreVisible
in interface DatabaseMetaData
SQLException
public boolean ownInsertsAreVisible(int type) throws SQLException
ownInsertsAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersUpdatesAreVisible(int type) throws SQLException
othersUpdatesAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersDeletesAreVisible(int type) throws SQLException
othersDeletesAreVisible
in interface DatabaseMetaData
SQLException
public boolean othersInsertsAreVisible(int type) throws SQLException
othersInsertsAreVisible
in interface DatabaseMetaData
SQLException
public boolean updatesAreDetected(int type) throws SQLException
updatesAreDetected
in interface DatabaseMetaData
SQLException
public boolean deletesAreDetected(int type) throws SQLException
deletesAreDetected
in interface DatabaseMetaData
SQLException
public boolean insertsAreDetected(int type) throws SQLException
insertsAreDetected
in interface DatabaseMetaData
SQLException
public boolean supportsBatchUpdates() throws SQLException
supportsBatchUpdates
in interface DatabaseMetaData
SQLException
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
JAVA_OBJECT
, STRUCT
, or DISTINCT
.
Only types matching the catalog, schema, type name and type criteria are returned. They are ordered by DATA_TYPE
,
TYPE_CAT
, TYPE_SCHEM
and TYPE_NAME
. The type name parameter may be a fully-qualified name. In this
case, the catalog and schemaPattern parameters are ignored.
Each type description has the following columns:
=>
the type's catalog (may be null
)=>
type's schema (may be null
)=>
type name=>
Java class name=>
type value defined in java.sql.Types. One of
JAVA_OBJECT, STRUCT, or DISTINCT=>
explanatory comment on the type=>
type code of the source type of a DISTINCT type or the type that implements the user-generated reference type of the
SELF_REFERENCING_COLUMN of a structured type as defined in java.sql.Types (null
if DATA_TYPE is not DISTINCT or not STRUCT with
REFERENCE_GENERATION = USER_DEFINED)Note: If the driver does not support UDTs, an empty result set is returned.
getUDTs
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema pattern name; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtypeNamePattern
- a type name pattern; must match the type name as it is stored in the database; may be a fully qualified nametypes
- a list of user-defined types (JAVA_OBJECT, STRUCT, or DISTINCT) to include; null
returns all typesResultSet
object in which each row describes a UDTSQLException
- if a database access error occursgetSearchStringEscape()
public Connection getConnection() throws SQLException
getConnection
in interface DatabaseMetaData
SQLException
public boolean supportsSavepoints() throws SQLException
supportsSavepoints
in interface DatabaseMetaData
SQLException
public boolean supportsNamedParameters() throws SQLException
supportsNamedParameters
in interface DatabaseMetaData
SQLException
public boolean supportsMultipleOpenResults() throws SQLException
supportsMultipleOpenResults
in interface DatabaseMetaData
SQLException
public boolean supportsGetGeneratedKeys() throws SQLException
supportsGetGeneratedKeys
in interface DatabaseMetaData
SQLException
public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException
ResultSet
object returned by this method describes
the designated UDT and a direct supertype. A row has the following columns: =>
the UDT's catalog (may
be null
) =>
UDT's schema (may be null
) =>
type name of the UDT =>
the direct super type's catalog (may be null
)
=>
the direct super type's schema (may be null
) =>
the direct super type's name Note: If the driver does not support type hierarchies, an empty result set is returned.
getSuperTypes
in interface DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a catalog; null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those without a schematypeNamePattern
- a UDT name pattern; may be a fully-qualified nameResultSet
object in which a row gives information about the designated UDTSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
Only supertable information for tables matching the catalog, schema and table name are returned. The table name parameter may be a fully- qualified name, in which case, the catalog and schemaPattern parameters are ignored. If a table does not have a super table, it is not listed here. Supertables have to be defined in the same catalog and schema as the sub tables. Therefore, the type description does not need to include this information for the supertable.
Each type description has the following columns:
=>
the type's catalog (may be null
)
=>
type's schema (may be null
) =>
type name
=>
the direct super type's name Note: If the driver does not support type hierarchies, an empty result set is returned.
getSuperTables
in interface DatabaseMetaData
catalog
- a catalog name; "" retrieves those without a catalog; null
means drop catalog name from the selection criteriaschemaPattern
- a schema name pattern; "" retrieves those without a schematableNamePattern
- a table name pattern; may be a fully-qualified nameResultSet
object in which each row is a type descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
TYPE_CAT
, TYPE_SCHEM
, TYPE_NAME
and ORDINAL_POSITION
. This description does not contain
inherited attributes.
The ResultSet
object that is returned has the following columns: =>
type catalog (may be
null
) =>
type schema (may be null
) =>
type
name =>
attribute name =>
attribute type SQL type from java.sql.Types
=>
Data source dependent type name. For a UDT, the type name is fully qualified. For a REF, the type
name is fully qualified and represents the target type of the reference type. =>
column size. For char or
date types this is the maximum number of characters; for numeric or decimal types this is precision. =>
the number of fractional digits. Null is returned for data types where DECIMAL_DIGITS is not applicable. =>
Radix (typically either 10 or 2) =>
whether NULL is allowed =>
comment describing column (may be null
) =>
default value (may be
null
) =>
unused =>
unused
=>
for char types the maximum number of bytes in the column =>
index of the attribute in the UDT (starting at 1) =>
ISO rules are used to determine the nullability for
a attribute. =>
catalog of table that is the
scope of a reference attribute (null
if DATA_TYPE isn't REF) =>
schema of table that is the
scope of a reference attribute (null
if DATA_TYPE isn't REF) =>
table name that is the scope
of a reference attribute (null
if the DATA_TYPE isn't REF) =>
source type of a distinct
type or user-generated Ref type,SQL type from java.sql.Types (null
if DATA_TYPE isn't DISTINCT or user-generated REF) getAttributes
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchtypeNamePattern
- a type name pattern; must match the type name as it is stored in the databaseattributeNamePattern
- an attribute name pattern; must match the attribute name as it is declared in the databaseResultSet
object in which each row is an attribute descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public boolean supportsResultSetHoldability(int holdability) throws SQLException
supportsResultSetHoldability
in interface DatabaseMetaData
SQLException
public int getResultSetHoldability() throws SQLException
getResultSetHoldability
in interface DatabaseMetaData
SQLException
public int getDatabaseMajorVersion() throws SQLException
getDatabaseMajorVersion
in interface DatabaseMetaData
SQLException
public int getDatabaseMinorVersion() throws SQLException
getDatabaseMinorVersion
in interface DatabaseMetaData
SQLException
public int getJDBCMajorVersion() throws SQLException
getJDBCMajorVersion
in interface DatabaseMetaData
SQLException
public int getJDBCMinorVersion() throws SQLException
getJDBCMinorVersion
in interface DatabaseMetaData
SQLException
public int getSQLStateType() throws SQLException
getSQLStateType
in interface DatabaseMetaData
SQLException
public boolean locatorsUpdateCopy() throws SQLException
locatorsUpdateCopy
in interface DatabaseMetaData
SQLException
public boolean supportsStatementPooling() throws SQLException
supportsStatementPooling
in interface DatabaseMetaData
SQLException
public RowIdLifetime getRowIdLifetime() throws SQLException
getRowIdLifetime
in interface DatabaseMetaData
SQLException
public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException
supportsStoredFunctionsUsingCallSyntax
in interface DatabaseMetaData
SQLException
public boolean autoCommitFailureClosesAllResultSets() throws SQLException
autoCommitFailureClosesAllResultSets
in interface DatabaseMetaData
SQLException
public ResultSet getClientInfoProperties() throws SQLException
getClientInfoProperties
in interface DatabaseMetaData
SQLException
public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException
FUNCTION_CAT
, FUNCTION_SCHEM
, FUNCTION_NAME
and SPECIFIC_ NAME
.
Each function description has the the following columns:
=>
function catalog (may be
null
) =>
function schema (may be null
) =>
function name. This is the name used to invoke the function =>
explanatory comment on the
function =>
kind of function: =>
the name which uniquely identifies this function within its schema. This is a user specified, or DBMS generated, name that
may be different then the FUNCTION_NAME
for example with overload functions getFunctions
getFunctions
in interface DatabaseMetaData
catalog
- a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog;
null
means that the catalog name should not be used to narrow the searchschemaPattern
- a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema;
null
means that the schema name should not be used to narrow the searchfunctionNamePattern
- a function name pattern; must match the function name as it is stored in the databaseResultSet
- each row is a function descriptionSQLException
- if a database access error occursgetSearchStringEscape()
public <T> T unwrap(Class<T> iface) throws SQLException
unwrap
in interface Wrapper
SQLException
public boolean isWrapperFor(Class<?> iface) throws SQLException
isWrapperFor
in interface Wrapper
SQLException
Copyright © 2016. All rights reserved.