Represents the meta data for a database.
Methods |
boolean |
allProceduresAreCallable()
Checks if all procedures callable.
|
boolean |
allProceduresAreCallable()
Checks if all procedures callable.
Returns:
true
|
boolean |
allTablesAreSelectable()
Checks if it possible to query all tables returned by getTables.
|
boolean |
allTablesAreSelectable()
Checks if it possible to query all tables returned by getTables.
Returns:
true
|
boolean |
autoCommitFailureClosesAllResultSets()
Returns whether an exception while auto commit is on closes all result
sets.
|
boolean |
autoCommitFailureClosesAllResultSets()
Returns whether an exception while auto commit is on closes all result
sets.
Returns:
false
|
boolean |
dataDefinitionCausesTransactionCommit()
Returns whether CREATE/DROP commit an open transaction.
|
boolean |
dataDefinitionCausesTransactionCommit()
Returns whether CREATE/DROP commit an open transaction.
Returns:
true
|
boolean |
dataDefinitionIgnoredInTransactions()
Returns whether CREATE/DROP do not affect transactions.
|
boolean |
dataDefinitionIgnoredInTransactions()
Returns whether CREATE/DROP do not affect transactions.
Returns:
false
|
boolean |
deletesAreDetected(int type)
Returns whether deletes are detected.
|
boolean |
deletesAreDetected(int type)
Returns whether deletes are detected.
Parameters:
type - the result set type
Returns:
false
|
boolean |
doesMaxRowSizeIncludeBlobs()
Returns whether the maximum row size includes blobs.
|
boolean |
doesMaxRowSizeIncludeBlobs()
Returns whether the maximum row size includes blobs.
Returns:
false
|
boolean |
generatedKeyAlwaysReturned()
[Not supported]
|
boolean |
generatedKeyAlwaysReturned()
[Not supported]
|
ResultSet |
getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
[Not supported]
|
ResultSet |
getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
[Not supported]
|
ResultSet |
getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable)
Gets the list of columns that best identifier a row in a table.
|
ResultSet |
getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName, int scope, boolean nullable) throws SQLException
Gets the list of columns that best identifier a row in a table.
The list is ordered by SCOPE.
- 1 SCOPE (short) scope of result (always bestRowSession)
- 2 COLUMN_NAME (String) column name
- 3 DATA_TYPE (short) SQL data type, see also java.sql.Types
- 4 TYPE_NAME (String) type name
- 5 COLUMN_SIZE (int) precision
(values larger than 2 GB are returned as 2 GB)
- 6 BUFFER_LENGTH (int) unused
- 7 DECIMAL_DIGITS (short) scale
- 8 PSEUDO_COLUMN (short) (always bestRowNotPseudo)
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableName - table name (must be specified)
scope - ignored
nullable - ignored
Returns:
the primary key index
Throws:
SQLException - if the connection is closed
|
String |
getCatalogSeparator()
Returns the catalog separator.
|
String |
getCatalogSeparator()
Returns the catalog separator.
Returns:
"."
|
String |
getCatalogTerm()
Returns the term for "catalog".
|
String |
getCatalogTerm()
Returns the term for "catalog".
Returns:
"catalog"
|
ResultSet |
getCatalogs()
Gets the list of catalogs.
|
ResultSet |
getCatalogs() throws SQLException
Gets the list of catalogs.
The result set is sorted by TABLE_CAT.
- 1 TABLE_CAT (String) catalog name
Returns:
the catalog list
Throws:
SQLException - if the connection is closed
|
ResultSet |
getClientInfoProperties()
[Not supported] Returns the client info properties.
|
ResultSet |
getClientInfoProperties() throws SQLException
[Not supported] Returns the client info properties.
|
ResultSet |
getColumnPrivileges(String catalogPattern, String schemaPattern, String table, String columnNamePattern)
Gets the list of column privileges.
|
ResultSet |
getColumnPrivileges(String catalogPattern, String schemaPattern, String table, String columnNamePattern) throws SQLException
Gets the list of column privileges. The result set is sorted by
COLUMN_NAME and PRIVILEGE
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 COLUMN_NAME (String) column name
- 5 GRANTOR (String) grantor of access
- 6 GRANTEE (String) grantee of access
- 7 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES
(only one per row)
- 8 IS_GRANTABLE (String) YES means the grantee can grant access to
others
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
table - a table name (uppercase for unquoted names)
columnNamePattern - null (to get all objects) or a column name
(uppercase for unquoted names)
Returns:
the list of privileges
Throws:
SQLException - if the connection is closed
|
ResultSet |
getColumns(String catalogPattern, String schemaPattern, String tableNamePattern, String columnNamePattern)
Gets the list of columns.
|
ResultSet |
getColumns(String catalogPattern, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
Gets the list of columns. The result set is sorted by TABLE_SCHEM,
TABLE_NAME, and ORDINAL_POSITION.
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 COLUMN_NAME (String) column name
- 5 DATA_TYPE (short) data type (see java.sql.Types)
- 6 TYPE_NAME (String) data type name ("INTEGER", "VARCHAR",...)
- 7 COLUMN_SIZE (int) precision
(values larger than 2 GB are returned as 2 GB)
- 8 BUFFER_LENGTH (int) unused
- 9 DECIMAL_DIGITS (int) scale (0 for INTEGER and VARCHAR)
- 10 NUM_PREC_RADIX (int) radix (always 10)
- 11 NULLABLE (int) columnNoNulls or columnNullable
- 12 REMARKS (String) comment (always empty)
- 13 COLUMN_DEF (String) default value
- 14 SQL_DATA_TYPE (int) unused
- 15 SQL_DATETIME_SUB (int) unused
- 16 CHAR_OCTET_LENGTH (int) unused
- 17 ORDINAL_POSITION (int) the column index (1,2,...)
- 18 IS_NULLABLE (String) "NO" or "YES"
- 19 SCOPE_CATALOG (String) always null
- 20 SCOPE_SCHEMA (String) always null
- 21 SCOPE_TABLE (String) always null
- 22 SOURCE_DATA_TYPE (short) null
- 23 IS_AUTOINCREMENT (String) "NO" or "YES"
- 24 SCOPE_CATLOG (String) always null (the typo is on purpose,
for compatibility with the JDBC specification prior to 4.1)
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)
columnNamePattern - null (to get all objects) or a column name
(uppercase for unquoted names)
Returns:
the list of columns
Throws:
SQLException - if the connection is closed
|
Connection |
getConnection()
Returns the connection that created this object.
|
Connection |
getConnection()
Returns the connection that created this object.
Returns:
the connection
|
ResultSet |
getCrossReference(String primaryCatalogPattern, String primarySchemaPattern, String primaryTable, String foreignCatalogPattern, String foreignSchemaPattern, String foreignTable)
Gets the list of foreign key columns that references a table, as well as
the list of primary key columns that are references by a table.
|
ResultSet |
getCrossReference(String primaryCatalogPattern, String primarySchemaPattern, String primaryTable, String foreignCatalogPattern, String foreignSchemaPattern, String foreignTable) throws SQLException
Gets the list of foreign key columns that references a table, as well as
the list of primary key columns that are references by a table. The
result set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME,
FK_NAME, KEY_SEQ.
- 1 PKTABLE_CAT (String) primary catalog
- 2 PKTABLE_SCHEM (String) primary schema
- 3 PKTABLE_NAME (String) primary table
- 4 PKCOLUMN_NAME (String) primary column
- 5 FKTABLE_CAT (String) foreign catalog
- 6 FKTABLE_SCHEM (String) foreign schema
- 7 FKTABLE_NAME (String) foreign table
- 8 FKCOLUMN_NAME (String) foreign column
- 9 KEY_SEQ (short) sequence number (1,2,...)
- 10 UPDATE_RULE (short) action on update (see
DatabaseMetaData.importedKey...)
- 11 DELETE_RULE (short) action on delete (see
DatabaseMetaData.importedKey...)
- 12 FK_NAME (String) foreign key name
- 13 PK_NAME (String) primary key name
- 14 DEFERRABILITY (short) deferrable or not (always
importedKeyNotDeferrable)
Parameters:
primaryCatalogPattern - null or the catalog name
primarySchemaPattern - the schema name of the primary table
(optional)
primaryTable - the name of the primary table (must be specified)
foreignCatalogPattern - null or the catalog name
foreignSchemaPattern - the schema name of the foreign table
(optional)
foreignTable - the name of the foreign table (must be specified)
Returns:
the result set
Throws:
SQLException - if the connection is closed
|
int |
getDatabaseMajorVersion()
Gets the major version of the database.
|
int |
getDatabaseMajorVersion()
Gets the major version of the database.
Returns:
the major version
|
int |
getDatabaseMinorVersion()
Gets the minor version of the database.
|
int |
getDatabaseMinorVersion()
Gets the minor version of the database.
Returns:
the minor version
|
String |
getDatabaseProductName()
Gets the database product name.
|
String |
getDatabaseProductName()
Gets the database product name.
Returns:
the product name ("H2")
|
String |
getDatabaseProductVersion()
Gets the product version of the database.
|
String |
getDatabaseProductVersion()
Gets the product version of the database.
Returns:
the product version
|
int |
getDefaultTransactionIsolation()
Returns the default transaction isolation level.
|
int |
getDefaultTransactionIsolation()
Returns the default transaction isolation level.
Returns:
Connection.TRANSACTION_READ_COMMITTED
|
int |
getDriverMajorVersion()
Returns the major version of this driver.
|
int |
getDriverMajorVersion()
Returns the major version of this driver.
Returns:
the major version number
|
int |
getDriverMinorVersion()
Returns the minor version of this driver.
|
int |
getDriverMinorVersion()
Returns the minor version of this driver.
Returns:
the minor version number
|
String |
getDriverName()
Gets the name of the JDBC driver.
|
String |
getDriverName()
Gets the name of the JDBC driver.
Returns:
the driver name ("H2 JDBC Driver")
|
String |
getDriverVersion()
Gets the version number of the driver.
|
String |
getDriverVersion()
Gets the version number of the driver. The format is
[MajorVersion].[MinorVersion].
Returns:
the version number
|
ResultSet |
getExportedKeys(String catalogPattern, String schemaPattern, String tableName)
Gets the list of foreign key columns that reference a table.
|
ResultSet |
getExportedKeys(String catalogPattern, String schemaPattern, String tableName) throws SQLException
Gets the list of foreign key columns that reference a table. The result
set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME,
KEY_SEQ.
- 1 PKTABLE_CAT (String) primary catalog
- 2 PKTABLE_SCHEM (String) primary schema
- 3 PKTABLE_NAME (String) primary table
- 4 PKCOLUMN_NAME (String) primary column
- 5 FKTABLE_CAT (String) foreign catalog
- 6 FKTABLE_SCHEM (String) foreign schema
- 7 FKTABLE_NAME (String) foreign table
- 8 FKCOLUMN_NAME (String) foreign column
- 9 KEY_SEQ (short) sequence number (1,2,...)
- 10 UPDATE_RULE (short) action on update (see
DatabaseMetaData.importedKey...)
- 11 DELETE_RULE (short) action on delete (see
DatabaseMetaData.importedKey...)
- 12 FK_NAME (String) foreign key name
- 13 PK_NAME (String) primary key name
- 14 DEFERRABILITY (short) deferrable or not (always
importedKeyNotDeferrable)
Parameters:
catalogPattern - null or the catalog name
schemaPattern - the schema name of the primary table
tableName - the name of the primary table
Returns:
the result set
Throws:
SQLException - if the connection is closed
|
String |
()
Returns the characters that are allowed for identifiers in addiction to
A-Z, a-z, 0-9 and '_'.
|
String |
()
Returns the characters that are allowed for identifiers in addiction to
A-Z, a-z, 0-9 and '_'.
Returns:
an empty String ("")
|
ResultSet |
getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern)
[Not supported] Gets the list of function columns.
|
ResultSet |
getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException
[Not supported] Gets the list of function columns.
|
ResultSet |
getFunctions(String catalog, String schemaPattern, String functionNamePattern)
[Not supported] Gets the list of functions.
|
ResultSet |
getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException
[Not supported] Gets the list of functions.
|
String |
getIdentifierQuoteString()
Returns the string used to quote identifiers.
|
String |
getIdentifierQuoteString()
Returns the string used to quote identifiers.
Returns:
a double quote
|
ResultSet |
getImportedKeys(String catalogPattern, String schemaPattern, String tableName)
Gets the list of primary key columns that are referenced by a table.
|
ResultSet |
getImportedKeys(String catalogPattern, String schemaPattern, String tableName) throws SQLException
Gets the list of primary key columns that are referenced by a table. The
result set is sorted by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME,
FK_NAME, KEY_SEQ.
- 1 PKTABLE_CAT (String) primary catalog
- 2 PKTABLE_SCHEM (String) primary schema
- 3 PKTABLE_NAME (String) primary table
- 4 PKCOLUMN_NAME (String) primary column
- 5 FKTABLE_CAT (String) foreign catalog
- 6 FKTABLE_SCHEM (String) foreign schema
- 7 FKTABLE_NAME (String) foreign table
- 8 FKCOLUMN_NAME (String) foreign column
- 9 KEY_SEQ (short) sequence number (1, 2, ...)
- 10 UPDATE_RULE (short) action on update (see
DatabaseMetaData.importedKey...)
- 11 DELETE_RULE (short) action on delete (see
DatabaseMetaData.importedKey...)
- 12 FK_NAME (String) foreign key name
- 13 PK_NAME (String) primary key name
- 14 DEFERRABILITY (short) deferrable or not (always
importedKeyNotDeferrable)
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - the schema name of the foreign table
tableName - the name of the foreign table
Returns:
the result set
Throws:
SQLException - if the connection is closed
|
ResultSet |
getIndexInfo(String catalogPattern, String schemaPattern, String tableName, boolean unique, boolean approximate)
Gets the list of indexes for this database.
|
ResultSet |
getIndexInfo(String catalogPattern, String schemaPattern, String tableName, boolean unique, boolean approximate) throws SQLException
Gets the list of indexes for this database. The primary key index (if
there is one) is also listed, with the name PRIMARY_KEY. The result set
is sorted by NON_UNIQUE ('false' first), TYPE, TABLE_SCHEM, INDEX_NAME,
and ORDINAL_POSITION.
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 NON_UNIQUE (boolean) 'true' if non-unique
- 5 INDEX_QUALIFIER (String) index catalog
- 6 INDEX_NAME (String) index name
- 7 TYPE (short) the index type (always tableIndexOther)
- 8 ORDINAL_POSITION (short) column index (1, 2, ...)
- 9 COLUMN_NAME (String) column name
- 10 ASC_OR_DESC (String) ascending or descending (always 'A')
- 11 CARDINALITY (int) numbers of unique values
- 12 PAGES (int) number of pages use (always 0)
- 13 FILTER_CONDITION (String) filter condition (always empty)
- 14 SORT_TYPE (int) the sort type bit map: 1=DESCENDING,
2=NULLS_FIRST, 4=NULLS_LAST
Parameters:
catalogPattern - null or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableName - table name (must be specified)
unique - only unique indexes
approximate - is ignored
Returns:
the list of indexes and columns
Throws:
SQLException - if the connection is closed
|
int |
getJDBCMajorVersion()
Gets the major version of the supported JDBC API.
|
int |
getJDBCMajorVersion()
Gets the major version of the supported JDBC API.
Returns:
the major version (4)
|
int |
getJDBCMinorVersion()
Gets the minor version of the supported JDBC API.
|
int |
getJDBCMinorVersion()
Gets the minor version of the supported JDBC API.
Returns:
the minor version (0)
|
int |
getMaxBinaryLiteralLength()
Returns the maximum length for hex values (characters).
|
int |
getMaxBinaryLiteralLength()
Returns the maximum length for hex values (characters).
Returns:
0 for limit is unknown
|
int |
getMaxCatalogNameLength()
Returns the maximum length for a catalog name.
|
int |
getMaxCatalogNameLength()
Returns the maximum length for a catalog name.
Returns:
0 for limit is unknown
|
int |
getMaxCharLiteralLength()
Returns the maximum length for literals.
|
int |
getMaxCharLiteralLength()
Returns the maximum length for literals.
Returns:
0 for limit is unknown
|
int |
getMaxColumnNameLength()
Returns the maximum length for column names.
|
int |
getMaxColumnNameLength()
Returns the maximum length for column names.
Returns:
0 for limit is unknown
|
int |
getMaxColumnsInGroupBy()
Returns the maximum number of columns in GROUP BY.
|
int |
getMaxColumnsInGroupBy()
Returns the maximum number of columns in GROUP BY.
Returns:
0 for limit is unknown
|
int |
getMaxColumnsInIndex()
Returns the maximum number of columns in CREATE INDEX.
|
int |
getMaxColumnsInIndex()
Returns the maximum number of columns in CREATE INDEX.
Returns:
0 for limit is unknown
|
int |
getMaxColumnsInOrderBy()
Returns the maximum number of columns in ORDER BY.
|
int |
getMaxColumnsInOrderBy()
Returns the maximum number of columns in ORDER BY.
Returns:
0 for limit is unknown
|
int |
getMaxColumnsInSelect()
Returns the maximum number of columns in SELECT.
|
int |
getMaxColumnsInSelect()
Returns the maximum number of columns in SELECT.
Returns:
0 for limit is unknown
|
int |
getMaxColumnsInTable()
Returns the maximum number of columns in CREATE TABLE.
|
int |
getMaxColumnsInTable()
Returns the maximum number of columns in CREATE TABLE.
Returns:
0 for limit is unknown
|
int |
getMaxConnections()
Returns the maximum number of open connection.
|
int |
getMaxConnections()
Returns the maximum number of open connection.
Returns:
0 for limit is unknown
|
int |
getMaxCursorNameLength()
Returns the maximum length for a cursor name.
|
int |
getMaxCursorNameLength()
Returns the maximum length for a cursor name.
Returns:
0 for limit is unknown
|
int |
getMaxIndexLength()
Returns the maximum length for an index (in bytes).
|
int |
getMaxIndexLength()
Returns the maximum length for an index (in bytes).
Returns:
0 for limit is unknown
|
int |
getMaxProcedureNameLength()
Returns the maximum length for a procedure name.
|
int |
getMaxProcedureNameLength()
Returns the maximum length for a procedure name.
Returns:
0 for limit is unknown
|
int |
getMaxRowSize()
Returns the maximum size of a row (in bytes).
|
int |
getMaxRowSize()
Returns the maximum size of a row (in bytes).
Returns:
0 for limit is unknown
|
int |
getMaxSchemaNameLength()
Returns the maximum length for a schema name.
|
int |
getMaxSchemaNameLength()
Returns the maximum length for a schema name.
Returns:
0 for limit is unknown
|
int |
getMaxStatementLength()
Returns the maximum length of a statement.
|
int |
getMaxStatementLength()
Returns the maximum length of a statement.
Returns:
0 for limit is unknown
|
int |
getMaxStatements()
Returns the maximum number of open statements.
|
int |
getMaxStatements()
Returns the maximum number of open statements.
Returns:
0 for limit is unknown
|
int |
getMaxTableNameLength()
Returns the maximum length for a table name.
|
int |
getMaxTableNameLength()
Returns the maximum length for a table name.
Returns:
0 for limit is unknown
|
int |
getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT.
|
int |
getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT.
Returns:
0 for limit is unknown
|
int |
getMaxUserNameLength()
Returns the maximum length for a user name.
|
int |
getMaxUserNameLength()
Returns the maximum length for a user name.
Returns:
0 for limit is unknown
|
String |
getNumericFunctions()
Returns the list of numeric functions supported by this database.
|
String |
getNumericFunctions() throws SQLException
Returns the list of numeric functions supported by this database.
Returns:
the list
|
ResultSet |
getPrimaryKeys(String catalogPattern, String schemaPattern, String tableName)
Gets the primary key columns for a table.
|
ResultSet |
getPrimaryKeys(String catalogPattern, String schemaPattern, String tableName) throws SQLException
Gets the primary key columns for a table. The result set is sorted by
TABLE_SCHEM, and COLUMN_NAME (and not by KEY_SEQ).
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 COLUMN_NAME (String) column name
- 5 KEY_SEQ (short) the column index of this column (1,2,...)
- 6 PK_NAME (String) the name of the primary key index
Parameters:
catalogPattern - null or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableName - table name (must be specified)
Returns:
the list of primary key columns
Throws:
SQLException - if the connection is closed
|
ResultSet |
getProcedureColumns(String catalogPattern, String schemaPattern, String procedureNamePattern, String columnNamePattern)
Gets the list of procedure columns.
|
ResultSet |
getProcedureColumns(String catalogPattern, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
Gets the list of procedure columns. The result set is sorted by
PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS, and POS.
There are potentially multiple procedures with the same name, each with a
different number of input parameters.
- 1 PROCEDURE_CAT (String) catalog
- 2 PROCEDURE_SCHEM (String) schema
- 3 PROCEDURE_NAME (String) name
- 4 COLUMN_NAME (String) column name
- 5 COLUMN_TYPE (short) column type
(always DatabaseMetaData.procedureColumnIn)
- 6 DATA_TYPE (short) sql type
- 7 TYPE_NAME (String) type name
- 8 PRECISION (int) precision
- 9 LENGTH (int) length
- 10 SCALE (short) scale
- 11 RADIX (int) always 10
- 12 NULLABLE (short) nullable
(DatabaseMetaData.columnNoNulls for primitive data types,
DatabaseMetaData.columnNullable otherwise)
- 13 REMARKS (String) description
- 14 COLUMN_DEF (String) always null
- 15 SQL_DATA_TYPE (int) for future use, always 0
- 16 SQL_DATETIME_SUB (int) for future use, always 0
- 17 CHAR_OCTET_LENGTH (int) always null
- 18 ORDINAL_POSITION (int) the parameter index
starting from 1 (0 is the return value)
- 19 IS_NULLABLE (String) always "YES"
- 20 SPECIFIC_NAME (String) name
Parameters:
catalogPattern - null or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
procedureNamePattern - the procedure name pattern
columnNamePattern - the procedure name pattern
Returns:
the procedure columns
Throws:
SQLException - if the connection is closed
|
String |
getProcedureTerm()
Returns the term for "procedure".
|
String |
getProcedureTerm()
Returns the term for "procedure".
Returns:
"procedure"
|
ResultSet |
getProcedures(String catalogPattern, String schemaPattern, String procedureNamePattern)
Gets the list of procedures.
|
ResultSet |
getProcedures(String catalogPattern, String schemaPattern, String procedureNamePattern) throws SQLException
Gets the list of procedures. The result set is sorted by PROCEDURE_SCHEM,
PROCEDURE_NAME, and NUM_INPUT_PARAMS. There are potentially multiple
procedures with the same name, each with a different number of input
parameters.
- 1 PROCEDURE_CAT (String) catalog
- 2 PROCEDURE_SCHEM (String) schema
- 3 PROCEDURE_NAME (String) name
- 4 NUM_INPUT_PARAMS (int) the number of arguments
- 5 NUM_OUTPUT_PARAMS (int) for future use, always 0
- 6 NUM_RESULT_SETS (int) for future use, always 0
- 7 REMARKS (String) description
- 8 PROCEDURE_TYPE (short) if this procedure returns a result
(procedureNoResult or procedureReturnsResult)
- 9 SPECIFIC_NAME (String) name
Parameters:
catalogPattern - null or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
procedureNamePattern - the procedure name pattern
Returns:
the procedures
Throws:
SQLException - if the connection is closed
|
ResultSet |
getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
[Not supported]
|
ResultSet |
getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
[Not supported]
Parameters:
catalog - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)
columnNamePattern - null (to get all objects) or a column name
(uppercase for unquoted names)
|
int |
getResultSetHoldability()
Gets the result set holdability.
|
int |
getResultSetHoldability()
Gets the result set holdability.
Returns:
ResultSet.CLOSE_CURSORS_AT_COMMIT
|
RowIdLifetime |
getRowIdLifetime()
Get the lifetime of a rowid.
|
RowIdLifetime |
getRowIdLifetime()
Get the lifetime of a rowid.
Returns:
ROWID_UNSUPPORTED
|
String |
getSQLKeywords()
Gets the comma-separated list of all SQL keywords that are not supported
as table/column/index name, in addition to the SQL-92 keywords.
|
String |
getSQLKeywords()
Gets the comma-separated list of all SQL keywords that are not supported
as table/column/index name, in addition to the SQL-92 keywords. The list
returned is:
LIMIT,MINUS,ROWNUM,SYSDATE,SYSTIME,SYSTIMESTAMP,TODAY
The complete list of keywords (including SQL-92 keywords) is:
CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DISTINCT,
EXCEPT, EXISTS, FALSE, FOR, FROM, FULL, GROUP, HAVING, INNER,
INTERSECT, IS, JOIN, LIKE, LIMIT, MINUS, NATURAL, NOT, NULL, ON,
ORDER, PRIMARY, ROWNUM, SELECT, SYSDATE, SYSTIME, SYSTIMESTAMP,
TODAY, TRUE, UNION, UNIQUE, WHERE
Returns:
a list of additional the keywords
|
int |
getSQLStateType()
Gets the SQL State type.
|
int |
getSQLStateType()
Gets the SQL State type.
Returns:
DatabaseMetaData.sqlStateSQL99
|
String |
getSchemaTerm()
Returns the term for "schema".
|
String |
getSchemaTerm()
Returns the term for "schema".
Returns:
"schema"
|
ResultSet |
getSchemas()
Gets the list of schemas.
|
ResultSet |
getSchemas() throws SQLException
Gets the list of schemas.
The result set is sorted by TABLE_SCHEM.
- 1 TABLE_SCHEM (String) schema name
- 2 TABLE_CATALOG (String) catalog name
- 3 IS_DEFAULT (boolean) if this is the default schema
Returns:
the schema list
Throws:
SQLException - if the connection is closed
|
ResultSet |
getSchemas(String catalogPattern, String schemaPattern)
Gets the list of schemas in the database.
|
ResultSet |
getSchemas(String catalogPattern, String schemaPattern) throws SQLException
Gets the list of schemas in the database.
The result set is sorted by TABLE_SCHEM.
- 1 TABLE_SCHEM (String) schema name
- 2 TABLE_CATALOG (String) catalog name
- 3 IS_DEFAULT (boolean) if this is the default schema
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
Returns:
the schema list
Throws:
SQLException - if the connection is closed
|
String |
getSearchStringEscape()
Returns the default escape character for DatabaseMetaData search
patterns.
|
String |
getSearchStringEscape()
Returns the default escape character for DatabaseMetaData search
patterns.
Returns:
the default escape character (always '\', independent on the
mode)
|
String |
getStringFunctions()
Returns the list of string functions supported by this database.
|
String |
getStringFunctions() throws SQLException
Returns the list of string functions supported by this database.
Returns:
the list
|
ResultSet |
getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
Get the list of super tables of a table.
|
ResultSet |
getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException
Get the list of super tables of a table. This method currently returns an
empty result set.
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 SUPERTABLE_NAME (String) the name of the super table
Parameters:
catalog - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name pattern
(uppercase for unquoted names)
Returns:
an empty result set
|
ResultSet |
getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
[Not supported]
|
ResultSet |
getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException
[Not supported]
|
String |
getSystemFunctions()
Returns the list of system functions supported by this database.
|
String |
getSystemFunctions() throws SQLException
Returns the list of system functions supported by this database.
Returns:
the list
|
ResultSet |
getTablePrivileges(String catalogPattern, String schemaPattern, String tableNamePattern)
Gets the list of table privileges.
|
ResultSet |
getTablePrivileges(String catalogPattern, String schemaPattern, String tableNamePattern) throws SQLException
Gets the list of table privileges. The result set is sorted by
TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 GRANTOR (String) grantor of access
- 5 GRANTEE (String) grantee of access
- 6 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES
(only one per row)
- 7 IS_GRANTABLE (String) YES means the grantee can grant access to
others
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)
Returns:
the list of privileges
Throws:
SQLException - if the connection is closed
|
ResultSet |
getTableTypes()
Gets the list of table types.
|
ResultSet |
getTableTypes() throws SQLException
Gets the list of table types. This call returns a result set with three
records: "SYSTEM TABLE", "TABLE", "and "VIEW".
The result set is sorted by TABLE_TYPE.
- 1 TABLE_TYPE (String) table type
Returns:
the table types
Throws:
SQLException - if the connection is closed
|
ResultSet |
getTables(String catalogPattern, String schemaPattern, String tableNamePattern, String[] types)
Gets the list of tables in the database.
|
ResultSet |
getTables(String catalogPattern, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
Gets the list of tables in the database. The result set is sorted by
TABLE_TYPE, TABLE_SCHEM, and TABLE_NAME.
- 1 TABLE_CAT (String) table catalog
- 2 TABLE_SCHEM (String) table schema
- 3 TABLE_NAME (String) table name
- 4 TABLE_TYPE (String) table type
- 5 REMARKS (String) comment
- 6 TYPE_CAT (String) always null
- 7 TYPE_SCHEM (String) always null
- 8 TYPE_NAME (String) always null
- 9 SELF_REFERENCING_COL_NAME (String) always null
- 10 REF_GENERATION (String) always null
- 11 SQL (String) the create table statement or NULL for systems tables
Parameters:
catalogPattern - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)
types - null or a list of table types
Returns:
the list of columns
Throws:
SQLException - if the connection is closed
|
String |
getTimeDateFunctions()
Returns the list of date and time functions supported by this database.
|
String |
getTimeDateFunctions() throws SQLException
Returns the list of date and time functions supported by this database.
Returns:
the list
|
ResultSet |
getTypeInfo()
Gets the list of data types.
|
ResultSet |
getTypeInfo() throws SQLException
Gets the list of data types. The result set is sorted by DATA_TYPE and
afterwards by how closely the data type maps to the corresponding JDBC
SQL type (best match first).
- 1 TYPE_NAME (String) type name
- 2 DATA_TYPE (short) SQL data type - see also java.sql.Types
- 3 PRECISION (int) maximum precision
- 4 LITERAL_PREFIX (String) prefix used to quote a literal
- 5 LITERAL_SUFFIX (String) suffix used to quote a literal
- 6 CREATE_PARAMS (String) parameters used (may be null)
- 7 NULLABLE (short) typeNoNulls (NULL not allowed) or typeNullable
- 8 CASE_SENSITIVE (boolean) case sensitive
- 9 SEARCHABLE (short) typeSearchable
- 10 UNSIGNED_ATTRIBUTE (boolean) unsigned
- 11 FIXED_PREC_SCALE (boolean) fixed precision
- 12 AUTO_INCREMENT (boolean) auto increment
- 13 LOCAL_TYPE_NAME (String) localized version of the data type
- 14 MINIMUM_SCALE (short) minimum scale
- 15 MAXIMUM_SCALE (short) maximum scale
- 16 SQL_DATA_TYPE (int) unused
- 17 SQL_DATETIME_SUB (int) unused
- 18 NUM_PREC_RADIX (int) 2 for binary, 10 for decimal
Returns:
the list of data types
Throws:
SQLException - if the connection is closed
|
ResultSet |
getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
Gets the list of user-defined data types.
|
ResultSet |
getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
Gets the list of user-defined data types.
This call returns an empty result set.
- 1 TYPE_CAT (String) catalog
- 2 TYPE_SCHEM (String) schema
- 3 TYPE_NAME (String) type name
- 4 CLASS_NAME (String) Java class
- 5 DATA_TYPE (short) SQL Type - see also java.sql.Types
- 6 REMARKS (String) description
- 7 BASE_TYPE (short) base type - see also java.sql.Types
Parameters:
catalog - ignored
schemaPattern - ignored
typeNamePattern - ignored
types - ignored
Returns:
an empty result set
Throws:
SQLException - if the connection is closed
|
String |
getURL()
Returns the database URL for this connection.
|
String |
getURL() throws SQLException
Returns the database URL for this connection.
Returns:
the url
|
String |
getUserName()
Returns the user name as passed to DriverManager.getConnection(url, user,
password).
|
String |
getUserName() throws SQLException
Returns the user name as passed to DriverManager.getConnection(url, user,
password).
Returns:
the user name
|
ResultSet |
getVersionColumns(String catalog, String schema, String tableName)
Get the list of columns that are update when any value is updated.
|
ResultSet |
getVersionColumns(String catalog, String schema, String tableName) throws SQLException
Get the list of columns that are update when any value is updated.
The result set is always empty.
- 1 SCOPE (int) not used
- 2 COLUMN_NAME (String) column name
- 3 DATA_TYPE (int) SQL data type - see also java.sql.Types
- 4 TYPE_NAME (String) data type name
- 5 COLUMN_SIZE (int) precision
(values larger than 2 GB are returned as 2 GB)
- 6 BUFFER_LENGTH (int) length (bytes)
- 7 DECIMAL_DIGITS (int) scale
- 8 PSEUDO_COLUMN (int) is this column a pseudo column
Parameters:
catalog - null (to get all objects) or the catalog name
schema - null (to get all objects) or a schema name
tableName - table name (must be specified)
Returns:
an empty result set
Throws:
SQLException - if the connection is closed
|
boolean |
insertsAreDetected(int type)
Returns whether inserts are detected.
|
boolean |
insertsAreDetected(int type)
Returns whether inserts are detected.
Parameters:
type - the result set type
Returns:
false
|
boolean |
isCatalogAtStart()
Returns whether the catalog is at the beginning.
|
boolean |
isCatalogAtStart()
Returns whether the catalog is at the beginning.
Returns:
true
|
boolean |
isReadOnly()
Returns the same as Connection.isReadOnly().
|
boolean |
isReadOnly() throws SQLException
Returns the same as Connection.isReadOnly().
Returns:
if read only optimization is switched on
|
boolean |
isWrapperFor(Class iface)
[Not supported] Checks if unwrap can return an object of this class.
|
boolean |
isWrapperFor(Class iface) throws SQLException
[Not supported] Checks if unwrap can return an object of this class.
|
boolean |
locatorsUpdateCopy()
Does the database make a copy before updating.
|
boolean |
locatorsUpdateCopy()
Does the database make a copy before updating.
Returns:
false
|
boolean |
nullPlusNonNullIsNull()
Returns whether NULL+1 is NULL or not.
|
boolean |
nullPlusNonNullIsNull()
Returns whether NULL+1 is NULL or not.
Returns:
true
|
boolean |
nullsAreSortedAtEnd()
Checks if NULL is sorted at the end (no matter if ASC or DESC is used).
|
boolean |
nullsAreSortedAtEnd()
Checks if NULL is sorted at the end (no matter if ASC or DESC is used).
Returns:
false
|
boolean |
nullsAreSortedAtStart()
Checks if NULL is sorted at the beginning (no matter if ASC or DESC is
used).
|
boolean |
nullsAreSortedAtStart()
Checks if NULL is sorted at the beginning (no matter if ASC or DESC is
used).
Returns:
false
|
boolean |
nullsAreSortedHigh()
Checks if NULL is sorted high (bigger than anything that is not null).
|
boolean |
nullsAreSortedHigh()
Checks if NULL is sorted high (bigger than anything that is not null).
Returns:
false by default; true if the system property h2.sortNullsHigh is
set to true
|
boolean |
nullsAreSortedLow()
Checks if NULL is sorted low (smaller than anything that is not null).
|
boolean |
nullsAreSortedLow()
Checks if NULL is sorted low (smaller than anything that is not null).
Returns:
true by default; false if the system property h2.sortNullsHigh is
set to true
|
boolean |
othersDeletesAreVisible(int type)
Returns whether other deletes are visible.
|
boolean |
othersDeletesAreVisible(int type)
Returns whether other deletes are visible.
Parameters:
type - the result set type
Returns:
false
|
boolean |
othersInsertsAreVisible(int type)
Returns whether other inserts are visible.
|
boolean |
othersInsertsAreVisible(int type)
Returns whether other inserts are visible.
Parameters:
type - the result set type
Returns:
false
|
boolean |
othersUpdatesAreVisible(int type)
Returns whether other updates are visible.
|
boolean |
othersUpdatesAreVisible(int type)
Returns whether other updates are visible.
Parameters:
type - the result set type
Returns:
false
|
boolean |
ownDeletesAreVisible(int type)
Returns whether own deletes are visible.
|
boolean |
ownDeletesAreVisible(int type)
Returns whether own deletes are visible.
Parameters:
type - the result set type
Returns:
false
|
boolean |
ownInsertsAreVisible(int type)
Returns whether own inserts are visible.
|
boolean |
ownInsertsAreVisible(int type)
Returns whether own inserts are visible.
Parameters:
type - the result set type
Returns:
false
|
boolean |
ownUpdatesAreVisible(int type)
Returns whether own updates are visible.
|
boolean |
ownUpdatesAreVisible(int type)
Returns whether own updates are visible.
Parameters:
type - the result set type
Returns:
true
|
boolean |
storesLowerCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns test as the
table name.
|
boolean |
storesLowerCaseIdentifiers() throws SQLException
Checks if for CREATE TABLE Test(ID INT), getTables returns test as the
table name.
Returns:
false usually, and true in MySQL mode
|
boolean |
storesLowerCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the
table name.
|
boolean |
storesLowerCaseQuotedIdentifiers() throws SQLException
Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the
table name.
Returns:
false usually, and true in MySQL mode
|
boolean |
storesMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name.
|
boolean |
storesMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name.
Returns:
false
|
boolean |
storesMixedCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the
table name.
|
boolean |
storesMixedCaseQuotedIdentifiers() throws SQLException
Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the
table name.
Returns:
true usually, and false in MySQL mode
|
boolean |
storesUpperCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the
table name.
|
boolean |
storesUpperCaseIdentifiers() throws SQLException
Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the
table name.
Returns:
true usually, and false in MySQL mode
|
boolean |
storesUpperCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the
table name.
|
boolean |
storesUpperCaseQuotedIdentifiers() throws SQLException
Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the
table name.
Returns:
false usually, and true in MySQL mode
|
boolean |
supportsANSI92EntryLevelSQL()
Returns whether SQL-92 entry level grammar is supported.
|
boolean |
supportsANSI92EntryLevelSQL()
Returns whether SQL-92 entry level grammar is supported.
Returns:
true
|
boolean |
supportsANSI92FullSQL()
Returns whether SQL-92 full level grammar is supported.
|
boolean |
supportsANSI92FullSQL()
Returns whether SQL-92 full level grammar is supported.
Returns:
false
|
boolean |
supportsANSI92IntermediateSQL()
Returns whether SQL-92 intermediate level grammar is supported.
|
boolean |
supportsANSI92IntermediateSQL()
Returns whether SQL-92 intermediate level grammar is supported.
Returns:
false
|
boolean |
supportsAlterTableWithAddColumn()
Returns whether alter table with add column is supported.
|
boolean |
supportsAlterTableWithAddColumn()
Returns whether alter table with add column is supported.
Returns:
true
|
boolean |
supportsAlterTableWithDropColumn()
Returns whether alter table with drop column is supported.
|
boolean |
supportsAlterTableWithDropColumn()
Returns whether alter table with drop column is supported.
Returns:
true
|
boolean |
supportsBatchUpdates()
Returns whether batch updates are supported.
|
boolean |
supportsBatchUpdates()
Returns whether batch updates are supported.
Returns:
true
|
boolean |
supportsCatalogsInDataManipulation()
Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.
|
boolean |
supportsCatalogsInDataManipulation()
Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.
Returns:
true
|
boolean |
supportsCatalogsInIndexDefinitions()
Returns whether the catalog name in CREATE INDEX is supported.
|
boolean |
supportsCatalogsInIndexDefinitions()
Returns whether the catalog name in CREATE INDEX is supported.
Returns:
true
|
boolean |
supportsCatalogsInPrivilegeDefinitions()
Returns whether the catalog name in GRANT is supported.
|
boolean |
supportsCatalogsInPrivilegeDefinitions()
Returns whether the catalog name in GRANT is supported.
Returns:
true
|
boolean |
supportsCatalogsInProcedureCalls()
Returns whether the catalog name in procedure calls is supported.
|
boolean |
supportsCatalogsInProcedureCalls()
Returns whether the catalog name in procedure calls is supported.
Returns:
false
|
boolean |
supportsCatalogsInTableDefinitions()
Returns whether the catalog name in CREATE TABLE is supported.
|
boolean |
supportsCatalogsInTableDefinitions()
Returns whether the catalog name in CREATE TABLE is supported.
Returns:
true
|
boolean |
supportsColumnAliasing()
Returns whether column aliasing is supported.
|
boolean |
supportsColumnAliasing()
Returns whether column aliasing is supported.
Returns:
true
|
boolean |
supportsConvert()
Returns whether CONVERT is supported.
|
boolean |
supportsConvert()
Returns whether CONVERT is supported.
Returns:
true
|
boolean |
supportsConvert(int fromType, int toType)
Returns whether CONVERT is supported for one datatype to another.
|
boolean |
supportsConvert(int fromType, int toType)
Returns whether CONVERT is supported for one datatype to another.
Parameters:
fromType - the source SQL type
toType - the target SQL type
Returns:
true
|
boolean |
supportsCoreSQLGrammar()
Returns whether ODBC Core SQL grammar is supported.
|
boolean |
supportsCoreSQLGrammar()
Returns whether ODBC Core SQL grammar is supported.
Returns:
true
|
boolean |
supportsCorrelatedSubqueries()
Returns whether correlated subqueries are supported.
|
boolean |
supportsCorrelatedSubqueries()
Returns whether correlated subqueries are supported.
Returns:
true
|
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Returns whether data manipulation and CREATE/DROP is supported in
transactions.
|
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Returns whether data manipulation and CREATE/DROP is supported in
transactions.
Returns:
false
|
boolean |
supportsDataManipulationTransactionsOnly()
Returns whether only data manipulations are supported in transactions.
|
boolean |
supportsDataManipulationTransactionsOnly()
Returns whether only data manipulations are supported in transactions.
Returns:
true
|
boolean |
supportsDifferentTableCorrelationNames()
Returns whether table correlation names (table alias) are restricted to
be different than table names.
|
boolean |
supportsDifferentTableCorrelationNames()
Returns whether table correlation names (table alias) are restricted to
be different than table names.
Returns:
false
|
boolean |
supportsExpressionsInOrderBy()
Returns whether expression in ORDER BY are supported.
|
boolean |
supportsExpressionsInOrderBy()
Returns whether expression in ORDER BY are supported.
Returns:
true
|
boolean |
supportsExtendedSQLGrammar()
Returns whether ODBC Extended SQL grammar is supported.
|
boolean |
supportsExtendedSQLGrammar()
Returns whether ODBC Extended SQL grammar is supported.
Returns:
false
|
boolean |
supportsFullOuterJoins()
Returns whether full outer joins are supported.
|
boolean |
supportsFullOuterJoins()
Returns whether full outer joins are supported.
Returns:
false
|
boolean |
supportsGetGeneratedKeys()
Does the database support getGeneratedKeys.
|
boolean |
supportsGetGeneratedKeys()
Does the database support getGeneratedKeys.
Returns:
true
|
boolean |
supportsGroupBy()
Returns whether GROUP BY is supported.
|
boolean |
supportsGroupBy()
Returns whether GROUP BY is supported.
Returns:
true
|
boolean |
supportsGroupByBeyondSelect()
Checks whether a GROUP BY clause can use columns that are not in the
SELECT clause, provided that it specifies all the columns in the SELECT
clause.
|
boolean |
supportsGroupByBeyondSelect()
Checks whether a GROUP BY clause can use columns that are not in the
SELECT clause, provided that it specifies all the columns in the SELECT
clause.
Returns:
true
|
boolean |
supportsGroupByUnrelated()
Returns whether GROUP BY is supported if the column is not in the SELECT
list.
|
boolean |
supportsGroupByUnrelated()
Returns whether GROUP BY is supported if the column is not in the SELECT
list.
Returns:
true
|
boolean |
supportsIntegrityEnhancementFacility()
Returns whether referential integrity is supported.
|
boolean |
supportsIntegrityEnhancementFacility()
Returns whether referential integrity is supported.
Returns:
true
|
boolean |
supportsLikeEscapeClause()
Returns whether LIKE...
|
boolean |
supportsLikeEscapeClause()
Returns whether LIKE... ESCAPE is supported.
Returns:
true
|
boolean |
supportsLimitedOuterJoins()
Returns whether limited outer joins are supported.
|
boolean |
supportsLimitedOuterJoins()
Returns whether limited outer joins are supported.
Returns:
true
|
boolean |
supportsMinimumSQLGrammar()
Returns whether ODBC Minimum SQL grammar is supported.
|
boolean |
supportsMinimumSQLGrammar()
Returns whether ODBC Minimum SQL grammar is supported.
Returns:
true
|
boolean |
supportsMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name.
|
boolean |
supportsMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the
table name.
Returns:
false
|
boolean |
supportsMixedCaseQuotedIdentifiers()
Checks if a table created with CREATE TABLE "Test"(ID INT) is a different
table than a table created with CREATE TABLE TEST(ID INT).
|
boolean |
supportsMixedCaseQuotedIdentifiers() throws SQLException
Checks if a table created with CREATE TABLE "Test"(ID INT) is a different
table than a table created with CREATE TABLE TEST(ID INT).
Returns:
true usually, and false in MySQL mode
|
boolean |
supportsMultipleOpenResults()
Does the database support multiple open result sets.
|
boolean |
supportsMultipleOpenResults()
Does the database support multiple open result sets.
Returns:
true
|
boolean |
supportsMultipleResultSets()
Returns whether multiple result sets are supported.
|
boolean |
supportsMultipleResultSets()
Returns whether multiple result sets are supported.
Returns:
false
|
boolean |
supportsMultipleTransactions()
Returns whether multiple transactions (on different connections) are
supported.
|
boolean |
supportsMultipleTransactions()
Returns whether multiple transactions (on different connections) are
supported.
Returns:
true
|
boolean |
supportsNamedParameters()
Does the database support named parameters.
|
boolean |
supportsNamedParameters()
Does the database support named parameters.
Returns:
false
|
boolean |
supportsNonNullableColumns()
Returns whether columns with NOT NULL are supported.
|
boolean |
supportsNonNullableColumns()
Returns whether columns with NOT NULL are supported.
Returns:
true
|
boolean |
supportsOpenCursorsAcrossCommit()
Returns whether open result sets across commits are supported.
|
boolean |
supportsOpenCursorsAcrossCommit()
Returns whether open result sets across commits are supported.
Returns:
false
|
boolean |
supportsOpenCursorsAcrossRollback()
Returns whether open result sets across rollback are supported.
|
boolean |
supportsOpenCursorsAcrossRollback()
Returns whether open result sets across rollback are supported.
Returns:
false
|
boolean |
supportsOpenStatementsAcrossCommit()
Returns whether open statements across commit are supported.
|
boolean |
supportsOpenStatementsAcrossCommit()
Returns whether open statements across commit are supported.
Returns:
true
|
boolean |
supportsOpenStatementsAcrossRollback()
Returns whether open statements across rollback are supported.
|
boolean |
supportsOpenStatementsAcrossRollback()
Returns whether open statements across rollback are supported.
Returns:
true
|
boolean |
supportsOrderByUnrelated()
Returns whether ORDER BY is supported if the column is not in the SELECT
list.
|
boolean |
supportsOrderByUnrelated()
Returns whether ORDER BY is supported if the column is not in the SELECT
list.
Returns:
true
|
boolean |
supportsOuterJoins()
Returns whether outer joins are supported.
|
boolean |
supportsOuterJoins()
Returns whether outer joins are supported.
Returns:
true
|
boolean |
supportsPositionedDelete()
Returns whether positioned deletes are supported.
|
boolean |
supportsPositionedDelete()
Returns whether positioned deletes are supported.
Returns:
true
|
boolean |
supportsPositionedUpdate()
Returns whether positioned updates are supported.
|
boolean |
supportsPositionedUpdate()
Returns whether positioned updates are supported.
Returns:
true
|
boolean |
supportsResultSetConcurrency(int type, int concurrency)
Returns whether a specific result set concurrency is supported.
|
boolean |
supportsResultSetConcurrency(int type, int concurrency)
Returns whether a specific result set concurrency is supported.
ResultSet.TYPE_SCROLL_SENSITIVE is not supported.
Parameters:
type - the result set type
concurrency - the result set concurrency
Returns:
true if the type is not ResultSet.TYPE_SCROLL_SENSITIVE
|
boolean |
supportsResultSetHoldability(int holdability)
Does this database supports a result set holdability.
|
boolean |
supportsResultSetHoldability(int holdability)
Does this database supports a result set holdability.
Parameters:
holdability - ResultSet.HOLD_CURSORS_OVER_COMMIT or
CLOSE_CURSORS_AT_COMMIT
Returns:
true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMIT
|
boolean |
supportsResultSetType(int type)
Returns whether a specific result set type is supported.
|
boolean |
supportsResultSetType(int type)
Returns whether a specific result set type is supported.
ResultSet.TYPE_SCROLL_SENSITIVE is not supported.
Parameters:
type - the result set type
Returns:
true for all types except ResultSet.TYPE_FORWARD_ONLY
|
boolean |
supportsSavepoints()
Does the database support savepoints.
|
boolean |
supportsSavepoints()
Does the database support savepoints.
Returns:
true
|
boolean |
supportsSchemasInDataManipulation()
Returns whether the schema name in INSERT, UPDATE, DELETE is supported.
|
boolean |
supportsSchemasInDataManipulation()
Returns whether the schema name in INSERT, UPDATE, DELETE is supported.
Returns:
true
|
boolean |
supportsSchemasInIndexDefinitions()
Returns whether the schema name in CREATE INDEX is supported.
|
boolean |
supportsSchemasInIndexDefinitions()
Returns whether the schema name in CREATE INDEX is supported.
Returns:
true
|
boolean |
supportsSchemasInPrivilegeDefinitions()
Returns whether the schema name in GRANT is supported.
|
boolean |
supportsSchemasInPrivilegeDefinitions()
Returns whether the schema name in GRANT is supported.
Returns:
true
|
boolean |
supportsSchemasInProcedureCalls()
Returns whether the schema name in procedure calls is supported.
|
boolean |
supportsSchemasInProcedureCalls()
Returns whether the schema name in procedure calls is supported.
Returns:
true
|
boolean |
supportsSchemasInTableDefinitions()
Returns whether the schema name in CREATE TABLE is supported.
|
boolean |
supportsSchemasInTableDefinitions()
Returns whether the schema name in CREATE TABLE is supported.
Returns:
true
|
boolean |
supportsSelectForUpdate()
Returns whether SELECT ...
|
boolean |
supportsSelectForUpdate()
Returns whether SELECT ... FOR UPDATE is supported.
Returns:
true
|
boolean |
supportsStatementPooling()
Does the database support statement pooling.
|
boolean |
supportsStatementPooling()
Does the database support statement pooling.
Returns:
false
|
boolean |
supportsStoredFunctionsUsingCallSyntax()
Returns whether the database supports calling functions using the call
syntax.
|
boolean |
supportsStoredFunctionsUsingCallSyntax()
Returns whether the database supports calling functions using the call
syntax.
Returns:
true
|
boolean |
supportsStoredProcedures()
Returns whether stored procedures are supported.
|
boolean |
supportsStoredProcedures()
Returns whether stored procedures are supported.
Returns:
false
|
boolean |
supportsSubqueriesInComparisons()
Returns whether subqueries (SELECT) in comparisons are supported.
|
boolean |
supportsSubqueriesInComparisons()
Returns whether subqueries (SELECT) in comparisons are supported.
Returns:
true
|
boolean |
supportsSubqueriesInExists()
Returns whether SELECT in EXISTS is supported.
|
boolean |
supportsSubqueriesInExists()
Returns whether SELECT in EXISTS is supported.
Returns:
true
|
boolean |
supportsSubqueriesInIns()
Returns whether IN(SELECT...) is supported.
|
boolean |
supportsSubqueriesInIns()
Returns whether IN(SELECT...) is supported.
Returns:
true
|
boolean |
supportsSubqueriesInQuantifieds()
Returns whether subqueries in quantified expression are supported.
|
boolean |
supportsSubqueriesInQuantifieds()
Returns whether subqueries in quantified expression are supported.
Returns:
true
|
boolean |
supportsTableCorrelationNames()
Returns whether table correlation names (table alias) are supported.
|
boolean |
supportsTableCorrelationNames()
Returns whether table correlation names (table alias) are supported.
Returns:
true
|
boolean |
supportsTransactionIsolationLevel(int level)
Returns whether a specific transaction isolation level is supported.
|
boolean |
supportsTransactionIsolationLevel(int level)
Returns whether a specific transaction isolation level is supported.
Parameters:
level - the transaction isolation level (Connection.TRANSACTION_*)
Returns:
true
|
boolean |
supportsTransactions()
Returns whether transactions are supported.
|
boolean |
supportsTransactions()
Returns whether transactions are supported.
Returns:
true
|
boolean |
supportsUnion()
Returns whether UNION SELECT is supported.
|
boolean |
supportsUnion()
Returns whether UNION SELECT is supported.
Returns:
true
|
boolean |
supportsUnionAll()
Returns whether UNION ALL SELECT is supported.
|
boolean |
supportsUnionAll()
Returns whether UNION ALL SELECT is supported.
Returns:
true
|
T |
unwrap(Class iface)
[Not supported] Return an object of this class if possible.
|
T |
unwrap(Class iface) throws SQLException
[Not supported] Return an object of this class if possible.
|
boolean |
updatesAreDetected(int type)
Returns whether updates are detected.
|
boolean |
updatesAreDetected(int type)
Returns whether updates are detected.
Parameters:
type - the result set type
Returns:
false
|
boolean |
usesLocalFilePerTable()
Checks if this database use one file per table.
|
boolean |
usesLocalFilePerTable()
Checks if this database use one file per table.
Returns:
false
|
boolean |
usesLocalFiles()
Checks if this database store data in local files.
|
boolean |
usesLocalFiles()
Checks if this database store data in local files.
Returns:
true
|