| Modifier and Type | Field and Description |
|---|---|
| private final JdbcConnection | |
| private final DatabaseMeta |
| Access | Constructor and Description |
|---|---|
| pack-priv |
| Modifier and Type | Method and Description |
|---|---|
| public boolean | Returns: trueImplements java. Checks if all procedures callable. |
| public boolean | Returns: trueImplements java. Checks if it possible to query all tables returned by getTables. |
| public boolean | Returns: falseImplements java. Returns whether an exception while auto commit is on closes all result sets. |
| private void | |
| public boolean | Returns: trueImplements java. Returns whether CREATE/DROP commit an open transaction. |
| public boolean | Returns: falseImplements java. Returns whether CREATE/DROP do not affect transactions. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether deletes are detected. |
| public boolean | Returns: falseImplements java. Returns whether the maximum row size includes blobs. |
| public boolean | Returns: trueImplements java. Returns whether database always returns generated keys if valid names or indexes of columns were specified and command was completed successfully. |
| public ResultSet | getAttributes(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha type name pattern; must match the
type name as it is stored in the database typeNamePattern, String an attribute name pattern; must match the attribute
name as it is declared in the database attributeNamePattern)Implements java. [Not supported] |
| public ResultSet | Returns: the primary key indexnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schema, String table name (must be specified) table, int ignored scope, boolean ignored nullable)Implements java. Gets the list of columns that best identifier a row in a table. |
| public ResultSet | Returns: the catalog listImplements java. Gets the list of catalogs. |
| public String | Returns: "."Implements java. Returns the catalog separator. |
| public String | Returns: "catalog"Implements java. Returns the term for "catalog". |
| public ResultSet | getClientInfoProperties()
Implements java. Retrieves a list of the client info properties that the driver supports. |
| public ResultSet | Returns: the list of privilegesnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schema, String a table name (uppercase for unquoted names) table, String null (to get all objects) or a column name
(uppercase for unquoted names) columnNamePattern)Implements java. Gets the list of column privileges. |
| public ResultSet | Returns: the list of columnsnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String null (to get all objects) or a table name
(uppercase for unquoted names) tableNamePattern, String null (to get all objects) or a column name
(uppercase for unquoted names) columnNamePattern)Implements java. Gets the list of columns. |
| public Connection | Returns: the connectionImplements java. Returns the connection that created this object. |
| public ResultSet | Returns: the result setnull or the catalog name primaryCatalog, String the schema name of the primary table
(optional) primarySchema, String the name of the primary table (must be specified) primaryTable, String null or the catalog name foreignCatalog, String the schema name of the foreign table
(optional) foreignSchema, String the name of the foreign table (must be specified) foreignTable)Implements java. 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. |
| public int | Returns: the major versionImplements java. Gets the major version of the database. |
| public int | Returns: the minor versionImplements java. Gets the minor version of the database. |
| public String | Returns: the product name ("H2")Implements java. Gets the database product name. |
| public String | Returns: the product versionImplements java. Gets the product version of the database. |
| public int | Returns: Connection.TRANSACTION_READ_COMMITTEDImplements java. Returns the default transaction isolation level. |
| public int | Returns: the major version numberImplements java. Returns the major version of this driver. |
| public int | Returns: the minor version numberImplements java. Returns the minor version of this driver. |
| public String | Returns: the driver name ("H2 JDBC Driver")Implements java. Gets the name of the JDBC driver. |
| public String | Returns: the version numberImplements java. Gets the version number of the driver. |
| public ResultSet | Returns: the result setnull or the catalog name catalog, String the schema name of the primary table schema, String the name of the primary table table)Implements java. Gets the list of foreign key columns that reference a table. |
| public String | Returns: an empty String ("")Implements java. Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'. |
| public ResultSet | getFunctionColumns(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha procedure name pattern; must match the
function name as it is stored in the database functionNamePattern, String a parameter name pattern; must match the
parameter or column name as it is stored in the database columnNamePattern)Implements java. [Not supported] Gets the list of function columns. |
| public ResultSet | getFunctions(String
a catalog name; must match the catalog name as it
is stored in the database; "" retrieves those without a catalog;
catalog, String null means that the catalog name should not be used to narrow
the searcha schema name pattern; must match the schema name
as it is stored in the database; "" retrieves those without a schema;
schemaPattern, String null means that the schema name should not be used to narrow
the searcha function name pattern; must match the
function name as it is stored in the database functionNamePattern)Implements java. [Not supported] Gets the list of functions. |
| public String | Returns: a double quoteImplements java. Returns the string used to quote identifiers. |
| public ResultSet | Returns: the result setnull (to get all objects) or the catalog name catalog, String the schema name of the foreign table schema, String the name of the foreign table table)Implements java. Gets the list of primary key columns that are referenced by a table. |
| public ResultSet | Returns: the list of indexes and columnsnull or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schema, String table name (must be specified) table, boolean only unique indexes unique, boolean if true, return fast, but approximate CARDINALITY and PAGES approximate)Implements java. Gets the list of indexes for this database. |
| public int | Returns: the major version (4)Implements java. Gets the major version of the supported JDBC API. |
| public int | Returns: the minor version (2)Implements java. Gets the minor version of the supported JDBC API. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for hex values (characters). |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a catalog name. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for literals. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for column names. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of columns in GROUP BY. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of columns in CREATE INDEX. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of columns in ORDER BY. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of columns in SELECT. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of columns in CREATE TABLE. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of open connection. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a cursor name. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for an index (in bytes). |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a procedure name. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum size of a row (in bytes). |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a schema name. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length of a statement. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of open statements. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a table name. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum number of tables in a SELECT. |
| public int | Returns: 0 for limit is unknownImplements java. Returns the maximum length for a user name. |
| public String | Returns: the listImplements java. Returns the list of numeric functions supported by this database. |
| public ResultSet | Returns: the list of primary key columnsnull or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schema, String table name (must be specified) table)Implements java. Gets the primary key columns for a table. |
| public ResultSet | Returns: the procedure columnsnull or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String the procedure name pattern procedureNamePattern, String the procedure name pattern columnNamePattern)Implements java. Gets the list of procedure columns. |
| public ResultSet | Returns: the proceduresnull or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String the procedure name pattern procedureNamePattern)Implements java. Gets the list of procedures. |
| public String | Returns: "procedure"Implements java. Returns the term for "procedure". |
| public ResultSet | Returns: the list of pseudo and invisible columnsnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String null (to get all objects) or a table name
(uppercase for unquoted names) tableNamePattern, String null (to get all objects) or a column name
(uppercase for unquoted names) columnNamePattern)Implements java. Gets the list of pseudo and invisible columns. |
| private JdbcResultSet | |
| public int | Returns: ResultSet.CLOSE_CURSORS_AT_COMMITImplements java. Gets the result set holdability. |
| public RowIdLifetime | Returns: ROWID_UNSUPPORTEDImplements java. Get the lifetime of a rowid. |
| public ResultSet | Returns: the schema listImplements java. Gets the list of schemas. |
| public ResultSet | Returns: the schema listnull (to get all objects) or the catalog name catalogPattern, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern)Implements java. Gets the list of schemas in the database. |
| public String | Returns: "schema"Implements java. Returns the term for "schema". |
| public String | Returns: the default escape character (always '\', independent on the mode)Implements java. Returns the default escape character for DatabaseMetaData search patterns. |
| public String | Returns: a list of additional keywordsImplements java. Gets the comma-separated list of all SQL keywords that are not supported as unquoted identifiers, in addition to the SQL:2003 reserved words. |
| public int | Returns: DatabaseMetaData#sqlStateSQLImplements java. Gets the SQL State type. |
| public String | Returns: the listImplements java. Returns the list of string functions supported by this database. |
| public ResultSet | Returns: an empty result setnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String null (to get all objects) or a table name pattern
(uppercase for unquoted names) tableNamePattern)Implements java. Get the list of super tables of a table. |
| public ResultSet | getSuperTypes(String
a catalog name; "" retrieves those without a catalog;
catalog, String null means drop catalog name from the selection criteriaa schema name pattern; "" retrieves those
without a schema schemaPattern, String a UDT name pattern; may be a fully-qualified
name typeNamePattern)Implements java. [Not supported] |
| public String | Returns: the listImplements java. Returns the list of system functions supported by this database. |
| public ResultSet | Returns: the list of privilegesnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String null (to get all objects) or a table name
(uppercase for unquoted names) tableNamePattern)Implements java. Gets the list of table privileges. |
| public ResultSet | Returns: the list of columnsnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name
(uppercase for unquoted names) schemaPattern, String null (to get all objects) or a table name
(uppercase for unquoted names) tableNamePattern, String[] null or a list of table types types)Implements java. Gets the list of tables in the database. |
| public ResultSet | Returns: the table typesImplements java. Gets the list of table types. |
| public String | Returns: the listImplements java. Returns the list of date and time functions supported by this database. |
| public ResultSet | Returns: the list of data typesImplements java. Gets the list of data types. |
| public ResultSet | Returns: an empty result setignored catalog, String ignored schemaPattern, String ignored typeNamePattern, int[] ignored types)Implements java. Gets the list of user-defined data types. |
| public String | Returns: the urlImplements java. Returns the database URL for this connection. |
| public String | Returns: the user nameImplements java. Returns the user name as passed to DriverManager.getConnection(url, user, password). |
| public ResultSet | Returns: an empty result setnull (to get all objects) or the catalog name catalog, String null (to get all objects) or a schema name schema, String table name (must be specified) table)Implements java. Get the list of columns that are update when any value is updated. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether inserts are detected. |
| public boolean | Returns: trueImplements java. Returns whether the catalog is at the beginning. |
| public boolean | Returns: if read only optimization is switched onImplements java. Returns the same as Connection.isReadOnly(). |
| public boolean | Returns: whether or not the interface is assignable from this classthe class iface)Implements java. Checks if unwrap can return an object of this class. |
| public boolean | Returns: falseImplements java. Does the database make a copy before updating. |
| public boolean | Returns: trueImplements java. Returns whether NULL+1 is NULL or not. |
| public boolean | Returns: if NULL values are sorted at the endImplements java. Checks if NULL values are sorted at the end (no matter if ASC or DESC is used). |
| public boolean | Returns: if NULL values are sorted at the beginningImplements java. Checks if NULL values are sorted at the beginning (no matter if ASC or DESC is used). |
| public boolean | Returns: if NULL values are sorted highImplements java. Checks if NULL values are sorted high (bigger than anything that is not null). |
| public boolean | Returns: if NULL values are sorted lowImplements java. Checks if NULL values are sorted low (smaller than anything that is not null). |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether other deletes are visible. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether other inserts are visible. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether other updates are visible. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether own deletes are visible. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether own inserts are visible. |
| public boolean | Returns: truethe result set type type)Implements java. Returns whether own updates are visible. |
| public boolean | Returns: true is so, false otherwiseImplements java. Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name. |
| public boolean | Returns: falseImplements java. Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name. |
| public boolean | Returns: true is so, false otherwiseImplements java. Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are not case sensitive. |
| public boolean | Returns: true is so, false otherwiseImplements java. Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name and identifiers are case insensitive. |
| public boolean | Returns: true is so, false otherwiseImplements java. Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name. |
| public boolean | Returns: falseImplements java. Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name. |
| public boolean | Returns: trueImplements java. Returns whether alter table with add column is supported. |
| public boolean | Returns: trueImplements java. Returns whether alter table with drop column is supported. |
| public boolean | Returns: trueImplements java. Returns whether SQL-92 entry level grammar is supported. |
| public boolean | Returns: falseImplements java. Returns whether SQL-92 full level grammar is supported. |
| public boolean | Returns: falseImplements java. Returns whether SQL-92 intermediate level grammar is supported. |
| public boolean | Returns: trueImplements java. Returns whether batch updates are supported. |
| public boolean | Returns: trueImplements java. Returns whether the catalog name in INSERT, UPDATE, DELETE is supported. |
| public boolean | Returns: trueImplements java. Returns whether the catalog name in CREATE INDEX is supported. |
| public boolean | Returns: trueImplements java. Returns whether the catalog name in GRANT is supported. |
| public boolean | Returns: falseImplements java. Returns whether the catalog name in procedure calls is supported. |
| public boolean | Returns: trueImplements java. Returns whether the catalog name in CREATE TABLE is supported. |
| public boolean | Returns: trueImplements java. Returns whether column aliasing is supported. |
| public boolean | Returns: trueImplements java. Returns whether CONVERT is supported. |
| public boolean | Returns: truethe source SQL type fromType, int the target SQL type toType)Implements java. Returns whether CONVERT is supported for one datatype to another. |
| public boolean | Returns: trueImplements java. Returns whether ODBC Core SQL grammar is supported. |
| public boolean | Returns: trueImplements java. Returns whether correlated subqueries are supported. |
| public boolean | Returns: falseImplements java. Returns whether data manipulation and CREATE/DROP is supported in transactions. |
| public boolean | Returns: trueImplements java. Returns whether only data manipulations are supported in transactions. |
| public boolean | Returns: falseImplements java. Returns whether table correlation names (table alias) are restricted to be different than table names. |
| public boolean | Returns: trueImplements java. Returns whether expression in ORDER BY are supported. |
| public boolean | Returns: falseImplements java. Returns whether ODBC Extended SQL grammar is supported. |
| public boolean | Returns: falseImplements java. Returns whether full outer joins are supported. |
| public boolean | Returns: trueImplements java. Does the database support getGeneratedKeys. |
| public boolean | Returns: trueImplements java. Returns whether GROUP BY is supported. |
| public boolean | Returns: trueImplements java. 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. |
| public boolean | Returns: trueImplements java. Returns whether GROUP BY is supported if the column is not in the SELECT list. |
| public boolean | Returns: trueImplements java. Returns whether referential integrity is supported. |
| public boolean | Returns: trueImplements java. Returns whether LIKE... |
| public boolean | Returns: trueImplements java. Returns whether limited outer joins are supported. |
| public boolean | Returns: trueImplements java. Returns whether ODBC Minimum SQL grammar is supported. |
| public boolean | Returns: true is so, false otherwiseImplements java. Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are case sensitive. |
| public boolean | Returns: true is so, false otherwiseImplements java. 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). |
| public boolean | Returns: falseImplements java. Does the database support multiple open result sets returned from a
|
| public boolean | Returns: falseImplements java. Returns whether multiple result sets are supported. |
| public boolean | Returns: trueImplements java. Returns whether multiple transactions (on different connections) are supported. |
| public boolean | Returns: falseImplements java. Does the database support named parameters. |
| public boolean | Returns: trueImplements java. Returns whether columns with NOT NULL are supported. |
| public boolean | Returns: falseImplements java. Returns whether open result sets across commits are supported. |
| public boolean | Returns: falseImplements java. Returns whether open result sets across rollback are supported. |
| public boolean | Returns: trueImplements java. Returns whether open statements across commit are supported. |
| public boolean | Returns: trueImplements java. Returns whether open statements across rollback are supported. |
| public boolean | Returns: trueImplements java. Returns whether ORDER BY is supported if the column is not in the SELECT list. |
| public boolean | Returns: trueImplements java. Returns whether outer joins are supported. |
| public boolean | Returns: falseImplements java. Returns whether positioned deletes are supported. |
| public boolean | Returns: falseImplements java. Returns whether positioned updates are supported. |
| public boolean | Returns: true if the type is not ResultSet.TYPE_SCROLL_SENSITIVEthe result set type type, int the result set concurrency concurrency)Implements java. Returns whether a specific result set concurrency is supported. |
| public boolean | Returns: true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMITResultSet.HOLD_CURSORS_OVER_COMMIT or
CLOSE_CURSORS_AT_COMMIT holdability)Implements java. Does this database supports a result set holdability. |
| public boolean | Returns: true for all types except ResultSet.TYPE_SCROLL_SENSITIVEthe result set type type)Implements java. Returns whether a specific result set type is supported. |
| public boolean | Returns: trueImplements java. Does the database support savepoints. |
| public boolean | Returns: trueImplements java. Returns whether the schema name in INSERT, UPDATE, DELETE is supported. |
| public boolean | Returns: trueImplements java. Returns whether the schema name in CREATE INDEX is supported. |
| public boolean | Returns: trueImplements java. Returns whether the schema name in GRANT is supported. |
| public boolean | Returns: trueImplements java. Returns whether the schema name in procedure calls is supported. |
| public boolean | Returns: trueImplements java. Returns whether the schema name in CREATE TABLE is supported. |
| public boolean | Returns: trueImplements java. Returns whether SELECT ... |
| public boolean | Returns: falseImplements java. Does the database support statement pooling. |
| public boolean | Returns: trueImplements java. Returns whether the database supports calling functions using the call syntax. |
| public boolean | Returns: falseImplements java. Returns whether stored procedures are supported. |
| public boolean | Returns: trueImplements java. Returns whether subqueries (SELECT) in comparisons are supported. |
| public boolean | Returns: trueImplements java. Returns whether SELECT in EXISTS is supported. |
| public boolean | Returns: trueImplements java. Returns whether IN(SELECT...) is supported. |
| public boolean | Returns: trueImplements java. Returns whether subqueries in quantified expression are supported. |
| public boolean | Returns: trueImplements java. Returns whether table correlation names (table alias) are supported. |
| public boolean | Returns: truethe transaction isolation level (Connection.TRANSACTION_*) level)Implements java. Returns whether a specific transaction isolation level is supported. |
| public boolean | Returns: trueImplements java. Returns whether transactions are supported. |
| public boolean | Returns: trueImplements java. Returns whether UNION SELECT is supported. |
| public boolean | Returns: trueImplements java. Returns whether UNION ALL SELECT is supported. |
| public String | |
| public <T> T | Returns: thisthe class iface)Implements java. Return an object of this class if possible. |
| public boolean | Returns: falsethe result set type type)Implements java. Returns whether updates are detected. |
| public boolean | Returns: falseImplements java. Checks if this database use one file per table. |
| public boolean | Returns: trueImplements java. Checks if this database store data in local files. |