| Methods Summary |
|---|
| public boolean | allProceduresAreCallable()Returns whether all procedures returned by {@link #getProcedures} can be
called by the current user.
|
| public boolean | allTablesAreSelectable()Returns whether all the tables returned by {@code getTables} can be used
by the current user in a {@code SELECT} statement.
|
| public boolean | dataDefinitionCausesTransactionCommit()Returns whether a data definition statement in a transaction forces a {@code
commit} of the transaction.
|
| public boolean | dataDefinitionIgnoredInTransactions()Returns whether the database ignores data definition statements within a
transaction.
|
| public boolean | deletesAreDetected(int type)Returns whether a visible row delete can be detected by calling
{@link ResultSet#rowDeleted}.
|
| public boolean | doesMaxRowSizeIncludeBlobs()Returns whether the return value of {@code getMaxRowSize} includes the
SQL data types {@code LONGVARCHAR} and {@code LONGVARBINARY}.
|
| public java.sql.ResultSet | getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, java.lang.String attributeNamePattern)Returns a {@code ResultSet} describing a subset of the attributes of a
specified SQL User Defined Type (UDT) for a specified schema and catalog.
The subset is determined by restricting to those attributes whose
name matches the {@code attributeNamePattern} and whose type name
matches the {@code typeNamePattern}. Each row of the {@code ResultSet}
describes one attribute, and the rows are ordered by the columns {@code TYPE_SCHEM},
{@code TYPE_NAME} and {@code ORDINAL_POSITION}. Inherited attributes
are not included.
The columns of the returned {@code ResultSet} object have the following
names and meanings:
- {@code TYPE_CAT} - String - the type catalog name (possibly {@code
null})
- {@code TYPE_SCHEM} - String - the type schema name (possibly {@code
null})
- {@code TYPE_NAME} - String - the type name
- {@code ATTR_NAME} - String - the attribute name
- {@code DATA_TYPE} - int - the attribute type as defined in {@code
java.sql.Types}
- {@code ATTR_TYPE_NAME} - String - the attribute type name. This
depends on the data source. For a {@code UDT} the name is fully
qualified. For a {@code REF} it is both fully qualified and represents
the target type of the reference.
- {@code ATTR_SIZE} - int - the column size. When referring to char and
date types this value is the maximum number of characters. When referring
to numeric types is is the precision.
- {@code DECIMAL_DIGITS} - int - how many fractional digits are
supported
- {@code NUM_PREC_RADIX} - int - numeric values radix
- {@code NULLABLE} - int - whether {@code NULL} is permitted:
- DatabaseMetaData.attributeNoNulls - {@code NULL} values not permitted
- DatabaseMetaData.attributeNullable - {@code NULL} values definitely
permitted
- DatabaseMetaData.attributeNullableUnknown - unknown
- {@code REMARKS} - String - a comment describing the attribute
(possibly {@code null})
- ATTR_DEF - String - Default value for the attribute (possibly {@code
null})
- {@code SQL_DATA_TYPE} - int - not used
- SQL_DATETIME_SUB - int - not used
- CHAR_OCTET_LENGTH - int - for {@code CHAR} types, the max number of
bytes in the column
- ORDINAL_POSITION - int - The index of the column in the table (where
the count starts from 1, not 0)
- IS_NULLABLE - String - {@code "NO"} = the column does not allow {@code
NULL}s, {@code "YES"} = the column allows {@code NULL}s, "" = status unknown
- {@code SCOPE_CATALOG} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the catalog of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SCOPE_SCHEMA} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the schema of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SCOPE_TABLE} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the name of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SOURCE_DATA_TYPE} - String - The source type for a user
generated REF type or for a Distinct type. ({@code NULL} if {@code
DATA_TYPE} is not DISTINCT or a user generated REF)
|
| public java.sql.ResultSet | getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String table, int scope, boolean nullable)Returns a list of a table's optimal set of columns that uniquely
identify the rows. The results are ordered by {@code SCOPE} (see below).
The results are returned as a table, with one entry for each column, as
follows:
- {@code SCOPE} - short - the {@code SCOPE} of the result, as follows:
- {@code DatabaseMetaData.bestRowTemporary} - the result is very temporary,
only valid while on the current row
- {@code DatabaseMetaData.bestRowTransaction} - the result is good for remainder of
current transaction
- {@code DatabaseMetaData.bestRowSession} - the result is good for remainder of
database session
- {@code COLUMN_NAME} - String - the column name
- {@code DATA_TYPE} - int - the Type of the data, as defined in {@code
java.sql.Types}
- {@code TYPE_NAME} - String - the Name of the type - database dependent.
For UDT types the name is fully qualified
- {@code COLUMN_SIZE} - int - the precision of the data in the column
- {@code BUFFER_LENGTH} - int - not used
- {@code DECIMAL_DIGITS} - short - number of fractional digits
- {@code PSEUDO_COLUMN} - short - whether this is a pseudo column (e.g.
an Oracle {@code ROWID}):
- {@code DatabaseMetaData.bestRowUnknown} - it is not known whether this is
a pseudo column
- {@code DatabaseMetaData.bestRowNotPseudo} - the column is not pseudo
- {@code DatabaseMetaData.bestRowPseudo} - the column is a pseudo column
|
| public java.lang.String | getCatalogSeparator()Returns the separator that this database uses between a catalog name and
table name.
|
| public java.lang.String | getCatalogTerm()Returns the term that the database vendor prefers term for "catalog".
|
| public java.sql.ResultSet | getCatalogs()Returns the set of catalog names available in this database. The set is
returned ordered by catalog name.
|
| public java.sql.ResultSet | getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String table, java.lang.String columnNamePattern)Returns a description of access rights for a table's columns. Only access
rights matching the criteria for the column name are returned.
The description is returned as a {@code ResultSet} with rows of data for
each access right, with columns as follows:
- {@code TABLE_CAT} - String - the catalog name (possibly {@code null})
- {@code TABLE_SCHEM} - String - the schema name (possibly {@code null})
- {@code TABLE_NAME} - String - the table name
- {@code COLUMN_NAME} - String - the Column name
- {@code GRANTOR} - String - the grantor of access (possibly {@code
null})
- {@code PRIVILEGE} - String - Access right - one of SELECT, INSERT,
UPDATE, REFERENCES,...
- {@code IS_GRANTABLE} - String - {@code "YES"} implies that the
receiver can grant access to others, {@code "NO"} if the receiver cannot
grant access to others, {@code null} if unknown.
|
| public java.sql.ResultSet | getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String columnNamePattern)Returns a description of table columns available in a specified catalog.
Only descriptions meeting the specified catalog, schema, table, and column
names are returned.
The descriptions are returned as a {@code ResultSet} conforming to the
following data layout, with one row per table column:
- {@code TABLE_CAT} - String - the catalog name (possibly {@code null})
- {@code TABLE_SCHEM} - String - the schema name (possibly {@code null})
- {@code TABLE_NAME} - String - the table name
- {@code COLUMN_NAME} - String - the column name
- {@code DATA_TYPE} - int - the SQL type as specified in {@code
java.sql.Types}
- {@code TYPE_NAME} - String - the name of the data type, (database-dependent,
UDT names are fully qualified)
- {@code COLUMN_SIZE} - int - the column size (the precision for numeric
types, max characters for {@code char} and {@code date} types)
- {@code BUFFER_LENGTH} - int - Not used
- {@code DECIMAL_DIGITS} - int - maximum number of fractional digits
- {@code NUM_PREC_RADIX} - int - the radix for numerical types
- {@code NULLABLE} - int - whether the column allows {@code null}s:
- DatabaseMetaData.columnNoNulls = may not allow {@code NULL}s
- DatabaseMetaData.columnNullable = does allow {@code NULL}s
- DatabaseMetaData.columnNullableUnknown = unknown {@code NULL} status
- {@code REMARKS} - String - A description of the column (possibly
{@code null})
- {@code COLUMN_DEF} - String - Default value for the column (possibly
{@code null})
- {@code SQL_DATA_TYPE} - int - not used
- {@code SQL_DATETIME_SUB} - int - not used
- {@code CHAR_OCTET_LENGTH} - int - maximum number of bytes in the
{@code char} type columns
- {@code ORDINAL_POSITION} - int - the column index in the table (1 based)
- {@code IS_NULLABLE} - String - {@code "NO"} = column does not allow
NULLs, {@code "YES"} = column allows NULLs, "" = {@code NULL} status
unknown
- {@code SCOPE_CATALOG} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the catalog of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SCOPE_SCHEMA} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the schema of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SCOPE_TABLE} - String - if the {@code DATA_TYPE} is {@code REF},
this gives the name of the table corresponding to the attribute's scope.
NULL if the {@code DATA_TYPE} is not REF.
- {@code SOURCE_DATA_TYPE} - String - The source type for a user
generated REF type or for a Distinct type. ({@code NULL} if {@code
DATA_TYPE} is not DISTINCT or a user generated REF)
|
| public java.sql.Connection | getConnection()Returns the database connection that created this metadata.
|
| public java.sql.ResultSet | getCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTable, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTable)Returns a list of foreign key columns in a given foreign key table that
reference the primary key columns of a supplied primary key table. This
describes how one table imports the key of another table. It would be
expected to return a single foreign key - primary key pair in most cases.
The descriptions are returned as a {@code ResultSet} with one row for
each foreign key, with the following layout:
- {@code PKTABLE_CAT} - String - from the primary key table : Catalog
(possibly {@code null})
- {@code PKTABLE_SCHEM} - String - from the primary key table : Schema
(possibly {@code null})
- {@code PKTABLE_NAME} - String - from the primary key table : name
- {@code PKCOLUMN_NAME} - String - from the primary key column : name
- {@code FKTABLE_CAT} - String - from the foreign key table : the
catalog name being exported (possibly {@code null})
- {@code FKTABLE_SCHEM} - String - from the foreign key table : the schema name
being exported (possibly {@code null})
- {@code FKTABLE_NAME} - String - from the foreign key table : the name being
exported
- {@code FKCOLUMN_NAME} - String - from the foreign key column : the name being
exported
- {@code KEY_SEQ} - short - the sequence number (in the foreign key)
- {@code UPDATE_RULE} - short - a value giving the rule for how to treat the corresponding foreign key when a primary
key is updated:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow the
primary key to be updated if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - change the imported key to
match the updated primary key
- {@code DatabaseMetaData.importedKeySetNull} - set the imported key to
{@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - set the imported key
to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as {@code
importedKeyNoAction}
- {@code DELETE_RULE} - short - a value giving the rule for how to treat the foreign key when the corresponding primary
key is deleted:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow the
primary key to be deleted if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - delete those rows that
import a deleted key
- {@code DatabaseMetaData.importedKeySetNull} - set the imported key to
{@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - set the imported key
to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as
importedKeyNoAction
- {@code FK_NAME} - String - the foreign key name (possibly {@code null})
- {@code PK_NAME} - String - the primary key name (possibly {@code null})
- {@code DEFERRABILITY} - short - whether foreign key constraints can be
deferred until commit (see the SQL92 specification for definitions):
- {@code DatabaseMetaData.importedKeyInitiallyDeferred}
- {@code DatabaseMetaData.importedKeyInitiallyImmediate}
- {@code DatabaseMetaData.importedKeyNotDeferrable}
|
| public int | getDatabaseMajorVersion()Returns the major version number of the database software.
|
| public int | getDatabaseMinorVersion()Returns the minor version number of the database software.
|
| public java.lang.String | getDatabaseProductName()Returns the name of the database software.
|
| public java.lang.String | getDatabaseProductVersion()Returns the version number of this database software.
|
| public int | getDefaultTransactionIsolation()Returns the default transaction isolation level for this database.
|
| public int | getDriverMajorVersion()Returns the JDBC driver's major version number.
|
| public int | getDriverMinorVersion()Returns the JDBC driver's minor version number.
|
| public java.lang.String | getDriverName()Returns the name of this JDBC driver.
|
| public java.lang.String | getDriverVersion()Returns the version number of this JDBC driver.
|
| public java.sql.ResultSet | getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)Returns a list of the foreign key columns that reference the primary key
columns of a specified table (the foreign keys exported by a table).
The list is returned as a {@code ResultSet} with a row for each of the
foreign key columns, ordered by {@code FKTABLE_CAT}, {@code
FKTABLE_SCHEM}, {@code FKTABLE_NAME}, and {@code KEY_SEQ}, with the
format for each row being:
- {@code PKTABLE_CAT} - String - from the primary key table : the catalog (possibly
{@code null})
- {@code PKTABLE_SCHEM} - String - from the primary key table : the schema (possibly
{@code null})
- {@code PKTABLE_NAME} - String - from the primary key table : the name
- {@code PKCOLUMN_NAME} - String - from the primary key column : the name
- {@code FKTABLE_CAT} - String - from the foreign key table : the catalog name being
exported (possibly {@code null})
- {@code FKTABLE_SCHEM} - String - from the foreign key table : the schema name
being exported (possibly {@code null})
- {@code FKTABLE_NAME} - String - from the foreign key table : the name being
exported
- {@code FKCOLUMN_NAME} - String - from the foreign key column : the name being
exported
- {@code KEY_SEQ} - short - the sequence number (in the foreign key)
- {@code UPDATE_RULE} - short - a value giving the rule for how to treat the foreign key when the corresponding primary
key is updated:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow the
primary key to be updated if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - change the imported key to
match the primary key update
- {@code DatabaseMetaData.importedKeySetNull} - set the imported key to
{@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - set the imported key
to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as
importedKeyNoAction
- {@code DELETE_RULE} - short - how to treat the foreign key when the corresponding primary
key is deleted:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow the
primary key to be deleted if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - the deletion should
also delete rows that import a deleted key
- {@code DatabaseMetaData.importedKeySetNull} - the deletion sets the
imported key to {@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - the deletion sets the
imported key to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as
importedKeyNoAction
- {@code FK_NAME} - String - the foreign key name (possibly {@code null})
- {@code PK_NAME} - String - the primary key name (possibly {@code null})
- {@code DEFERRABILITY} - short - defines whether the foreign key
constraints can be deferred until commit (see the SQL92 specification for
definitions):
- {@code DatabaseMetaData.importedKeyInitiallyDeferred}
- {@code DatabaseMetaData.importedKeyInitiallyImmediate}
- {@code DatabaseMetaData.importedKeyNotDeferrable}
|
| public java.lang.String | getExtraNameCharacters()Returns a string of characters that may be used in unquoted identifier
names. The characters {@code a-z}, {@code A-Z}, {@code 0-9} and {@code _}
are always permitted.
|
| public java.lang.String | getIdentifierQuoteString()Returns the string used to quote SQL identifiers. Returns " " (space) if
identifier quoting not supported.
|
| public java.sql.ResultSet | getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)Returns a list columns in a table that are both primary keys and
referenced by the table's foreign key columns (that is, the primary keys
imported by a table).
The list returned is a {@code ResultSet} with a row entry for each
primary key column, ordered by {@code PKTABLE_CAT}, {@code PKTABLE_SCHEM},
{@code PKTABLE_NAME}, and {@code KEY_SEQ}, with the following format:
- {@code PKTABLE_CAT} - String - primary key catalog name being
imported (possibly {@code null})
- {@code PKTABLE_SCHEM} - String - primary key schema name being
imported (possibly {@code null})
- {@code PKTABLE_NAME} - String - primary key table name being imported
- {@code PKCOLUMN_NAME} - String - primary key column name being
imported
- {@code FKTABLE_CAT} - String - foreign key table catalog name
(possibly {@code null})
- {@code FKTABLE_SCHEM} - String - foreign key table schema name
(possibly {@code null})
- {@code FKTABLE_NAME} - String - foreign key table name
- {@code FKCOLUMN_NAME} - String - foreign key column name
- {@code KEY_SEQ} - short - sequence number (in the foreign key)
- {@code UPDATE_RULE} - short - how to treat the foreign key when the corresponding primary
key is updated:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow any update of
the primary key if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - change imported key to
match the primary key update
- {@code DatabaseMetaData.importedKeySetNull} - set the imported key to
{@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - set the imported key
to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as
importedKeyNoAction
- {@code DELETE_RULE} - short - how to treat the foreign key when the corresponding primary
key is deleted:
- {@code DatabaseMetaData.importedKeyNoAction} - don't allow the primary key to be deleted
if it is imported as a foreign key
- {@code DatabaseMetaData.importedKeyCascade} - delete those rows that
import a deleted key
- {@code DatabaseMetaData.importedKeySetNull} - set the imported key to
{@code null}
- {@code DatabaseMetaData.importedKeySetDefault} - set the imported key
to its default value
- {@code DatabaseMetaData.importedKeyRestrict} - same as {@code
importedKeyNoAction}
- {@code FK_NAME} - String - foreign key name (possibly {@code null})
- {@code PK_NAME} - String - primary key name (possibly {@code null})
- {@code DEFERRABILITY} - short - defines whether foreign key
constraints can be deferred until commit (see SQL92 specification for
definitions):
- {@code DatabaseMetaData.importedKeyInitiallyDeferred}
- {@code DatabaseMetaData.importedKeyInitiallyImmediate}
- {@code DatabaseMetaData.importedKeyNotDeferrable}
|
| public java.sql.ResultSet | getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String table, boolean unique, boolean approximate)Returns a list of indices and statistics for a specified table.
The list is returned as a {@code ResultSet}, with one row for each index
or statistic. The list is ordered by {@code NON_UNIQUE}, {@code TYPE},
{@code INDEX_NAME}, and {@code ORDINAL_POSITION}. Each row has the
following format:
- {@code TABLE_CAT} - String - table catalog name (possibly {@code
null})
- {@code TABLE_SCHEM} - String - table schema name (possibly {@code
null})
- {@code TABLE_NAME} - String - The table name
- {@code NON_UNIQUE} - boolean - {@code true} when index values can be
non-unique. Must be {@code false} when the TYPE is tableIndexStatistic
- {@code INDEX_QUALIFIER} - String : index catalog name. {@code null}
when the TYPE is 'tableIndexStatistic'
- {@code INDEX_NAME} - String : index name. {@code null} when TYPE is
'tableIndexStatistic'
- {@code TYPE} - short - the index type. One of:
- {@code DatabaseMetaData.tableIndexStatistic} - table statistics
returned with Index descriptions
- {@code DatabaseMetaData.tableIndexClustered} - a clustered Index
- {@code DatabaseMetaData.tableIndexHashed} - a hashed Index
- {@code DatabaseMetaData.tableIndexOther} - other style of Index
- {@code ORDINAL_POSITION} - short - column sequence within Index. 0
when TYPE is tableIndexStatistic
- {@code COLUMN_NAME} - String - the column name. {@code null} when
TYPE is tableIndexStatistic
- {@code ASC_OR_DESC} - String - column sort sequence. {@code null} if
sequencing not supported or TYPE is tableIndexStatistic; otherwise "A"
means sort ascending and "D" means sort descending.
- {@code CARDINALITY} - int - Number of unique values in the Index. If
TYPE is tableIndexStatistic, this is number of rows in the table.
- {@code PAGES} - int - Number of pages for current Index. If TYPE is
tableIndexStatistic, this is number of pages used for the table.
- {@code FILTER_CONDITION} - String - Filter condition. (possibly null)
|
| public int | getJDBCMajorVersion()Returns this driver's major JDBC version number.
|
| public int | getJDBCMinorVersion()Returns the minor JDBC version number for this driver.
|
| public int | getMaxBinaryLiteralLength()Get the maximum number of hex characters in an in-line binary literal for
this database.
|
| public int | getMaxCatalogNameLength()Returns the maximum size of a catalog name in this database.
|
| public int | getMaxCharLiteralLength()Returns the maximum size for a character literal in this database.
|
| public int | getMaxColumnNameLength()Returns the maximum size for a Column name for this database.
|
| public int | getMaxColumnsInGroupBy()Get the maximum number of columns in a {@code GROUP BY} clause for this
database.
|
| public int | getMaxColumnsInIndex()Returns the maximum number of columns in an Index for this database.
|
| public int | getMaxColumnsInOrderBy()Returns the maximum number of columns in an {@code ORDER BY} clause for
this database.
|
| public int | getMaxColumnsInSelect()Returns the maximum number of columns in a {@code SELECT} list for this
database.
|
| public int | getMaxColumnsInTable()Returns the maximum number of columns in a table for this database.
|
| public int | getMaxConnections()Returns the database's maximum number of concurrent connections.
|
| public int | getMaxCursorNameLength()Returns the maximum length of a cursor name for this database.
|
| public int | getMaxIndexLength()Returns the maximum length in bytes for an Index for this database. This
covers all the parts of a composite index.
|
| public int | getMaxProcedureNameLength()Returns the maximum number of characters for a procedure name in this
database.
|
| public int | getMaxRowSize()Returns the maximum number of bytes within a single row for this
database.
|
| public int | getMaxSchemaNameLength()Returns the maximum number of characters in a schema name for this
database.
|
| public int | getMaxStatementLength()Returns the maximum number of characters in an SQL statement for this
database.
|
| public int | getMaxStatements()Get the maximum number of simultaneously open active statements for this
database.
|
| public int | getMaxTableNameLength()Returns the maximum size for a table name in the database.
|
| public int | getMaxTablesInSelect()Returns the maximum number of tables permitted in a {@code SELECT}
statement for the database.
|
| public int | getMaxUserNameLength()Returns the maximum number of characters in a user name for the database.
|
| public java.lang.String | getNumericFunctions()Returns a list of the math functions available with this database. These
are used in the JDBC function escape clause and are the Open Group CLI
math function names.
|
| public java.sql.ResultSet | getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String table)Returns a list of the primary key columns of a specified table.
The list is returned as a {@code ResultSet} with one row for each primary
key column, ordered by {@code COLUMN_NAME}, with each row having the
structure as follows:
- {@code TABLE_CAT} - String - table catalog name (possibly null)
- {@code TABLE_SCHEM} - String - table schema name (possibly null)
- {@code TABLE_NAME} - String - The table name
- {@code COLUMN_NAME} - String - The column name
- {@code KEY_SEQ} - short - the sequence number for this column in the
primary key
- {@code PK_NAME} - String - the primary key name (possibly null)
|
| public java.sql.ResultSet | getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern, java.lang.String columnNamePattern)Returns a list of parameter and result columns for the stored procedures
belonging to a specified catalog.
The list is returned as a {@code ResultSet} with one row for each
parameter or result column. The data is ordered by {@code
PROCEDURE_SCHEM} and {@code PROCEDURE_NAME}, while for each procedure,
the return value (if any) is first, followed by the parameters in the
order they appear in the stored procedure call, followed by {@code
ResultSet} columns in column number order. Each row has the following
structure:
- {@code PROCEDURE_CAT} - String - the procedure catalog name
- {@code PROCEDURE_SCHEM} - String - the procedure schema name
(possibly null)
- {@code PROCEDURE_NAME} - String - the procedure name
- {@code COLUMN_NAME} - String - the name of the column
- {@code COLUMN_TYPE} - short - the kind of column or parameter, as
follows:
- {@code DatabaseMetaData.procedureColumnUnknown} - type unknown
- {@code DatabaseMetaData.procedureColumnIn} - an {@code IN} parameter
- {@code DatabaseMetaData.procedureColumnInOut} - an {@code INOUT}
parameter
- {@code DatabaseMetaData.procedureColumnOut} - an {@code OUT}
parameter
- {@code DatabaseMetaData.procedureColumnReturn} - a return value
- {@code DatabaseMetaData.procedureReturnsResult} - a result column in
a result set
- {@code DATA_TYPE} - int - the SQL type of the data, as in {@code
java.sql.Types}
- {@code TYPE_NAME} - String - the SQL type name, for a UDT it is fully
qualified
- {@code PRECISION} - int - the precision
- {@code LENGTH} - int - the length of the data in bytes
- {@code SCALE} - short - the scale for numeric types
- {@code RADIX} - short - the Radix for numeric data (typically 2 or
10)
- {@code NULLABLE} - short - can the data contain {@code null}:
- {@code DatabaseMetaData.procedureNoNulls} - {@code NULL}s not
permitted
- {@code DatabaseMetaData.procedureNullable} - {@code NULL}s are
permitted
- {@code DatabaseMetaData.procedureNullableUnknown} - {@code NULL}
status unknown
- {@code REMARKS} - String - an explanatory comment about the data item
|
| public java.lang.String | getProcedureTerm()Returns the database vendor's preferred name for "procedure".
|
| public java.sql.ResultSet | getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedureNamePattern)Returns a list of the stored procedures available in a specified catalog.
The list is returned as a {@code ResultSet} with one row for each stored
procedure, ordered by PROCEDURE_SCHEM and PROCEDURE_NAME, with the data
in each row as follows:
- {@code PROCEDURE_CAT} - String : the procedure catalog name
- {@code PROCEDURE_SCHEM} - String : the procedure schema name
(possibly {@code null})
- {@code PROCEDURE_NAME} - String : the procedure name
- {@code Reserved}
- {@code Reserved}
- {@code Reserved}
- {@code REMARKS} - String - information about the procedure
- {@code PROCEDURE_TYPE} - short : one of:
- {@code DatabaseMetaData.procedureResultUnknown} - procedure may
return a result
- {@code DatabaseMetaData.procedureNoResult} - procedure does not
return a result
- {@code DatabaseMetaData.procedureReturnsResult} - procedure
definitely returns a result
|
| public int | getResultSetHoldability()Returns the result set's default holdability.
|
| public java.lang.String | getSQLKeywords()Returns a list of all the SQL keywords that are NOT also SQL92 keywords
for the database.
|
| public int | getSQLStateType()States the type of {@code SQLState} value returned by {@code
SQLException.getSQLState}. This can either be the X/Open (now known as
Open Group) SQL CLI form or the SQL99 form.
|
| public java.lang.String | getSchemaTerm()Returns the database vendor's preferred term for "schema".
|
| public java.sql.ResultSet | getSchemas()Returns a list of the schema names in the database. The list is returned
as a {@code ResultSet}, ordered by the schema name, with one row per
schema in the following format:
- {@code TABLE_SCHEM} - String - the schema name
- {@code
TABLE_CATALOG} - String - the catalog name (possibly {@code null})
|
| public java.lang.String | getSearchStringEscape()Returns the string that is used to escape wildcard characters. This
string is used to escape the {@code '_'} and {@code '%'} wildcard
characters in catalog search pattern strings. {@code '_'} is used to represent any single
character while {@code '%'} is used for a sequence of zero or more
characters.
|
| public java.lang.String | getStringFunctions()Returns a list of string functions available with the database. These
functions are used in JDBC function escape clause and follow the Open
Group CLI string function names definition.
|
| public java.sql.ResultSet | getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)Returns a listing of the hierarchies of tables in a specified schema in
the database.
The listing only contains entries for tables that have a super table.
Super tables and corresponding subtables must be defined in the same catalog and schema. The
list is returned as a {@code ResultSet}, with one row for each table that
has a super table, in the following format:
- {@code TABLE_CAT} - String - table catalog name (possibly {@code
null})
- {@code TABLE_SCHEM} - String - Table schema name (possibly {@code
null})
- {@code TABLE_NAME} - String - The table name
- SUPER{@code TABLE_NAME} - String - The super table name
|
| public java.sql.ResultSet | getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern)Returns the User Defined Type (UDT) hierarchies for a given schema. Only
the immediate parent/child relationship is described. If a UDT does not
have a direct supertype, it is not listed.
The listing is returned as a {@code ResultSet} where there is one row for
a specific UDT which describes its supertype, with the data organized in
columns as follows:
- {@code TYPE_CAT} - String - the UDT catalog name (possibly {@code
null})
- {@code TYPE_SCHEM} - String - the UDT schema name (possibly {@code
null})
- {@code TYPE_NAME} - String - the UDT type name
- SUPER{@code TYPE_CAT} - String - direct supertype's catalog name
(possibly {@code null})
- SUPER{@code TYPE_SCHEM} - String - direct supertype's schema name
(possibly {@code null})
- SUPER{@code TYPE_NAME} - String - direct supertype's name
|
| public java.lang.String | getSystemFunctions()Returns a list of system functions available with the database. These are
names used in the JDBC function escape clause and are Open Group CLI
function names.
|
| public java.sql.ResultSet | getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern)Returns a description of access rights for each table present in a
catalog. Table privileges can apply to one or more columns in the table -
but are not guaranteed to apply to all columns.
The privileges are returned as a {@code ResultSet}, with one row for each
privilege, ordered by {@code TABLE_SCHEM}, {@code TABLE_NAME}, {@code
PRIVILEGE}, and each row has data as defined in the following column
definitions:
- {@code TABLE_CAT} - String - table catalog name (possibly {@code
null})
- {@code TABLE_SCHEM} - String - Table schema name (possibly {@code
null})
- {@code TABLE_NAME} - String - The table name
- GRANTOR - String - who granted the access
- GRANTEE - String - who received the access grant
- PRIVILEGE - String - the type of access granted - one of SELECT,
INSERT, UPDATE, REFERENCES,...
- IS_GRANTABLE - String - {@code "YES"} implies the grantee can grant
access to others, {@code "NO"} implies guarantee cannot grant access to
others, {@code null} means this status is unknown
|
| public java.sql.ResultSet | getTableTypes()Returns a list of table types supported by the database.
The list is returned as a {@code ResultSet} with one row per table type,
ordered by the table type. The information in the {@code ResultSet} is
structured into a single column per row, as follows:
- {@code TABLE_TYPE} - String - the table type. Typical names include
{@code "TABLE"}, {@code "VIEW"}, "{@code SYSTEM TABLE"}, {@code "ALIAS"},
{@code "SYNONYM"}, {@code "GLOBAL TEMPORARY"}
|
| public java.sql.ResultSet | getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tableNamePattern, java.lang.String[] types)Returns a description of the tables in a specified catalog.
The descriptions are returned as rows in a {@code ResultSet}, one row for
each Table. The ResultSet is ordered by {@code TABLE_TYPE}, {@code
TABLE_SCHEM} and {@code TABLE_NAME}. Each row in the ResultSet consists
of a series of columns as follows:
- {@code TABLE_CAT} - String - table catalog name (possibly {@code
null})
- {@code TABLE_SCHEM} - String - Table schema name (possibly {@code
null})
- {@code TABLE_NAME} - String - The table name
- {@code TABLE_TYPE} - String - Typical names include "TABLE", "VIEW",
"SYSTEM TABLE", "ALIAS", "SYNONYM", "GLOBAL TEMPORARY"
- {@code REMARKS} - String - A comment describing the table
- {@code TYPE_CAT} - String - the 'Types' catalog(possibly {@code null}
)
- {@code TYPE_SCHEM} - String - the 'Types' schema(possibly {@code
null})
- {@code TYPE_NAME} - String - the 'Types' name (possibly {@code null})
- {@code SELF_REFERENCING_COL_NAME} - String - the name of a designated
identifier column in a typed table (possibly {@code null})
- REF_GENERATION - String - one of the following values : "SYSTEM" |
"USER" | "DERIVED" - specifies how values in the {@code
SELF_REFERENCING_COL_NAME} are created (possibly {@code null})
|
| public java.lang.String | getTimeDateFunctions()Returns a list of time and date functions available for the database.
|
| public java.sql.ResultSet | getTypeInfo()Get a list of the standard SQL types supported by this database. The list
is returned as a {@code ResultSet}, with one row for each type, ordered
by the {@code DATA_TYPE} value, where the data in each row is structured
into the following columns:
- {@code TYPE_NAME} - String : the type name
- {@code DATA_TYPE} - int : the SQL data type value as defined in
{@code java.sql.Types}
- {@code PRECISION} - int - the maximum precision of the type
- {@code LITERAL_PREFIX} - String : the prefix to be used when quoting
a literal value (possibly {@code null})
- {@code LITERAL_SUFFIX} - String : the suffix to be used when quoting
a literal value (possibly {@code null})
- {@code CREATE_PARAMS} - String : params used when creating the type
(possibly {@code null})
- {@code NULLABLE} - short : shows if the value is nullable:
- {@code DatabaseMetaData.typeNoNulls} : {@code NULL}s not permitted
- {@code DatabaseMetaData.typeNullable} : {@code NULL}s are permitted
- {@code DatabaseMetaData.typeNullableUnknown} : {@code NULL} status
unknown
- {@code CASE_SENSITIVE} - boolean : true if the type is case sensitive
- {@code SEARCHABLE} - short : how this type can be used with {@code WHERE}
clauses:
- {@code DatabaseMetaData.typePredNone} - {@code WHERE} clauses cannot be used
- {@code DatabaseMetaData.typePredChar} - support for {@code
WHERE...LIKE} only
- {@code DatabaseMetaData.typePredBasic} - support except for {@code
WHERE...LIKE}
- {@code DatabaseMetaData.typeSearchable} - support for all {@code
WHERE} clauses
- {@code UNSIGNED_ATTRIBUTE} - boolean - the type is unsigned or not
- {@code FIXED_PREC_SCALE} - boolean - fixed precision = it can be used
as a money value
- {@code AUTO_INCREMENT} - boolean - can be used as an auto-increment
value
- {@code LOCAL_TYPE_NAME} - String - a localized version of the type
name (possibly {@code null})
- {@code MINIMUM_SCALE} - short - the minimum scale supported
- {@code MAXIMUM_SCALE} - short - the maximum scale supported
- {@code SQL_DATA_TYPE} - int - not used
- {@code SQL_DATETIME_SUB} - int - not used
- {@code NUM_PREC_RADIX} - int - number radix (typically 2 or 10)
|
| public java.sql.ResultSet | getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typeNamePattern, int[] types)Returns a description of the User Defined Types (UDTs) defined in a given
schema, which includes the types {@code DISTINCT}, {@code STRUCT} and
{@code JAVA_OBJECT}.
The types matching the supplied the specified catalog, schema, type name
and type are returned as rows in a {@code ResultSet} with columns of
information as follows:
- {@code TABLE_CAT} - String - catalog name (possibly {@code null})
- {@code TABLE_SCHEM} - String - schema name (possibly {@code null})
- {@code TABLE_NAME} - String - The table name
- {@code CLASS_NAME} - String - The Java class name
- {@code DATA_TYPE} - int - The SQL type as specified in {@code
java.sql.Types}. One of DISTINCT, STRUCT, and JAVA_OBJECT
- {@code REMARKS} - String - A comment which describes the type
- {@code BASE_TYPE} - short - A type code. For a DISTINCT type, the
source type. For a structured type this is the type that implements the
user generated reference type of the {@code SELF_REFERENCING_COLUMN}.
This is defined in {@code java.sql.Types}, and will be {@code null} if
the {@code DATA_TYPE} does not match these criteria.
If the driver does not support UDTs, the {@code ResultSet} is empty.
|
| public java.lang.String | getURL()Returns the URL for this database.
|
| public java.lang.String | getUserName()Determine the user name as known by the database.
|
| public java.sql.ResultSet | getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String table)Returns which of a table's columns are automatically updated when any
value in a row is updated.
The result is laid-out in the following columns:
- {@code SCOPE} - short - not used
- {@code COLUMN_NAME} - String - Column name
- {@code DATA_TYPE} - int - The SQL data type, as defined in {@code
java.sql.Types}
- {@code TYPE_NAME} - String - The SQL type name, data source dependent
- {@code COLUMN_SIZE} - int - Precision for numeric types
- {@code BUFFER_LENGTH} - int - Length of a column value in bytes
- {@code DECIMAL_DIGITS} - short - Number of digits after the decimal
point
- {@code PSEUDO_COLUMN} - short - If this is a pseudo-column (for
example, an Oracle {@code ROWID}):
- {@code DatabaseMetaData.bestRowUnknown} - don't know whether this is
a pseudo column
- {@code DatabaseMetaData.bestRowNotPseudo} - column is not pseudo
- {@code DatabaseMetaData.bestRowPseudo} - column is a pseudo column
|
| public boolean | insertsAreDetected(int type)Determines whether a visible row insert can be detected by calling {@code
ResultSet.rowInserted}.
|
| public boolean | isCatalogAtStart()Determine whether a fully qualified table name is prefixed or suffixed to
a fully qualified table name.
|
| public boolean | isReadOnly()Determines whether the database is in read-only mode.
|
| public boolean | locatorsUpdateCopy()Determines whether updates are made to a copy of, or directly on, Large Objects
({@code LOB}s).
|
| public boolean | nullPlusNonNullIsNull()Determines whether the database handles concatenations between {@code NULL} and
non-{@code NULL} values by producing a {@code NULL} output.
|
| public boolean | nullsAreSortedAtEnd()Determines whether {@code NULL} values are always sorted to the end of sorted
results regardless of requested sort order. This means that they will
appear at the end of sorted lists whatever other non-{@code NULL} values
may be present.
|
| public boolean | nullsAreSortedAtStart()Determines whether {@code NULL} values are always sorted at the start of the
sorted list, irrespective of the sort order. This means that they appear
at the start of sorted lists, whatever other values may be present.
|
| public boolean | nullsAreSortedHigh()Determines whether {@code NULL} values are sorted high - i.e. they are sorted
as if they are higher than any other values.
|
| public boolean | nullsAreSortedLow()Determines whether {@code NULL} values are sorted low - i.e. they are sorted as
if they are lower than any other values.
|
| public boolean | othersDeletesAreVisible(int type)Determines whether deletes made by others are visible, for a specified {@code
ResultSet} type.
|
| public boolean | othersInsertsAreVisible(int type)Determines whether inserts made by others are visible, for a specified {@code
ResultSet} type.
|
| public boolean | othersUpdatesAreVisible(int type)Determines whether updates made by others are visible, for a specified {@code
ResultSet} type.
|
| public boolean | ownDeletesAreVisible(int type)Determines whether a {@code ResultSet} can see its own deletes, for a
specified {@code ResultSet} type.
|
| public boolean | ownInsertsAreVisible(int type)Determines whether a {@code ResultSet} can see its own inserts, for a
specified {@code ResultSet} type.
|
| public boolean | ownUpdatesAreVisible(int type)Determines whether a {@code ResultSet} can see its own updates, for a
specified {@code ResultSet} type.
|
| public boolean | storesLowerCaseIdentifiers()Determines whether the database treats SQL identifiers that are in mixed
case (and unquoted) as case insensitive. If {@code true} then the
database stores them in lower case.
|
| public boolean | storesLowerCaseQuotedIdentifiers()Determines whether the database considers mixed case quoted SQL
identifiers as case insensitive and stores them in lower case.
|
| public boolean | storesMixedCaseIdentifiers()Determines whether the database considers mixed case unquoted SQL
identifiers as case insensitive and stores them in mixed case.
|
| public boolean | storesMixedCaseQuotedIdentifiers()Determines whether the database considers identifiers as case insensitive
if they are mixed case quoted SQL. The database stores them in mixed
case.
|
| public boolean | storesUpperCaseIdentifiers()Determines whether the database considers mixed case unquoted SQL
identifiers as case insensitive and stores them in upper case.
|
| public boolean | storesUpperCaseQuotedIdentifiers()Determines whether the database considers mixed case quoted SQL
identifiers as case insensitive and stores them in upper case.
|
| public boolean | supportsANSI92EntryLevelSQL()Determines whether the database supports the ANSI92 entry level SQL grammar.
|
| public boolean | supportsANSI92FullSQL()Determines whether the database supports the ANSI92 full SQL grammar.
|
| public boolean | supportsANSI92IntermediateSQL()Determines whether the database supports the ANSI92 intermediate SQL Grammar.
|
| public boolean | supportsAlterTableWithAddColumn()Determines whether the database supports {@code ALTER TABLE} operation with
{@code ADD COLUMN}.
|
| public boolean | supportsAlterTableWithDropColumn()Determines whether the database supports {@code ALTER TABLE} operation with
{@code DROP COLUMN}.
|
| public boolean | supportsBatchUpdates()Determines whether the database supports batch updates.
|
| public boolean | supportsCatalogsInDataManipulation()Determines whether catalog names may be used in data manipulation
statements.
|
| public boolean | supportsCatalogsInIndexDefinitions()Determines whether catalog names can be used in index definition statements.
|
| public boolean | supportsCatalogsInPrivilegeDefinitions()Determines whether catalog names can be used in privilege definition
statements.
|
| public boolean | supportsCatalogsInProcedureCalls()Determines whether catalog names can be used in procedure call statements.
|
| public boolean | supportsCatalogsInTableDefinitions()Determines whether catalog names may be used in table definition statements.
|
| public boolean | supportsColumnAliasing()Determines whether the database supports column aliasing.
If aliasing is supported, then the SQL AS clause is used to provide names
for computed columns and provide alias names for columns.
|
| public boolean | supportsConvert()Determines whether the database supports the {@code CONVERT} operation between
SQL types.
|
| public boolean | supportsConvert(int fromType, int toType)Determines whether the database supports {@code CONVERT} operation for two
supplied SQL types.
|
| public boolean | supportsCoreSQLGrammar()Determines whether the database supports the Core SQL Grammar for ODBC.
|
| public boolean | supportsCorrelatedSubqueries()Determines whether the database supports correlated sub-queries.
|
| public boolean | supportsDataDefinitionAndDataManipulationTransactions()Determines whether the database allows both data definition and data
manipulation statements inside a transaction.
|
| public boolean | supportsDataManipulationTransactionsOnly()Determines whether the database only allows data manipulation statements inside
a transaction.
|
| public boolean | supportsDifferentTableCorrelationNames()Determines whether table correlation names are required to be different from
the names of the tables, when they are supported.
|
| public boolean | supportsExpressionsInOrderBy()Determines whether expressions in {@code ORDER BY} lists are supported.
|
| public boolean | supportsExtendedSQLGrammar()Determines whether the Extended SQL Grammar for ODBC is supported.
|
| public boolean | supportsFullOuterJoins()Determines whether the database supports full nested outer joins.
|
| public boolean | supportsGetGeneratedKeys()Determines whether auto generated keys can be returned when a statement
executes.
|
| public boolean | supportsGroupBy()Determines whether the database supports {@code GROUP BY} clauses.
|
| public boolean | supportsGroupByBeyondSelect()Determines whether the database supports using a column name in a {@code GROUP
BY} clause not included in the {@code SELECT} statement as long as all of
the columns in the {@code SELECT} statement are used in the {@code GROUP
BY} clause.
|
| public boolean | supportsGroupByUnrelated()Determines whether the database supports using a column name in a {@code GROUP
BY} clause that is not in the {@code SELECT} statement.
|
| public boolean | supportsIntegrityEnhancementFacility()Determines whether the database supports SQL Integrity Enhancement
Facility.
|
| public boolean | supportsLikeEscapeClause()Determines whether the database supports a {@code LIKE} escape clause.
|
| public boolean | supportsLimitedOuterJoins()Determines whether the database provides limited support for outer join
operations.
|
| public boolean | supportsMinimumSQLGrammar()Determines whether the database supports Minimum SQL Grammar for ODBC.
|
| public boolean | supportsMixedCaseIdentifiers()Determines whether the database treats mixed case unquoted SQL identifiers as
case sensitive storing them in mixed case.
|
| public boolean | supportsMixedCaseQuotedIdentifiers()Determines whether the database considers mixed case quoted SQL
identifiers as case sensitive, storing them in mixed case.
|
| public boolean | supportsMultipleOpenResults()Determines whether it is possible for a single {@code CallableStatement} to
return multiple {@code ResultSet}s simultaneously.
|
| public boolean | supportsMultipleResultSets()Determines whether retrieving multiple {@code ResultSet}s from a single
call to the {@code execute} method is supported.
|
| public boolean | supportsMultipleTransactions()Determines whether multiple simultaneous transactions on
different connections are supported.
|
| public boolean | supportsNamedParameters()Determines whether callable statements with named parameters is supported.
|
| public boolean | supportsNonNullableColumns()Determines whether columns in the database can be defined as non-nullable.
|
| public boolean | supportsOpenCursorsAcrossCommit()Determines whether keeping cursors open across commit operations is
supported.
|
| public boolean | supportsOpenCursorsAcrossRollback()Determines whether the database can keep cursors open across rollback
operations.
|
| public boolean | supportsOpenStatementsAcrossCommit()Determines whether keeping statements open across commit operations is
supported.
|
| public boolean | supportsOpenStatementsAcrossRollback()Determines whether keeping statements open across rollback operations is
supported.
|
| public boolean | supportsOrderByUnrelated()Determines whether using a column in an {@code ORDER BY} clause that is
not in the {@code SELECT} statement is supported.
|
| public boolean | supportsOuterJoins()Determines whether outer join operations are supported.
|
| public boolean | supportsPositionedDelete()Determines whether positioned {@code DELETE} statements are supported.
|
| public boolean | supportsPositionedUpdate()Determines whether positioned {@code UPDATE} statements are supported.
|
| public boolean | supportsResultSetConcurrency(int type, int concurrency)Determines whether there is support for a given concurrency style for the
given {@code ResultSet}.
|
| public boolean | supportsResultSetHoldability(int holdability)Determines whether the supplied {@code ResultSet} holdability mode is
supported.
|
| public boolean | supportsResultSetType(int type)Determines whether the supplied {@code ResultSet} type is supported.
|
| public boolean | supportsSavepoints()Determines whether savepoints for transactions are supported.
|
| public boolean | supportsSchemasInDataManipulation()Determines whether a schema name may be used in a data manipulation
statement.
|
| public boolean | supportsSchemasInIndexDefinitions()Determines whether a schema name may be used in an index definition
statement.
|
| public boolean | supportsSchemasInPrivilegeDefinitions()Determines whether a database schema name can be used in a privilege
definition statement.
|
| public boolean | supportsSchemasInProcedureCalls()Determines whether a procedure call statement may be contain in a schema name.
|
| public boolean | supportsSchemasInTableDefinitions()Determines whether a schema name can be used in a table definition statement.
|
| public boolean | supportsSelectForUpdate()Determines whether the {@code SELECT FOR UPDATE} statement is supported.
|
| public boolean | supportsStatementPooling()Determines whether statement pooling is supported.
|
| public boolean | supportsStoredProcedures()Determines whether stored procedure calls using the stored procedure
escape syntax is supported.
|
| public boolean | supportsSubqueriesInComparisons()Determines whether subqueries in comparison expressions are supported.
|
| public boolean | supportsSubqueriesInExists()Determines whether subqueries in {@code EXISTS} expressions are supported.
|
| public boolean | supportsSubqueriesInIns()Determines whether subqueries in {@code IN} statements are supported.
|
| public boolean | supportsSubqueriesInQuantifieds()Determines whether subqueries in quantified expressions are supported.
|
| public boolean | supportsTableCorrelationNames()Determines whether the database has table correlation names support.
|
| public boolean | supportsTransactionIsolationLevel(int level)Determines whether a specified transaction isolation level is supported.
|
| public boolean | supportsTransactions()Determines whether transactions are supported.
If transactions are not supported, then the {@code commit} method does
nothing and the transaction isolation level is always {@code
TRANSACTION_NONE}.
|
| public boolean | supportsUnion()Determines whether the {@code SQL UNION} operation is supported.
|
| public boolean | supportsUnionAll()Determines whether the {@code SQL UNION ALL} operation is supported.
|
| public boolean | updatesAreDetected(int type)Determines whether the method {@code ResultSet.rowUpdated} can detect a visible
row update for the specified {@code ResultSet} type.
|
| public boolean | usesLocalFilePerTable()Determines whether this database uses a file for each table.
|
| public boolean | usesLocalFiles()Determines whether this database uses a local file to store tables.
|
