This class provides information about the database as a whole.
Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods show throw a SQLException.
Some of these methods take arguments that are String patterns. These methods all have names such as fooPattern. Within a pattern String "%" means match any substring of 0 or more characters and "_" means match any one character.
| Modifier and Type | Class and Description |
|---|---|
| protected class | DatabaseMetaData.
key type K extends Comparablevalue type V>Helper/wrapper class to provide means of sorting objects by using a sorting key. |
| protected class | DatabaseMetaData.
Helper class to provide means of comparing indexes by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION. |
| protected abstract class | |
| protected static enum | DatabaseMetaData.
Enumeration for Procedure Types |
| pack-priv class | |
| protected class | |
| protected class | |
| protected class | DatabaseMetaData.
Helper class to provide means of comparing fully qualified DB objects. |
| protected class | DatabaseMetaData.
Helper class to provide means of comparing tables by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM and TABLE_NAME. |
| protected static enum | DatabaseMetaData.
Enumeration for Table Types |
| pack-priv class | DatabaseMetaData.
Parses and represents common data type information used by various column/parameter methods. |
| Modifier and Type | Field and Description |
|---|---|
| protected JdbcConnection | conn
The connection to the database |
| protected String | database
The 'current' database name being used |
| protected RuntimeProperty | |
| private ExceptionInterceptor | |
| private static final Lock | |
| protected static final int | |
| protected static int | maxBufferSize
Default max buffer size. |
| private int | |
| private String | |
| private static final String[] | |
| private static volatile String | |
| protected RuntimeProperty | |
| protected boolean | |
| protected final String | quotedId
What character to use when quoting identifiers |
| protected ResultSetFactory | |
| protected NativeSession | |
| pack-priv static final List | |
| private static final String | SUPPORTS_FK
The table type for generic tables that support foreign keys. |
| protected static final byte[] | |
| protected static final byte[] | |
| protected boolean | |
| protected boolean | |
| protected boolean | |
| protected static final byte[] | |
| protected boolean |
| Access | Constructor and Description |
|---|---|
| protected | DatabaseMetaData(JdbcConnection
Connection object connToSet, String database name databaseToSet, ResultSetFactory resultSetFactory)Creates a new DatabaseMetaData object. |
| Modifier and Type | Method and Description |
|---|---|
| public boolean | allProceduresAreCallable()
Implements java. Retrieves whether the current user can call all the procedures
returned by the method |
| public boolean | allTablesAreSelectable()
Implements java. Retrieves whether the current user can use all the tables returned
by the method |
| public boolean | autoCommitFailureClosesAllResultSets()
Implements java. Retrieves whether a |
| protected void | convertToJdbcFunctionList(ResultSet proceduresRs, List<DatabaseMetaData.
|
| protected void | convertToJdbcProcedureList(boolean fromSelect, ResultSet proceduresRs, List<DatabaseMetaData.
|
| private Row | convertTypeDescriptorToProcedureRow(byte[] procNameAsBytes, byte[] procCatAsBytes, String paramName, boolean isOutParam, boolean isInParam, boolean isReturnParam, DatabaseMetaData.
|
| protected Field[] | |
| protected Field[] | |
| protected Field[] | |
| protected Field[] | |
| protected Field[] | |
| protected Field[] | |
| protected ColumnDefinition | |
| public boolean | dataDefinitionCausesTransactionCommit()
Implements java. Retrieves whether a data definition statement within a transaction forces the transaction to commit. |
| public boolean | dataDefinitionIgnoredInTransactions()
Implements java. Retrieves whether this database ignores a data definition statement within a transaction. |
| public boolean | deletesAreDetected(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether or not a visible row delete can be detected by
calling the method |
| public boolean | doesMaxRowSizeIncludeBlobs()
Implements java. Retrieves whether the return value for the method
|
| private int | Returns: the ending index of the parameter declaration, not including the closing ")"should be the index of the procedure body that contains the
first "(". beginIndex, String the procedure body procedureDef, String the identifier quote character in use quoteChar)Finds the end of the parameter declaration from the output of "SHOW CREATE PROCEDURE". |
| private List | Returns: the list of rows with new rows addedthe list of rows to add to rows, ResultSet the result set from 'SHOW CREATE TABLE' rs, String the database name dbName)Extracts foreign key info for one table. |
| public ResultSet | Returns: A result set that has the structure of 'show table status'the database name to extract foreign key info for dbName, String the table to extract foreign key info for tableName)Creates a result set similar enough to 'SHOW TABLE STATUS' to allow the same code to work on extracting the foreign key data |
| private int | Returns: the end of the returns clausethe function body containing the definition of the function procedureDefn, int the position of "RETURNS" in the definition positionOfReturnKeyword)Finds the end of the RETURNS clause for SQL Functions by using any of the keywords allowed after the RETURNS clause, or a label. |
| public boolean | generatedKeyAlwaysReturned()
Implements java. Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds. |
| public ResultSet | getAttributes(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha type name pattern; must match the
type name as it is stored in the database typeNamePattern, String an attribute name pattern; must match the attribute
name as it is declared in the database attributeNamePattern)Implements java. 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. |
| public ResultSet | getBestRowIdentifier(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in the database table, int the scope of interest; use same values as SCOPE scope, boolean include columns that are nullable. nullable)Implements java. Retrieves a description of a table's optimal set of columns that uniquely identifies a row. |
| private int | Returns: the DBMD constant that represents the cascade optionthe comment from 'SHOW TABLE STATUS' cascadeOptions)Parses the cascade option string and returns the DBMD constant that represents it (for deletes) Please note that in MySQL, NO ACTION is the equivalent to RESTRICT. |
| private int | Returns: the DBMD constant that represents the cascade optionthe comment from 'SHOW TABLE STATUS' cascadeOptions)Parses the cascade option string and returns the DBMD constant that represents it (for Updates). |
| public ResultSet | getCatalogs()
Implements java. Retrieves the catalog names available in this database. |
| public String | getCatalogSeparator()
Implements java. Retrieves the |
| public String | getCatalogTerm()
Implements java. Retrieves the database vendor's preferred term for "catalog". |
| public ResultSet | getClientInfoProperties()
Implements java. Retrieves a list of the client info properties that the driver supports. |
| public ResultSet | getColumnPrivileges(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name as it is
stored in the database; "" retrieves those without a schema;
schema, String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is
stored in the database table, String a column name pattern; must match the column
name as it is stored in the database columnNamePattern)Implements java. Retrieves a description of the access rights for a table's columns. |
| protected Field[] | |
| public ResultSet | getColumns(final String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, final String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, final String null means that the schema name should not be used to narrow
the searcha table name pattern; must match the
table name as it is stored in the database tableNamePattern, String a column name pattern; must match the column
name as it is stored in the database columnNamePattern)Implements java. Retrieves a description of table columns available in the specified catalog. |
| protected int | Returns: The corresponding COLUMN_TYPE as in java.sql.DatabaseMetaData.getProcedureColumns API.Indicates whether it's an output parameter. isOutParam, boolean Indicates whether it's an input parameter. isInParam, boolean Indicates whether it's a function return parameter. isReturnParam, boolean Indicates whether the column belong to a function. This argument is required for JDBC4, in which case
this method must be overridden to provide the correct functionality. forGetFunctionColumns)Determines the COLUMN_TYPE information based on parameter type (IN, OUT or INOUT) or function return parameter. |
| public Connection | getConnection()
Implements java. Retrieves the connection that produced this metadata object. |
| public ResultSet | getCrossReference(final String
a catalog name; must match the catalog name
as it is stored in the database; "" retrieves those without a
catalog; parentCatalog, final String null means drop catalog name from the selection criteriaa schema name; must match the schema name as
it is stored in the database; "" retrieves those without a schema;
parentSchema, final String null means drop schema name from the selection criteriathe name of the table that exports the key; must match
the table name as it is stored in the database parentTable, final String a catalog name; must match the catalog name as
it is stored in the database; "" retrieves those without a
catalog; foreignCatalog, final String null means drop catalog name from the selection criteriaa schema name; must match the schema name as it
is stored in the database; "" retrieves those without a schema;
foreignSchema, final String null means drop schema name from the selection criteriathe name of the table that imports the key; must match
the table name as it is stored in the database foreignTable)Implements java. 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). |
| protected String | |
| protected DatabaseMetaData. | |
| public int | getDatabaseMajorVersion()
Implements java. Retrieves the major version number of the underlying database. |
| public int | getDatabaseMinorVersion()
Implements java. Retrieves the minor version number of the underlying database. |
| public String | getDatabaseProductName()
Implements java. Retrieves the name of this database product. |
| public String | getDatabaseProductVersion()
Implements java. Retrieves the version number of this database product. |
| protected List | |
| protected List | Returns: list of database namesdatabase name pattern dbPattern)Retrieves the database names matching the dbPattern available on this server. |
| public int | getDefaultTransactionIsolation()
Implements java. Retrieves this database's default transaction isolation level. |
| public int | getDriverMajorVersion()
Implements java. Retrieves this JDBC driver's major version number. |
| public int | getDriverMinorVersion()
Implements java. Retrieves this JDBC driver's minor version number. |
| public String | getDriverName()
Implements java. Retrieves the name of this JDBC driver. |
| public String | getDriverVersion()
Implements java. Retrieves the version number of this JDBC driver as a |
| protected ExceptionInterceptor | |
| public ResultSet | getExportedKeys(String
a catalog name; must match the catalog name as it
is stored in this database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in this database table)Implements java. Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table). |
| public String | getExtraNameCharacters()
Implements java. Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). |
| protected int[] | Returns: int[] [0] = delete action, [1] = update actionthe comment from 'SHOW TABLE STATUS' commentString)Returns the DELETE and UPDATE foreign key actions from the given 'SHOW TABLE STATUS' string, with the DELETE action being the first item in the array, and the UPDATE action being the second. |
| public ResultSet | getFunctionColumns(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha procedure name pattern; must match the
function name as it is stored in the database functionNamePattern, String a parameter name pattern; must match the
parameter or column name as it is stored in the database columnNamePattern)Implements java. Retrieves a description of the given catalog's system or user function parameters and return type. |
| public ResultSet | getFunctions(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha function name pattern; must match the
function name as it is stored in the database functionNamePattern)Implements java. Retrieves a description of the system and user functions available in the given catalog. |
| protected Field[] | |
| public String | getIdentifierQuoteString()
Implements java. Retrieves the string used to quote SQL identifiers. |
| public ResultSet | getImportedKeys(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in the database table)Implements java. 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). |
| public ResultSet | getIndexInfo(String
a catalog name; must match the catalog name as it
is stored in this database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in this database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in this database table, final boolean when true, return only indices for unique values;
when false, return indices regardless of whether unique or not unique, boolean when true, result is allowed to reflect approximate
or out of data values; when false, results are requested to be
accurate approximate)Implements java. Retrieves a description of the given table's indices and statistics. |
| protected static DatabaseMetaData | getInstance(JdbcConnection connToSet, String databaseToSet, boolean checkForInfoSchema, ResultSetFactory resultSetFactory)
|
| public int | getJDBCMajorVersion()
Implements java. Retrieves the major JDBC version number for this driver. |
| public int | getJDBCMinorVersion()
Implements java. Retrieves the minor JDBC version number for this driver. |
| public int | getMaxBinaryLiteralLength()
Implements java. Retrieves the maximum number of hex characters this database allows in an inline binary literal. |
| public int | getMaxCatalogNameLength()
Implements java. Retrieves the maximum number of characters that this database allows in a catalog name. |
| public int | getMaxCharLiteralLength()
Implements java. Retrieves the maximum number of characters this database allows for a character literal. |
| public int | getMaxColumnNameLength()
Implements java. Retrieves the maximum number of characters this database allows for a column name. |
| public int | getMaxColumnsInGroupBy()
Implements java. Retrieves the maximum number of columns this database allows in a
|
| public int | getMaxColumnsInIndex()
Implements java. Retrieves the maximum number of columns this database allows in an index. |
| public int | getMaxColumnsInOrderBy()
Implements java. Retrieves the maximum number of columns this database allows in an
|
| public int | getMaxColumnsInSelect()
Implements java. Retrieves the maximum number of columns this database allows in a
|
| public int | getMaxColumnsInTable()
Implements java. Retrieves the maximum number of columns this database allows in a table. |
| public int | getMaxConnections()
Implements java. Retrieves the maximum number of concurrent connections to this database that are possible. |
| public int | getMaxCursorNameLength()
Implements java. Retrieves the maximum number of characters that this database allows in a cursor name. |
| public int | getMaxIndexLength()
Implements java. Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index. |
| public int | getMaxProcedureNameLength()
Implements java. Retrieves the maximum number of characters that this database allows in a procedure name. |
| public int | getMaxRowSize()
Implements java. Retrieves the maximum number of bytes this database allows in a single row. |
| public int | getMaxSchemaNameLength()
Implements java. Retrieves the maximum number of characters that this database allows in a schema name. |
| public int | getMaxStatementLength()
Implements java. Retrieves the maximum number of characters this database allows in an SQL statement. |
| public int | getMaxStatements()
Implements java. Retrieves the maximum number of active statements to this database that can be open at the same time. |
| public int | getMaxTableNameLength()
Implements java. Retrieves the maximum number of characters this database allows in a table name. |
| public int | getMaxTablesInSelect()
Implements java. Retrieves the maximum number of tables this database allows in a
|
| public int | getMaxUserNameLength()
Implements java. Retrieves the maximum number of characters this database allows in a user name. |
| public int | |
| public String | |
| public String | getNumericFunctions()
Implements java. Retrieves a comma-separated list of math functions available with this database. |
| public ResultSet | getPrimaryKeys(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in the database table)Implements java. Retrieves a description of the given table's primary key columns. |
| protected Field[] | |
| public ResultSet | getProcedureColumns(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha procedure name pattern; must match the
procedure name as it is stored in the database procedureNamePattern, String a column name pattern; must match the column name
as it is stored in the database columnNamePattern)Implements java. Retrieves a description of the given catalog's stored procedure parameter and result columns. |
| protected ResultSet | |
| protected static int | Returns: The corresponding COLUMN_TYPE as in java.sql.DatabaseMetaData.getProcedureColumns API.Indicates whether it's an output parameter. isOutParam, boolean Indicates whether it's an input parameter. isInParam, boolean Indicates whether it's a function return parameter. isReturnParam, boolean Indicates whether the column belong to a function. forGetFunctionColumns)Determines the COLUMN_TYPE information based on parameter type (IN, OUT or INOUT) or function return parameter. |
| private void | getProcedureOrFunctionParameterTypes(String dbName, String objectName, DatabaseMetaData.
|
| public ResultSet | getProcedures(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha procedure name pattern; must match the
procedure name as it is stored in the database procedureNamePattern)Implements java. Retrieves a description of the stored procedures available in the given catalog. |
| protected ResultSet | Returns: result setfields fields, String catalog catalog, String schema pattern schemaPattern, final String procedure name pattern procedureNamePattern, final boolean true if procedures should be included into result includeProcedures, final boolean true if functions should be included into result includeFunctions)
|
| public String | getProcedureTerm()
Implements java. Retrieves the database vendor's preferred term for "procedure". |
| public ResultSet | getPseudoColumns(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha table name pattern; must match the
table name as it is stored in the database tableNamePattern, String a column name pattern; must match the column
name as it is stored in the database columnNamePattern)Implements java. Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema. |
| public int | getResultSetHoldability()
Implements java. Retrieves this database's default holdability for |
| public RowIdLifetime | getRowIdLifetime()
Implements java. Indicates whether this data source supports the SQL |
| protected DatabaseMetaData. | |
| public ResultSet | getSchemas()
Implements java. Retrieves the schema names available in this database. |
| public ResultSet | getSchemas(String
a catalog name; must match the catalog name as it is stored
in the database;"" retrieves those without a catalog; null means catalog
name should not be used to narrow down the search. catalog, String a schema name; must match the schema name as it is
stored in the database; null means
schema name should not be used to narrow down the search. schemaPattern)Implements java. Retrieves the schema names available in this database. |
| public String | getSchemaTerm()
Implements java. Retrieves the database vendor's preferred term for "schema". |
| public String | getSearchStringEscape()
Implements java. Retrieves the string that can be used to escape wildcard characters. |
| public String | Returns: the listImplements java. Get a comma separated list of all a database's SQL keywords that are NOT also SQL92/SQL2003 keywords. |
| public int | getSQLStateType()
Implements java. Indicates whether the SQLSTATE returned by |
| public String | getStringFunctions()
Implements java. Retrieves a comma-separated list of string functions available with this database. |
| public ResultSet | getSuperTables(String
a catalog name; "" retrieves those without a catalog;
catalog, String null means drop catalog name from the selection criteriaa schema name pattern; "" retrieves those
without a schema schemaPattern, String a table name pattern; may be a fully-qualified
name tableNamePattern)Implements java. Retrieves a description of the table hierarchies defined in a particular schema in this database. |
| public ResultSet | getSuperTypes(String
a catalog name; "" retrieves those without a catalog;
catalog, String null means drop catalog name from the selection criteriaa schema name pattern; "" retrieves those
without a schema schemaPattern, String a UDT name pattern; may be a fully-qualified
name typeNamePattern)Implements java. Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. |
| public String | getSystemFunctions()
Implements java. Retrieves a comma-separated list of system functions available with this database. |
| public ResultSet | getTablePrivileges(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha table name pattern; must match the
table name as it is stored in the database tableNamePattern)Implements java. Retrieves a description of the access rights for each table available in a catalog. |
| public ResultSet | getTables(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha table name pattern; must match the
table name as it is stored in the database tableNamePattern, final String[] a list of table types, which must be from the list of table types
returned from types)getTableTypes, to include; null returns
all typesImplements java. Retrieves a description of the tables available in the given catalog. |
| public ResultSet | getTableTypes()
Implements java. Retrieves the table types available in this database. |
| public String | getTimeDateFunctions()
Implements java. Retrieves a comma-separated list of the time and date functions available with this database. |
| private byte[][] | Returns: byteswe use a string name here to allow aliases for the same MysqlType to be listed too mysqlTypeName)
|
| public ResultSet | getTypeInfo()
Implements java. Retrieves a description of all the data types supported by this database. |
| public ResultSet | getUDTs(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema pattern name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha type name pattern; must match the type name
as it is stored in the database; may be a fully qualified name typeNamePattern, int[] a list of user-defined types (JAVA_OBJECT,
STRUCT, or DISTINCT) to include; types)null returns all typesImplements java. Retrieves a description of the user-defined types (UDTs) defined in a particular schema. |
| public String | |
| public String | getUserName()
Implements java. Retrieves the user name as known to this database. |
| public ResultSet | getVersionColumns(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schema, final String null means that the schema name should not be used to narrow
the searcha table name; must match the table name as it is stored
in the database table)Implements java. Retrieves a description of a table's columns that are automatically updated when any value in a row is updated. |
| protected Field[] | |
| public boolean | insertsAreDetected(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether or not a visible row insert can be detected
by calling the method |
| public boolean | isCatalogAtStart()
Implements java. Retrieves whether a catalog appears at the start of a fully qualified table name. |
| public boolean | isReadOnly()
Implements java. Retrieves whether this database is in read-only mode. |
| public boolean | isWrapperFor(Class<?>
a Class defining an interface. iface)Implements java. Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. |
| public boolean | locatorsUpdateCopy()
Implements java. Indicates whether updates made to a LOB are made on a copy or directly to the LOB. |
| protected String | Returns: a case-normalized version of the specified entity namethe entity name to normalize entity)Normalizes the entity name considering how identifiers are stored in relation to their case. |
| public boolean | nullPlusNonNullIsNull()
Implements java. Retrieves whether this database supports concatenations between
|
| public boolean | nullsAreSortedAtEnd()
Implements java. Retrieves whether |
| public boolean | nullsAreSortedAtStart()
Implements java. Retrieves whether |
| public boolean | nullsAreSortedHigh()
Implements java. Retrieves whether |
| public boolean | nullsAreSortedLow()
Implements java. Retrieves whether |
| public boolean | othersDeletesAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether deletes made by others are visible. |
| public boolean | othersInsertsAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether inserts made by others are visible. |
| public boolean | othersUpdatesAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether updates made by others are visible. |
| public boolean | ownDeletesAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether a result set's own deletes are visible. |
| public boolean | ownInsertsAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether a result set's own inserts are visible. |
| public boolean | ownUpdatesAreVisible(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether for the given type of |
| pack-priv DatabaseMetaData. | Returns: aReferencingAndReferencedColumns instance containing the parsed informationthe comment from 'show table status' keysComment)Parses a keysComment section from the 'show table status' SQL command. |
| pack-priv void | populateKeyResults(String
the database of the parent table parentDatabase, String the parent key table name parentTable, String the database of the foreign table foreignDatabase, String the foreign key table name foreignTable, String the comment from 'show table status' keys, boolean export or import keys forExport, List<Row> the rows to add results to resultRows)Populates the resultRows list with the imported or exported keys of given table based on the keysComment from the 'show table status' SQL command. |
| protected PreparedStatement | Returns: PreparedStatementquery sql)Get a prepared statement to query information_schema tables. |
| public boolean | |
| protected byte[] | |
| public void | |
| public void | |
| public boolean | storesLowerCaseIdentifiers()
Implements java. Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case. |
| public boolean | storesLowerCaseQuotedIdentifiers()
Implements java. Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case. |
| public boolean | storesMixedCaseIdentifiers()
Implements java. Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case. |
| public boolean | storesMixedCaseQuotedIdentifiers()
Implements java. Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case. |
| public boolean | storesUpperCaseIdentifiers()
Implements java. Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case. |
| public boolean | storesUpperCaseQuotedIdentifiers()
Implements java. Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case. |
| public boolean | supportsAlterTableWithAddColumn()
Implements java. Retrieves whether this database supports |
| public boolean | supportsAlterTableWithDropColumn()
Implements java. Retrieves whether this database supports |
| public boolean | supportsANSI92EntryLevelSQL()
Implements java. Retrieves whether this database supports the ANSI92 entry level SQL grammar. |
| public boolean | supportsANSI92FullSQL()
Implements java. Retrieves whether this database supports the ANSI92 full SQL grammar supported. |
| public boolean | supportsANSI92IntermediateSQL()
Implements java. Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. |
| public boolean | supportsBatchUpdates()
Implements java. Retrieves whether this database supports batch updates. |
| public boolean | supportsCatalogsInDataManipulation()
Implements java. Retrieves whether a catalog name can be used in a data manipulation statement. |
| public boolean | supportsCatalogsInIndexDefinitions()
Implements java. Retrieves whether a catalog name can be used in an index definition statement. |
| public boolean | supportsCatalogsInPrivilegeDefinitions()
Implements java. Retrieves whether a catalog name can be used in a privilege definition statement. |
| public boolean | supportsCatalogsInProcedureCalls()
Implements java. Retrieves whether a catalog name can be used in a procedure call statement. |
| public boolean | supportsCatalogsInTableDefinitions()
Implements java. Retrieves whether a catalog name can be used in a table definition statement. |
| public boolean | supportsColumnAliasing()
Implements java. Retrieves whether this database supports column aliasing. |
| public boolean | supportsConvert()
Implements java. Retrieves whether this database supports the JDBC scalar function
|
| public boolean | supportsConvert(int
the type to convert from; one of the type codes from
the class fromType, int java.sql.Typesthe type to convert to; one of the type codes from
the class toType)java.sql.TypesImplements java. Retrieves whether this database supports the JDBC scalar function
|
| public boolean | supportsCoreSQLGrammar()
Implements java. Retrieves whether this database supports the ODBC Core SQL grammar. |
| public boolean | supportsCorrelatedSubqueries()
Implements java. Retrieves whether this database supports correlated subqueries. |
| public boolean | supportsDataDefinitionAndDataManipulationTransactions()
Implements java. Retrieves whether this database supports both data definition and data manipulation statements within a transaction. |
| public boolean | supportsDataManipulationTransactionsOnly()
Implements java. Retrieves whether this database supports only data manipulation statements within a transaction. |
| public boolean | supportsDifferentTableCorrelationNames()
Implements java. Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables. |
| public boolean | supportsExpressionsInOrderBy()
Implements java. Retrieves whether this database supports expressions in
|
| public boolean | supportsExtendedSQLGrammar()
Implements java. Retrieves whether this database supports the ODBC Extended SQL grammar. |
| public boolean | supportsFullOuterJoins()
Implements java. Retrieves whether this database supports full nested outer joins. |
| public boolean | supportsGetGeneratedKeys()
Implements java. Retrieves whether auto-generated keys can be retrieved after a statement has been executed |
| public boolean | supportsGroupBy()
Implements java. Retrieves whether this database supports some form of
|
| public boolean | supportsGroupByBeyondSelect()
Implements java. Retrieves whether this database supports using columns not included in
the |
| public boolean | supportsGroupByUnrelated()
Implements java. Retrieves whether this database supports using a column that is
not in the |
| public boolean | supportsIntegrityEnhancementFacility()
Implements java. Retrieves whether this database supports the SQL Integrity Enhancement Facility. |
| public boolean | supportsLikeEscapeClause()
Implements java. Retrieves whether this database supports specifying a
|
| public boolean | supportsLimitedOuterJoins()
Implements java. Retrieves whether this database provides limited support for outer joins. |
| public boolean | supportsMinimumSQLGrammar()
Implements java. Retrieves whether this database supports the ODBC Minimum SQL grammar. |
| public boolean | supportsMixedCaseIdentifiers()
Implements java. Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
| public boolean | supportsMixedCaseQuotedIdentifiers()
Implements java. Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
| public boolean | supportsMultipleOpenResults()
Implements java. Retrieves whether it is possible to have multiple |
| public boolean | supportsMultipleResultSets()
Implements java. Retrieves whether this database supports getting multiple
|
| public boolean | supportsMultipleTransactions()
Implements java. Retrieves whether this database allows having multiple transactions open at once (on different connections). |
| public boolean | supportsNamedParameters()
Implements java. Retrieves whether this database supports named parameters to callable statements. |
| public boolean | supportsNonNullableColumns()
Implements java. Retrieves whether columns in this database may be defined as non-nullable. |
| public boolean | supportsOpenCursorsAcrossCommit()
Implements java. Retrieves whether this database supports keeping cursors open across commits. |
| public boolean | supportsOpenCursorsAcrossRollback()
Implements java. Retrieves whether this database supports keeping cursors open across rollbacks. |
| public boolean | supportsOpenStatementsAcrossCommit()
Implements java. Retrieves whether this database supports keeping statements open across commits. |
| public boolean | supportsOpenStatementsAcrossRollback()
Implements java. Retrieves whether this database supports keeping statements open across rollbacks. |
| public boolean | supportsOrderByUnrelated()
Implements java. Retrieves whether this database supports using a column that is
not in the |
| public boolean | supportsOuterJoins()
Implements java. Retrieves whether this database supports some form of outer join. |
| public boolean | supportsPositionedDelete()
Implements java. Retrieves whether this database supports positioned |
| public boolean | supportsPositionedUpdate()
Implements java. Retrieves whether this database supports positioned |
| public boolean | supportsResultSetConcurrency(int
defined in type, int java.sql.ResultSettype defined in concurrency)java.sql.ResultSetImplements java. Retrieves whether this database supports the given concurrency type in combination with the given result set type. |
| public boolean | supportsResultSetHoldability(int
one of the following constants:
holdability)ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Retrieves whether this database supports the given result set holdability. |
| public boolean | supportsResultSetType(int
defined in type)java.sql.ResultSetImplements java. Retrieves whether this database supports the given result set type. |
| public boolean | supportsSavepoints()
Implements java. Retrieves whether this database supports savepoints. |
| public boolean | supportsSchemasInDataManipulation()
Implements java. Retrieves whether a schema name can be used in a data manipulation statement. |
| public boolean | supportsSchemasInIndexDefinitions()
Implements java. Retrieves whether a schema name can be used in an index definition statement. |
| public boolean | supportsSchemasInPrivilegeDefinitions()
Implements java. Retrieves whether a schema name can be used in a privilege definition statement. |
| public boolean | supportsSchemasInProcedureCalls()
Implements java. Retrieves whether a schema name can be used in a procedure call statement. |
| public boolean | supportsSchemasInTableDefinitions()
Implements java. Retrieves whether a schema name can be used in a table definition statement. |
| public boolean | supportsSelectForUpdate()
Implements java. Retrieves whether this database supports |
| public boolean | supportsStatementPooling()
Implements java. Retrieves whether this database supports statement pooling. |
| public boolean | supportsStoredFunctionsUsingCallSyntax()
Implements java. Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax. |
| public boolean | supportsStoredProcedures()
Implements java. Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax. |
| public boolean | supportsSubqueriesInComparisons()
Implements java. Retrieves whether this database supports subqueries in comparison expressions. |
| public boolean | supportsSubqueriesInExists()
Implements java. Retrieves whether this database supports subqueries in
|
| public boolean | supportsSubqueriesInIns()
Implements java. Retrieves whether this database supports subqueries in
|
| public boolean | supportsSubqueriesInQuantifieds()
Implements java. Retrieves whether this database supports subqueries in quantified expressions. |
| public boolean | supportsTableCorrelationNames()
Implements java. Retrieves whether this database supports table correlation names. |
| public boolean | supportsTransactionIsolationLevel(int
one of the transaction isolation levels defined in
level)java.sql.ConnectionImplements java. Retrieves whether this database supports the given transaction isolation level. |
| public boolean | supportsTransactions()
Implements java. Retrieves whether this database supports transactions. |
| public boolean | supportsUnion()
Implements java. Retrieves whether this database supports SQL |
| public boolean | supportsUnionAll()
Implements java. Retrieves whether this database supports SQL |
| public <T> T | unwrap(Class<T>
A Class defining an interface that the result must implement. iface)Implements java. Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. |
| public boolean | updatesAreDetected(int
the type)ResultSet type; one of
ResultSet.TYPE_FORWARD_ONLY,
ResultSet.TYPE_SCROLL_INSENSITIVE, or
ResultSet.TYPE_SCROLL_SENSITIVEImplements java. Retrieves whether or not a visible row update can be detected by
calling the method |
| public boolean | usesLocalFilePerTable()
Implements java. Retrieves whether this database uses a file for each table. |
| public boolean | usesLocalFiles()
Implements java. Retrieves whether this database stores tables in a local file. |