Nonstop Database, HiRDB Version 9 UAP Development Guide
The DatabaseMetaData interface provides the following principal functions:
Some methods of the DatabaseMetaData class use a String pattern character string as an argument. The following table shows the special characters that can be specified in such a pattern character string.
Special character | Description |
---|---|
_ (underscore) | Any single character |
% | A character string of any length, including no characters (as well as any number of characters) |
\ | Escape character (enables a special character immediately following this escape character in a pattern character string to be treated as a regular character) |
The table below lists the methods of the DatabaseMetaData interface. The interface does not support methods that are not listed in the table. If an unsupported method is specified, the interface throws an SQLException.
Table 18-37 DatabaseMetaData interface methods
Subsection | Method | Function |
---|---|---|
(a) | allProceduresAreCallable() | Returns a value indicating whether all the procedures returned by the getProcedures() method can be called by the current user. |
(b) | allTablesAreSelectable() | Returns a value indicating whether all the tables returned by the getTables() method can be used by the current user. |
(c) | dataDefinitionCausesTransactionCommit() | Returns a value indicating whether a data definition statement in a transaction is to forcibly commit the transaction. |
(d) | dataDefinitionIgnoredInTransactions() | Returns a value indicating whether data definition statements are ignored in transactions. |
(e) | deletesAreDetected(int type) | Returns a value indicating whether deletions of visible rows can be detected by calling the ResultSet.rowDeleted() method. |
(f) | doesMaxRowSizeIncludeBlobs() | Returns a value indicating whether the getMaxRowSize() method contains the LONGVARCHAR and LONGVARBINARY SQL data types. |
(g) | getAttributes(String catalog,String schemaPattern,String typeNamePattern,String attributeNamePattern) | Returns attribute-related information for user-defined types that can be used in catalogs and specified schemas. |
(h) | getBestRowIdentifier(String catalog,String schema,String table,int scope,boolean nullable) | Returns information about the optimum column set for a table in which rows are identified uniquely. |
(i) | getCatalogs() | Returns the available catalog names. |
(j) | getCatalogSeparator() | Returns the separator between the catalog name and the table name. |
(k) | getCatalogTerm() | Returns a word recommended for catalog. |
(l) | getColumnPrivileges (String catalog,String schema,String table,String columnNamePattern) | Returns information about table column access permissions. |
(m) | getColumns(String catalog,String schemaPattern,String tableNamePattern,String columnNamePattern) | Returns information about specified table columns. |
(n) | getConnection() | Returns the Connection instance that created this DatabaseMetaData instance. |
(o) | getCrossReference (String primaryCatalog,String primarySchema,String primaryTable,String foreignCatalog,1String foreignSchema) | Returns cross-reference information between a specified referencing table and referenced table. |
(p) | getDatabaseMajorVersion() | Returns the database's major version information. |
(q) | getDatabaseMinorVersion() | Returns the database's minor version information. |
(r) | getDatabaseProductName() | Returns the connected database's product name. |
(s) | getDatabaseProductVersion() | Returns the connected database's version. |
(t) | getDefaultTransactionIsolation() | Returns the default transaction cut-off level. |
(u) | getDriverMajorVersion() | Returns this JDBC driver's major version as int type. |
(v) | getDriverMinorVersion() | Returns this JDBC driver's minor version as int type. |
(w) | getDriverName() | Returns the JDBC driver name HiRDB_Type4_JDBC_Driver. |
(x) | getDriverVersion() | Returns the version of this JDBC driver as String. |
(y) | getExportedKeys (String catalog,String schema,String table) | Returns information about a specified table's foreign keys. |
(z) | getExtraNameCharacters() | Returns the special characters (characters other than a to z, A to Z, 0 to 9, and the underscore (_)) that can be used in an SQL ID name that is not enclosed in double quotation marks. |
(aa) | getIdentifierQuoteString() | Returns the character string used to enclose SQL identifiers. |
(ab) | getImportedKeys (String catalog,String schema,String table) | Returns information about a specified table's primary key. |
(ac) | getIndexInfo(String catalog,String schema,String table,boolean unique,boolean approximate) | Returns information about the indexes of a specified table. |
(ad) | getJDBCMajorVersion() | Returns the driver's JDBC major version. |
(ae) | getJDBCMinorVersion() | Returns the driver's JDBC minor version. |
(af) | getMaxBinaryLiteralLength() | Returns the maximum number of hexadecimal characters that can be used in a binary literal. |
(ag) | getMaxCatalogNameLength() | Returns the maximum length of a catalog name (number of characters). |
(ah) | getMaxCharLiteralLength() | Returns the maximum length of a character literal (number of characters). |
(ai) | getMaxColumnNameLength() | Returns the maximum length of a column name (number of characters). |
(aj) | getMaxColumnsInGroupBy() | Returns the maximum number of columns in a GROUP BY clause. |
(ak) | getMaxColumnsInIndex() | Returns the maximum number of columns permitted for an index. |
(al) | getMaxColumnsInOrderBy() | Returns the maximum number of columns in an ORDER BY clause. |
(am) | getMaxColumnsInSelect() | Returns the maximum number of columns in a SELECT list. |
(an) | getMaxColumnsInTable() | Returns the maximum number of columns in a table. |
(ao) | getMaxConnections() | Returns the maximum number of concurrent connections. |
(ap) | getMaxCursorNameLength() | Returns the maximum length of a cursor name (number of characters). |
(aq) | getMaxIndexLength() | Returns the maximum length of an index, including all parts of the index. |
(ar) | getMaxProcedureNameLength() | Returns the maximum length of a procedure name (number of characters). |
(as) | getMaxRowSize() | Returns the maximum length of a row (in bytes). |
(at) | getMaxSchemaNameLength() | Returns the maximum length of a schema name (number of characters). |
(au) | getMaxStatementLength() | Returns the maximum length of an SQL statement. |
(av) | getMaxStatements() | Returns the maximum number of SQL statements that can be active. |
(aw) | getMaxTableNameLength() | Returns the maximum length of a table name (number of characters). |
(ax) | getMaxTablesInSelect() | Returns the maximum number of tables in a SELECT statement. |
(ay) | getMaxUserNameLength() | Returns the maximum length of a user name (number of characters). |
(az) | getNumericFunctions() | Returns a list of the available mathematical functions (delimited by a comma). |
(ba) | getPrimaryKeys(String catalog, String schema, String table) | Returns information about a specified table's primary key columns. |
(bb) | getProcedureColumns(String catalog,String schemaPattern,String procedureNamePattern, String columnNamePattern) | Returns information about stored procedure parameters. |
(bc) | getProcedures(String catalog,String schemaPattern,String procedureNamePattern) | Returns information about stored procedures. |
(bd) | getProcedureTerm() | Returns a word recommended for procedure. |
(be) | getResultSetHoldability() | Returns the holding facility for ResultSet objects. |
(bf) | getSchemas() | Returns the available schema names. |
(bg) | getSchemaTerm() | Returns a word recommended for schema. |
(bh) | getSearchStringEscape() | Returns the character string used as the escape sequence for wildcard characters. |
(bi) | getSQLKeywords() | Returns a list (delimited by a comma) of all database-specific SQL keywords that are not SQL92 keywords. |
(bj) | getSQLStateType() | Returns a value indicating whether SQLSTATE returned by SQLException.getSQLState is an X/Open SQL CLI or SQL99. |
(bk) | getStringFunctions() | Returns a list of string functions (delimited by a comma). |
(bl) | getSuperTables(String catalog,String schemaPattern,String tableNamePattern) | Returns a description of table hierarchies defined in a specified schema. |
(bm) | getSuperTypes(String catalog,String schemaPattern,String typeNamePattern) | Returns a description of user-defined-type hierarchies that are defined in a specified schema. |
(bn) | getSystemFunctions() | Returns the available system functions. |
(bo) | getTablePrivileges(String catalog,String schemaPattern,String tableNamePattern) | Returns information about table access privileges. |
(bp) | getTables(String catalog,String schemaPattern,String tableNamePattern,String[] types) | Returns information about tables. |
(bq) | getTableTypes() | Returns the available table types. |
(br) | getTimeDateFunctions() | Returns a list of the available time and date functions (delimited by a comma). |
(bs) | getTypeInfo() | Returns information about the default SQL types. |
(bt) | getUDTs(String catalog,String schemaPattern,String typeNamePattern,int[] types) | Returns information about the user-defined types. |
(bu) | getURL() | Returns the URL used for the connection to HiRDB or XDM/RD E2. |
(bv) | getUserName() | Returns the user name used to connect to HiRDB or XDM/RD E2. |
(bw) | getVersionColumns(String catalog,String schema,String table) | Returns information about the table columns that are updated automatically when rows in the table are updated. |
(bx) | insertsAreDetected(int type) | Returns a value indicating whether insertion of a visible row can be detected by calling the ResultSet.rowInserted() method. |
(by) | isCatalogAtStart() | Returns a value indicating whether a catalog appears at the leading (or trailing) end of a fully qualified table name. |
(bz) | isReadOnly() | Returns a value indicating whether the database is in read-only mode. |
(ca) | locatorsUpdateCopy() | Indicates whether a change was made to a LOB copy or directly to the LOB. |
(cb) | nullPlusNonNullIsNull() | Returns a value indicating whether a join of a NULL value and a non-NULL value is treated as being NULL. |
(cc) | nullsAreSortedAtEnd() | Returns a value indicating whether the NULL value is sorted during termination processing (regardless of the sort order). |
(cd) | nullsAreSortedAtStart() | Returns a value indicating whether the NULL value is sorted during startup processing (regardless of the sort order). |
(ce) | nullsAreSortedHigh() | Returns a value indicating whether the NULL value is sorted in ascending order. |
(cf) | nullsAreSortedLow() | Returns a value indicating whether the NULL value is sorted in descending order. |
(cg) | othersDeletesAreVisible(int type) | Returns a value indicating whether a deletion performed externally is visible. |
(ch) | othersInsertsAreVisible(int type) | Returns a value indicating whether an insertion performed externally is visible. |
(ci) | othersUpdatesAreVisible(int type) | Returns a value indicating whether a deletion performed externally is visible. |
(cj) | ownDeletesAreVisible(int type) | Returns a value indicating whether a deletion of a result set itself is visible. |
(ck) | ownInsertsAreVisible(int type) | Returns a value indicating whether an insertion of a result set itself is visible. |
(cl) | ownUpdatesAreVisible(int type) | Returns a value indicating whether an updating of a result set itself is visible. |
(cm) | storesLowerCaseIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is not enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in all lower-case letters. |
(cn) | storesLowerCaseQuotedIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in all lower-case letters. |
(co) | storesMixedCaseIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is not enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in upper-case and lower-case letters. |
(cp) | storesMixedCaseQuotedIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in upper-case and lower-case letters. |
(cq) | storesUpperCaseIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is not enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in all upper-case letters. |
(cr) | storesUpperCaseQuotedIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is enclosed in quotation marks is processed as being not case sensitive, and then the results are stored in all upper-case letters. |
(cs) | supportsAlterTableWithAddColumn() | Returns a value indicating whether ALTER TABLE with added columns is supported. |
(ct) | supportsAlterTableWithDropColumn() | Returns a value indicating whether ALTER TABLE with dropped columns is supported. |
(cu) | supportsANSI92EntryLevelSQL() | Returns a value indicating whether the ANSI92 entry-level SQL grammar is supported. |
(cv) | supportsANSI92FullSQL() | Returns a value indicating whether the ANSI92 full-level SQL grammar is supported. |
(cw) | supportsANSI92IntermediateSQL() | Returns a value indicating whether the ANSI92 intermediate-level SQL grammar is supported. |
(cx) | supportsBatchUpdates() | Returns a value indicating whether batch updating is supported. |
(cy) | supportsCatalogsInDataManipulation() | Returns a value indicating whether catalog names can be used in data manipulation statements. |
(cz) | supportsCatalogsInIndexDefinitions() | Returns a value indicating whether catalog names can be used in index definition statements. |
(da) | supportsCatalogsInPrivilegeDefinitions() | Returns a value indicating whether catalog names can be used in privilege definition statements. |
(db) | supportsCatalogsInProcedureCalls() | Returns a value indicating whether catalog names can be used in procedure call statements. |
(dc) | supportsCatalogsInTableDefinitions() | Returns a value indicating whether catalog names can be used in table definition statements. |
(dd) | supportsColumnAliasing() | Returns a value indicating whether aliases are supported for columns. |
(de) | supportsConvert() | Returns a value indicating whether the CONVERT function is supported for SQL types. |
(df) | supportsConvert(int fromType,int toType) | Returns a value indicating whether the CONVERT function is supported for given SQL types. |
(dg) | supportsCoreSQLGrammar() | Returns a value indicating whether the ODBC Core SQL grammar is supported. |
(dh) | supportsCorrelatedSubqueries() | Returns a value indicating whether correlated subqueries are supported. |
(di) | supportsDataDefinitionAndDataManipulationTransactions() | Returns a value indicating whether data definition statements and data manipulation statements are both supported in transactions. |
(dj) | supportsDataManipulationTransactionsOnly() | Returns a value indicating whether only data manipulation statements are supported in transactions. |
(dk) | supportsDifferentTableCorrelationNames() | Returns a value indicating whether the table names must be different from the correlation names when table correlation names are supported. |
(dl) | supportsExpressionsInOrderBy() | Returns a value indicating whether expressions are supported in an ORDER BY list. |
(dm) | supportsExtendedSQLGrammar() | Returns a value indicating whether the ODBC Extended SQL grammar is supported. |
(dn) | supportsFullOuterJoins() | Returns a value indicating whether full outer joins are supported. |
(do) | supportsGetGeneratedKeys() | Returns a value indicating whether automatic generation keys can be acquired after statements have executed. |
(dp) | supportsGroupBy() | Returns a value indicating whether the GROUP BY clause form is supported. |
(dq) | supportsGroupByBeyondSelect() | Returns a value indicating whether a column for which the GROUP BY clause is not specified in SELECT can be used when all columns in SELECT must be specified. |
(dr) | supportsGroupByUnrelated() | Returns a value indicating whether a column for which the GROUP BY clause is not specified in SELECT can be used. |
(ds) | supportsIntegrityEnhancementFacility() | Returns a value indicating whether the SQL Integrity Enhancement Facility is supported. |
(dt) | supportsLikeEscapeClause() | Returns a value indicating whether escape characters are supported in the LIKE clause. |
(du) | supportsLimitedOuterJoins() | Returns a value indicating whether limited support is provided for outer joins. |
(dv) | supportsMinimumSQLGrammar() | Returns a value indicating whether the ODBC Minimum SQL grammar is supported. |
(dw) | supportsMixedCaseIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is not enclosed in quotation marks is processed as being case sensitive, and then the results are stored in upper-case and lower-case letters. |
(dx) | supportsMixedCaseQuotedIdentifiers() | Returns a value indicating whether an SQL identifier containing upper-case and lower-case letters that is enclosed in quotation marks is processed as being case sensitive, and then the results are stored in upper-case and lower-case letters. |
(dy) | supportsMultipleOpenResults() | Returns a value indicating whether it is possible for multiple ResultSet objects to be returned simultaneously by a CallableStatement object. |
(dz) | supportsMultipleResultSets() | Returns a value indicating whether multiple ResultSet objects can be acquired from execution of a single execute method. |
(ea) | supportsMultipleTransactions() | Returns a value indicating whether multiple transactions can be open at the same time (for different connections). |
(eb) | supportsNamedParameters() | Returns a value indicating whether named parameters are supported for the callable statement. |
(ec) | supportsNonNullableColumns() | Returns a value indicating whether columns can be defined as non-null columns. |
(ed) | supportsOpenCursorsAcrossCommit() | Returns a value indicating whether the cursor can remain open between commit operations. |
(ee) | supportsOpenCursorsAcrossRollback() | Returns a value indicating whether the cursor can remain open between rollback operations. |
(ef) | supportsOpenStatementsAcrossCommit() | Returns a value indicating whether statements can remain open between commit operations. |
(eg) | supportsOpenStatementsAcrossRollback() | Returns a value indicating whether statements can remain open between rollback operations. |
(eh) | supportsOrderByUnrelated() | Returns a value indicating whether a column for which the ORDER BY clause is not in SELECT can be used. |
(ei) | supportsOuterJoins() | Returns a value indicating whether some form of outer join is supported. |
(ej) | supportsPositionedDelete() | Returns a value indicating whether positioned DELETE is supported. |
(ek) | supportsPositionedUpdate() | Returns a value indicating whether positioned UPDATE is supported. |
(el) | supportsResultSetConcurrency(int type, int concurrency) | Returns a value indicating whether the combination of a specified type of ResultSet and a specified parallel processing type is supported. |
(em) | supportsResultSetHoldability(int holdability) | Returns a value indicating whether the holding facility is supported for a specified ResultSet object. |
(en) | supportsResultSetType(int type) | Returns a value indicating whether a specified type of ResultSet is supported. |
(eo) | supportsSavepoints() | Returns a value indicating whether save points are supported. |
(ep) | supportsStatementPooling() | Returns a value indicating whether statement pooling is supported. |
(eq) | supportsSchemasInDataManipulation() | Returns a value indicating whether schema names can be used in data manipulation statements. |
(er) | supportsSchemasInIndexDefinitions() | Returns a value indicating whether schema names can be used in index definition statements. |
(es) | supportsSchemasInPrivilegeDefinitions() | Returns a value indicating whether schema names can be used in privilege definition statements. |
(et) | supportsSchemasInProcedureCalls() | Returns a value indicating whether schema names can be used in procedure calls. |
(eu) | supportsSchemasInTableDefinitions() | Returns a value indicating whether schema names can be used in table definition statements. |
(ev) | supportsSelectForUpdate() | Returns a value indicating whether SELECT is supported for updating. |
(ew) | supportsStoredProcedures() | Returns a value indicating whether stored procedure calls are supported. |
(ex) | supportsSubqueriesInComparisons() | Returns a value indicating whether subqueries are supported in comparison expressions. |
(ey) | supportsSubqueriesInExists() | Returns a value indicating whether subqueries are supported in exists expressions. |
(ez) | supportsSubqueriesInIns() | Returns a value indicating whether subqueries are supported in in statements. |
(fa) | supportsSubqueriesInQuantifieds() | Returns a value indicating whether subqueries are supported in quantified expressions. |
(fb) | supportsTableCorrelationNames() | Returns a value indicating whether table correlation names are supported. |
(fc) | supportsTransactionIsolationLevel(int level) | Returns a value indicating whether a specified transaction isolation level is supported. |
(fd) | supportsTransactions() | Returns a value indicating whether transactions are supported. |
(fe) | supportsUnion() | Returns a value indicating whether SQL UNION is supported. |
(ff) | supportsUnionAll() | Returns a value indicating whether SQL UNION ALL is supported. |
(fg) | updatesAreDetected(int type) | Returns a value indicating whether updating performed on a ResultSet of a specified ResultSet type can be detected by the ResultSet.rowUpdated method. |
(fh) | usesLocalFilePerTable() | Returns a value indicating whether a file is to be used for each table. |
(fi) | usesLocalFiles() | Returns a value indicating whether tables are to be stored in local files. |
public boolean allProceduresAreCallable() throws SQLException
public boolean allTablesAreSelectable() throws SQLException
public boolean dataDefinitionCausesTransactionCommit() throws SQLException
public boolean dataDefinitionIgnoredInTransactions() throws SQLException
public boolean deletesAreDetected(int type) throws SQLException
public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TYPE_CAT | Catalog name |
2 | String | VARCHAR | TYPE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TYPE_NAME | Type name |
4 | String | VARCHAR | ATTR_NAME | Attribute name |
5 | int | INTEGER | DATA_TYPE | Attribute type |
6 | String | VARCHAR | ATTR_TYPE_NAME | Type name |
7 | int | INTEGER | ATTR_SIZE | Column size |
8 | int | INTEGER | DECIMAL_DIGITS | Decimal places |
9 | int | INTEGER | NUM_PREC_RADIX | Radix |
10 | int | INTEGER | NULLABLE | Whether the NULL value is permitted |
11 | String | VARCHAR | REMARKS | Comments |
12 | String | VARCHAR | ATTR_DEF | Default value |
13 | int | INTEGER | SQL_DATA_TYPE | Not used |
14 | int | INTEGER | SQL_DATETIME_SUB | Not used |
15 | int | INTEGER | CHAR_OCTET_LENGTH | Maximum length (in bytes) of a char-type column |
16 | int | INTEGER | ORDINAL_POSITION | Column index in table |
17 | String | VARCHAR | IS_NULLABLE | Whether the NULL value is permitted |
18 | String | VARCHAR | SCOPE_CATALOG | Catalog for a table in the scope of reference attribute |
19 | String | VARCHAR | SCOPE_SCHEMA | Schema for a table in the scope of reference attribute |
20 | String | VARCHAR | SCOPE_TABLE | Table name in the scope of reference attribute |
21 | short | SMALLINT | SOURCE_DATA_TYPE | Source data type for individual types, user-defined Ref type, or java.sql.Types SQL type |
public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
public ResultSet getCatalogs() throws SQLException
public String getCatalogSeparator() throws SQLException
public String getCatalogTerm() throws SQLException
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | -- | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | TABLE_SCHEM | 1 (ascending order) | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | 2 (ascending order) | Table name |
4 | String | VARCHAR | COLUMN_NAME | 3 (ascending order) | Column name |
5 | String | VARCHAR | GRANTOR | -- | User who grants access privileges |
6 | String | VARCHAR | GRANTEE | -- | User who receives access privileges |
7 | String | VARCHAR | PRIVILEGE | 4 (ascending order) | Names of granted access privileges (multiple access privilege names are delimited by the comma): SELECT: SELECT privilege INSERT: INSERT privilege UPDATE: UPDATE privilege DELETE: DELETE privilege |
8 | String | VARCHAR | IS_GRANTABLE | -- | Whether a user who has received access privileges can grant access privileges to other users: YES: Can grant privileges to other users. NO: Cannot grant privileges to other users. null: Whether the user can grant privileges to other users is unknown. If multiple access privileges are set in PRIVILEGE and at least one of the privileges can be granted to other users, the method sets YES. null is not returned in either HiRDB or XDM/RD E2. |
public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
Table 18-38 Format of ResultSet returned by getColumns
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | NULL value is always returned |
2 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | Table name |
4 | String | VARCHAR | COLUMN_NAME | Column name |
5 | int | INTEGER | DATA_TYPE | SQL type |
6 | String | CHAR | TYPE_NAME | Type name |
7 | int | INTEGER | COLUMN_SIZE | Column size |
8 | int | INTEGER | BUFFER_LENGTH | NULL value is always returned |
9 | int | INTEGER | DECIMAL_DIGITS | Decimal places |
10 | int | INTEGER | NUM_PREC_RADIX | Radix
|
11 | int | INTEGER | NULLABLE | Whether the NULL value can be used for this type:
|
12 | String | VARCHAR | REMARKS | Comment column |
13 | String | VARCHAR | COLUMN_DEF | Default value |
14 | int | INTEGER | SQL_DATA_TYPE | NULL value is always returned |
15 | int | INTEGER | SQL_DATETIME_SUB | NULL value is always returned |
16 | int | INTEGER | CHAR_OCTET_LENGTH | Maximum length in bytes of char-type column (same as COLUMN_SIZE) |
17 | int | SMALLINT | ORDINAL_POSITION | Column number (beginning with 1) |
18 | String | CHAR | IS_NULLABLE | Whether the NULL value can be used for this type:
|
19 | String | CHAR | SCOPE_CATLOG | NULL value is always returned |
20 | String | CHAR | SCOPE_SCHEMA | NULL value is always returned |
21 | String | CHAR | SCOPE_TABLE | NULL value is always returned |
22 | short | SMALLINT | SOURCE_DATA_TYPE | NULL value is always returned |
public Connection getConnection() throws SQLException
public ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | PKTABLE_CAT | -- | Catalog name of the referenced table (NULL value is always returned) |
2 | String | VARCHAR | PKTABLE_SCHEM | -- | Authorization identifier of the referenced table |
3 | String | VARCHAR | PKTABLE_NAME | -- | Table name of the referenced table |
4 | String | VARCHAR | PKCOLUMN_NAME | -- | Column name of primary key |
5 | String | CHAR | FKTABLE_CAT | -- | Catalog name of the referencing table (NULL value is always returned) |
6 | String | VARCHAR | FKTABLE_SCHEM | 1 (ascending order) | Authorization identifier of the referencing table |
7 | String | VARCHAR | FKTABLE_NAME | 2 (ascending order) | Table name of the referencing table |
8 | String | VARCHAR | FKCOLUMN_NAME | -- | Column name of foreign key |
9 | short | SMALLINT | KEY_SEQ | 3 (ascending order) | Sequence number of foreign key |
10 | short | SMALLINT | UPDATE_RULE | -- | Updating rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is updated.
|
11 | short | SMALLINT | DELETE_RULE | -- | Deletion rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is deleted.
|
12 | String | VARCHAR | FK_NAME | -- | Constraint name of referential constraints |
13 | String | VARCHAR | PK_NAME | -- | Index name of the primary key |
14 | short | SMALLINT | DEFERRABILITY | -- | Whether evaluation of constraints on the foreign key can be postponed until the transaction is committed:
|
public int getDatabaseMajorVersion() throws SQLException
public int getDatabaseMinorVersion() throws SQLException
public String getDatabaseProductName() throws SQLException
public String getDatabaseProductVersion() throws SQLException
public int getDefaultTransactionIsolation() throws SQLException
public int getDriverMajorVersion() throws SQLException
public int getDriverMinorVersion() throws SQLException
public String getDriverName() throws SQLException
public String getDriverVersion() throws SQLException
public ResultSet getExportedKeys(String catalog,String schema,String table) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | PKTABLE_CAT | -- | Catalog name of the referenced table (NULL value is always returned) |
2 | String | VARCHAR | PKTABLE_SCHEM | -- | Authorization identifier of the referenced table |
3 | String | VARCHAR | PKTABLE_NAME | -- | Table name of the referenced table |
4 | String | VARCHAR | PKCOLUMN_NAME | -- | Column name of primary key |
5 | String | CHAR | FKTABLE_CAT | -- | Catalog name of the referencing table (NULL value is always returned) |
6 | String | VARCHAR | FKTABLE_SCHEM | 1 (ascending order) | Authorization identifier of the referencing table |
7 | String | VARCHAR | FKTABLE_NAME | 2 (ascending order) | Table name of the referencing table |
8 | String | VARCHAR | FKCOLUMN_NAME | -- | Column name of foreign key |
9 | short | SMALLINT | KEY_SEQ | 3 (ascending order) | Sequence number of foreign key |
10 | short | SMALLINT | UPDATE_RULE | -- | Updating rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is updated.
|
11 | short | SMALLINT | DELETE_RULE | -- | Deletion rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is deleted.
|
12 | String | VARCHAR | FK_NAME | -- | Constraint name of referential constraints |
13 | String | VARCHAR | PK_NAME | -- | Index name of the primary key |
14 | short | SMALLINT | DEFERRABILITY | -- | Whether evaluation of constraints on the foreign key can be postponed until the transaction is committed:
|
public String getExtraNameCharacters() throws SQLException
public String getIdentifierQuoteString() throws SQLException
public ResultSet getImportedKeys(String catalog,String schema,String table) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | PKTABLE_CAT | -- | Catalog name of the referenced table (NULL value is always returned) |
2 | String | VARCHAR | PKTABLE_SCHEM | 1 (ascending order) | Authorization identifier of the referenced table |
3 | String | VARCHAR | PKTABLE_NAME | 2 (ascending order) | Table name of the referenced table |
4 | String | VARCHAR | PKCOLUMN_NAME | -- | Column name of primary key |
5 | String | CHAR | FKTABLE_CAT | -- | Catalog name of the referencing table (NULL value is always returned) |
6 | String | VARCHAR | FKTABLE_SCHEM | -- | Authorization identifier of the referencing table |
7 | String | VARCHAR | FKTABLE_NAME | -- | Table name of the referencing table |
8 | String | VARCHAR | FKCOLUMN_NAME | -- | Column name of foreign key |
9 | short | SMALLINT | KEY_SEQ | 3 (ascending order) | Sequence number of foreign key |
10 | short | SMALLINT | UPDATE_RULE | -- | Updating rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is updated.
|
11 | short | SMALLINT | DELETE_RULE | -- | Deletion rules. This indicates how a foreign key is affected when the foreign key is referencing the primary key and the primary key is deleted.
|
12 | String | VARCHAR | FK_NAME | -- | Constraint name of referential constraints |
13 | String | VARCHAR | PK_NAME | -- | Index name of the primary key |
14 | short | SMALLINT | DEFERRABILITY | -- | Whether evaluation of constraints on the foreign key can be postponed until the transaction is committed.
|
public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
Table 18-39 Format of ResultSet returned by getIndexInf
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | Table name |
4 | boolean | BIT | NON_UNIQUE | If the key values for which the index is defined (total value of a single or multiple columns defined as index columns) are different in every row, the method returns false; otherwise, the method returns true. |
5 | String | CHAR | INDEX_QUALIFIER | Index's catalog name (NULL value is always returned) |
6 | String | VARCHAR | INDEX_NAME | Index identifier |
7 | short | SMALLINT | TYPE | Index type:
|
8 | short | SMALLINT | ORDINAL_POSITION | For a single-column index, the method returns 1. For a multicolumn index, the method returns the sequence number of a column that composes the index (integers beginning with 1 that identify in sequence the column names that constitute the index). |
9 | String | VARCHAR | COLUMN_NAME | Column name |
10 | String | VARCHAR | ASC_OR_DESC | For an index defined in ascending order, the method returns A; for an index defined in descending order, the method returns D. For a plug-in index, the method returns the NULL value. |
11 | int | INTEGER | CARDINALITY | Number of unique values in the index (NULL value is always returned) |
12 | int | INTEGER | PAGES | Number of pages used for the index (NULL value is always returned) |
13 | String | CHAR | FILTER_CONDITION | Filter condition (NULL value is always returned. |
public int getJDBCMajorVersion() throws SQLException
public int getJDBCMinorVersion () throws SQLException
public int getMaxBinaryLiteralLength() throws SQLException
public int getMaxCatalogNameLength() throws SQLException
public int getMaxCharLiteralLength() throws SQLException
public int getMaxColumnNameLength() throws SQLException
public int getMaxColumnsInGroupBy() throws SQLException
public int getMaxColumnsInIndex() throws SQLException
public int getMaxColumnsInOrderBy() throws SQLException
public int getMaxColumnsInSelect() throws SQLException
public int getMaxColumnsInTable() throws SQLException
public int getMaxConnections() throws SQLException
public int getMaxCursorNameLength() throws SQLException
public int getMaxIndexLength() throws SQLException
public int getMaxProcedureNameLength() throws SQLException
public int getMaxRowSize() throws SQLException
public int getMaxSchemaNameLength() throws SQLException
public int getMaxStatementLength() throws SQLException
public int getMaxStatements() throws SQLException
public int getMaxTableNameLength() throws SQLException
public int getMaxTablesInSelect() throws SQLException
public int getMaxUserNameLength() throws SQLException
public String getNumericFunctions() throws SQLException
public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException
Table 18-40 Format of ResultSet returned by getPrimaryKeys
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | Table name |
4 | String | VARCHAR | COLUMN_NAME | Column name |
5 | short | SMALLINT | KEY_SEQ | Sequence number of a column that composes the index (an integer beginning with 1 that identifies in sequence the column names that constitute the index) |
6 | String | VARCHAR | PK_NAME | Primary index identifier |
public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | PROCEDURE_CAT | -- | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | PROCEDURE_SCHEM | 1 (ascending order) | Authorization identifier |
3 | String | VARCHAR | PROCEDURE_NAME | 2 (ascending order) | Procedure name |
4 | String | VARCHAR | COLUMN_NAME | 3 (ascending order) | Parameter name |
5 | short | SMALLINT | COLUMN_TYPE | -- | Parameter type:
|
6 | int | INTEGER | DATA_TYPE | -- | Parameter's SQL type (value defined in java.sql.Types) |
7 | String | VARCHAR | TYPE_NAME | -- | Parameter's SQL type name (type name expressed as a character string) |
8 | int | INTEGER | PRECISION | -- | Parameter's precision If the parameter's SQL type name is not DECIMAL, the method returns 0. |
9 | int | INTEGER | LENGTH | -- | Parameter size |
10 | short | SMALLINT | SCALE | -- | Parameter scaling (number of digits in the fraction part) If the parameter's SQL type name is neither DECIMAL nor TIMESTAMP, the method returns 0. |
11 | short | SMALLINT | RADIX | -- | Radix of parameter
|
12 | short | SMALLINT | NULLABLE | -- | Whether the NULL value is permitted:
|
13 | String | VARCHAR | REMARKS | -- | Comment related to the parameter (NULL value is always returned) |
public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
This method returns information about stored procedures. The following table shows the format of the ResultSet that is returned:
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | PROCEDURE_CAT | -- | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | PROCEDURE_SCHEM | 1 (ascending order) | Authorization identifier |
3 | String | VARCHAR | PROCEDURE_NAME | 2 (ascending order) | Procedure name |
4 | String | VARCHAR | RESERVE1 | -- | Reserved |
5 | String | VARCHAR | RESERVE2 | -- | Reserved |
6 | String | VARCHAR | RESERVE3 | -- | Reserved |
7 | String | VARCHAR | REMARKS | -- | Description of procedure |
8 | short | SMALLINT | PROCEDURE_TYPE | -- | Procedure type:
|
public String getProcedureTerm() throws SQLException
public int getResultSetHoldability() throws SQLException
public ResultSet getSchemas() throws SQLException
Table 18-41 Format of ResultSet returned by getSchemas
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
2 | String | CHAR | TABLE_CATALOG | NULL value is always returned. |
public String getSchemaTerm() throws SQLException
public String getSearchStringEscape() throws SQLException
public String getSQLKeywords() throws SQLException
public int getSQLStateType() throws SQLException
public String getStringFunctions() throws SQLException
public ResultSet getSuperTables(String catalog,String schemaPattern,String tableNamePattern) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | Catalog name |
2 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | Type name |
4 | String | VARCHAR | SUPERTABLE_NAME | Super type name |
public ResultSet getSuperTypes(String catalog,String schemaPattern,String typeNamePattern) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TYPE_CAT | Catalog name of the user-defined type |
2 | String | VARCHAR | TYPE_SCHEM | Schema name of the user-defined type |
3 | String | VARCHAR | TYPE_NAME | Type name of the user-defined type |
4 | String | CHAR | SUPERTYPE_CAT | Catalog name of the direct super type |
5 | String | VARCHAR | SUPERTYPE_SCHEM | Schema name of the direct super type |
6 | String | VARCHAR | SUPERTYPE_NAME | Type name of the direct super type |
public String getSystemFunctions() throws SQLException
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)throws SQLException
Column No. | Type | SQL type (Types) | Column name | Sorting# | Description |
---|---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | -- | Catalog name (NULL value is always returned) |
2 | String | VARCHAR | TABLE_SCHEM | 1 (ascending order) | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | 2 (ascending order) | Table name |
4 | String | VARCHAR | GRANTOR | -- | User who grants access privileges |
5 | String | VARCHAR | GRANTEE | -- | User who receives access privileges |
6 | String | VARCHAR | PRIVILEGE | 3 (ascending order) | Names of granted access privileges (multiple access privilege names are separated by a comma): SELECT: SELECT privilege INSERT: INSERT privilege UPDATE: UPDATE privilege DELETE: DELETE privilege |
7 | String | VARCHAR | IS_GRANTABLE | -- | Whether a user who has received access privileges can grant access privileges to other users: YES: User can grant privileges to other users. NO: User cannot grant privileges to other users. null: Whether the user can grant privileges to other users is unknown. In both HiRDB and XDM/RD E2, null will not be returned. If multiple access privileges are set in PRIVILEGE and at least one of the privileges can be granted to other users, the method sets YES. |
public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
Table 18-42 Format of ResultSet returned by getTables
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TABLE_CAT | NULL value is always returned |
2 | String | VARCHAR | TABLE_SCHEM | Authorization identifier |
3 | String | VARCHAR | TABLE_NAME | Table name |
4 | String | VARCHAR | TABLE_TYPE | Table type:
|
5 | String | VARCHAR | REMARKS | Comment |
6 | String | CHAR | TYPE_CAT | NULL value is always returned |
7 | String | CHAR | TYPE_SCHEM | NULL value is always returned |
8 | String | CHAR | TYPE_NAME | NULL value is always returned |
9 | String | CHAR | SELF_REFERENCING_COL_NAME | NULL value is always returned |
10 | String | CHAR | REF_GENERATION | NULL value is always returned |
public ResultSet getTableTypes()throws SQLException
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | VARCHAR | TABLE_TYPE | Table type:
|
public String getTimeDateFunctions() throws SQLException
public ResultSet getTypeInfo() throws SQLException
Table 18-43 Format of ResultSet returned by getTypeInfo
Column No. | Type | SQL type | Column name | Description |
---|---|---|---|---|
1 | String | VARCHAR | TYPE_NAME | Type name |
2 | short | SMALLINT | DATA_TYPE | SQL data type of java.sql.Types |
3 | int | INTEGER | PRECISION | Maximum precision |
4 | String | VARCHAR | LITERAL_PREFIX | Prefix used to quote literals |
5 | String | VARCHAR | LITERAL_SUFFIX | Suffix used to quote literals |
6 | String | VARCHAR | CREATE_PARAMS | Parameter used to create types |
7 | short | SMALLINT | NULLABLE | Whether the NULL value can be used for this type:
|
8 | boolean | BIT | CASE_SENSITIVE | Whether the value is case sensitive:
|
9 | short | SMALLINT | SEARCHABLE | Whether WHERE can be used for this type:
|
10 | boolean | BIT | UNSIGNED_ATTRIBUTE | Whether the attribute is unsigned. The method returns false for numeric data (because it is signed) and true for other data types (because they are unsigned). |
11 | boolean | BIT | FIXED_PREC_SCALE | Whether this can be a currency value. The method always returns false. |
12 | boolean | BIT | AUTO_INCREMENT | Whether this can be used as an automatic increment value. The method always returns false. |
13 | String | VARCHAR | LOCAL_TYPE_NAME | The type name's localized version The method returns the same value as the type name. |
14 | short | SMALLINT | MINIMUM_SCALE | Supported minimum scale |
15 | short | SMALLINT | MAXIMUM_SCALE | Supported maximum scale |
16 | int | INTEGER | SQL_DATA_TYPE | NULL value is always returned |
17 | int | INTEGER | SQL_DATETIME_SUB | NULL value is always returned |
18 | int | INTEGER | NUM_PREC_RADIX | 2 or 10 for numeric data, 0 for all other data. |
public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | String | CHAR | TYPE_CAT | Catalog name of the user-defined type |
2 | String | VARCHAR | TYPE_SCHEM | Schema name of the user-defined type |
3 | String | VARCHAR | TYPE_NAME | Type name of the user-defined type |
4 | String | VARCHAR | CLASS_NAME | Java class name |
5 | int | INTEGER | DATA_TYPE | Type value defined by java.sql.Types |
6 | String | VARCHAR | REMARKS | Description of the type |
7 | short | SMALLINT | BASE_TYPE | Type code of DISTINCT-type source or type code of an implementation of SELF_REFERENCING_COLUMN user-defined reference type |
public String getURL() throws SQLException
public String getUserName() throws SQLException
public ResultSet getVersionColumns(String catalog,String schema,String table) throws SQLException
Column No. | Type | SQL type (Types) | Column name | Description |
---|---|---|---|---|
1 | short | SMALLINT | SCOPE | Not used |
2 | String | VARCHAR | COLUMN_NAME | Column name |
3 | int | INTEGER | DATA_TYPE | SQL type |
4 | String | VARCHAR | TYPE_NAME | Data source-dependent type name |
5 | int | INTEGER | COLUMN_SIZE | Data precision |
6 | int | INTEGER | BUFFER_LENGTH | Data length in bytes |
7 | short | SMALLINT | DECIMAL_DIGITS | Scale |
8 | short | SMALLINT | PSEUDO_COLUMN | Whether this is a pseudo column |
public boolean insertsAreDetected(int type) throws SQLException
public boolean isCatalogAtStart() throws SQLException
public boolean isReadOnly() throws SQLException
public boolean locatorsUpdateCopy() throws SQLException
public boolean nullPlusNonNullIsNull() throws SQLException
public boolean nullsAreSortedAtEnd() throws SQLException
public boolean nullsAreSortedAtStart() throws SQLException
public boolean nullsAreSortedHigh() throws SQLException
public boolean nullsAreSortedLow() throws SQLException
public boolean othersDeletesAreVisible(int type) throws SQLException
public boolean othersInsertsAreVisible(int type) throws SQLException
public boolean othersUpdatesAreVisible(int type) throws SQLException
public boolean ownDeletesAreVisible(int type) throws SQLException
public boolean ownInsertsAreVisible(int type) throws SQLException
public boolean ownUpdatesAreVisible(int type) throws SQLException
public boolean storesLowerCaseIdentifiers() throws SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
public boolean storesMixedCaseIdentifiers() throws SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
public boolean storesUpperCaseIdentifiers() throws SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
public boolean supportsAlterTableWithAddColumn() throws SQLException
public boolean supportsAlterTableWithDropColumn() throws SQLException
public boolean supportsANSI92EntryLevelSQL() throws SQLException
public boolean supportsANSI92FullSQL() throws SQLException
public boolean supportsANSI92IntermediateSQL() throws SQLException
public boolean supportsBatchUpdates() throws SQLException
public boolean supportsCatalogsInDataManipulation() throws SQLException
public boolean supportsCatalogsInIndexDefinitions() throws SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
public boolean supportsCatalogsInProcedureCalls() throws SQLException
public boolean supportsCatalogsInTableDefinitions() throws SQLException
public boolean supportsColumnAliasing() throws SQLException
public boolean supportsConvert() throws SQLException
public boolean supportsConvert(int fromType, int toType) throws SQLException
Table 18-44 Return value depending on the combination of the conversion source and target types (part 1)
Conversion source Type of java.sql.Types |
Conversion target Type of java.sql.Types |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BIT | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT | REAL | DOUBLE | NUMERIC | DECIMAL | CHAR | VARCHAR | LONGVARCHAR | |
BIT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
TINYINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
SMALLINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
INTEGER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
BIGINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
FLOAT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
REAL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
DOUBLE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
NUMERIC | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
DECIMAL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
CHAR | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
VARCHAR | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
LONGVARCHAR | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
DATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
TIME | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
TIMESTAMP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
BINARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
VARBINARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
LONGVARBINARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
JAVA_OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
STRUCT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
ARRAY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
BLOB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
CLOB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
REF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Table 18-45 Return value depending on the combination of the conversion source and target types (part 2)
Conversion source Type of java.sql.Types |
Conversion target Type of java.sql.Types |
|||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
DATE | TIME | TIMESTAMP | BINARY | VARBINARY | LONGVARBINARY | JAVA_OBJECT | STRUCT | ARRAY | BLOB | CLOB | REF | |
BIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
TINYINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
SMALLINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
INTEGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
BIGINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
FLOAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
REAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
DOUBLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
NUMERIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
DECIMAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
CHAR | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
VARCHAR | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
LONGVARCHAR | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
DATE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
TIME | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
TIMESTAMP | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
BINARY | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
VARBINARY | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
LONGVARBINARY | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
JAVA_OBJECT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
STRUCT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
ARRAY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
BLOB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
CLOB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
REF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
public boolean supportsCoreSQLGrammar() throws SQLException
public boolean supportsCorrelatedSubqueries() throws SQLException
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
public boolean supportsDataManipulationTransactionsOnly() throws SQLException
public boolean supportsDifferentTableCorrelationNames() throws SQLException
public boolean supportsExpressionsInOrderBy() throws SQLException
public boolean supportsExtendedSQLGrammar() throws SQLException
public boolean supportsFullOuterJoins() throws SQLException
public boolean supportsGetGeneratedKeys() throws SQLException
public boolean supportsGroupBy() throws SQLException
public boolean supportsGroupByBeyondSelect() throws SQLException
public boolean supportsGroupByUnrelated() throws SQLException
public boolean supportsIntegrityEnhancementFacility() throws SQLException
public boolean supportsLikeEscapeClause() throws SQLException
public boolean supportsLimitedOuterJoins() throws SQLException
public boolean supportsMinimumSQLGrammar() throws SQLException
public boolean supportsMixedCaseIdentifiers() throws SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
public boolean supportsMultipleOpenResults() throws SQLException
public boolean supportsMultipleResultSets() throws SQLException
public boolean supportsMultipleTransactions() throws SQLException
public boolean supportsNamedParameters() throws SQLException
public boolean supportsNonNullableColumns() throws SQLException
public boolean supportsOpenCursorsAcrossCommit() throws SQLException
public boolean supportsOpenCursorsAcrossRollback() throws SQLException
public boolean supportsOpenStatementsAcrossCommit() throws SQLException
public boolean supportsOpenStatementsAcrossRollback() throws SQLException
public boolean supportsOrderByUnrelated() throws SQLException
public boolean supportsOuterJoins() throws SQLException
public boolean supportsPositionedDelete() throws SQLException
public boolean supportsPositionedUpdate() throws SQLException
public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException
public boolean supportsResultSetHoldability(int holdability) throws SQLException
holdability argument | HIRDB_CURSOR# | |
---|---|---|
Enabled | Disabled | |
HOLD_CURSORS_OVER_COMMIT | Returns true | Returns false |
CLOSE_CURSORS_AT_COMMIT | Returns false | Returns true |
public boolean supportsResultSetType(int type) throws SQLException
public boolean supportsSavepoints() throws SQLException
public boolean supportsStatementPooling() throws SQLException
public boolean supportsSchemasInDataManipulation() throws SQLException
public boolean supportsSchemasInIndexDefinitions() throws SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
public boolean supportsSchemasInProcedureCalls() throws SQLException
public boolean supportsSchemasInTableDefinitions() throws SQLException
public boolean supportsSelectForUpdate() throws SQLException
public boolean supportsStoredProcedures() throws SQLException
public boolean supportsSubqueriesInComparisons() throws SQLException
public boolean supportsSubqueriesInExists() throws SQLException
public boolean supportsSubqueriesInIns() throws SQLException
public boolean supportsSubqueriesInQuantifieds() throws SQLException
public boolean supportsTableCorrelationNames() throws SQLException
public boolean supportsTransactionIsolationLevel(int level) throws SQLException
public boolean supportsTransactions() throws SQLException
public boolean supportsUnion() throws SQLException
public boolean supportsUnionAll() throws SQLException
public boolean updatesAreDetected(int type) throws SQLException
public boolean usesLocalFilePerTable() throws SQLException
public boolean usesLocalFiles() throws SQLException
The names of the package and class for installing this interface are as follows:
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.