| java.lang.Object com.mysql.jdbc.DatabaseMetaData com.mysql.jdbc.DatabaseMetaDataUsingInfoSchema
All known Subclasses: com.mysql.jdbc.JDBC4DatabaseMetaDataUsingInfoSchema,
DatabaseMetaDataUsingInfoSchema | public class DatabaseMetaDataUsingInfoSchema extends DatabaseMetaData (Code) | | DatabaseMetaData implementation that uses INFORMATION_SCHEMA available in
MySQL-5.0 and newer.
The majority of the queries in this code were built for Connector/OO.org by
Georg Richter (georg_at_mysql.com).
|
Method Summary | |
public java.sql.ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) Get a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. | public ResultSet | getColumns(String catalog, String schemaPattern, String tableName, String columnNamePattern) Get a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column
name criteria are returned. | public java.sql.ResultSet | getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) Get a description of the foreign key columns in the foreign key table
that reference the primary key columns of the primary key table (describe
how one table imports another's key.) This should normally return a
single foreign key/primary key pair (most tables only import a foreign
key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM,
FKTABLE_NAME, and KEY_SEQ. | public java.sql.ResultSet | getExportedKeys(String catalog, String schema, String table) Get a description of a foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table). | public java.sql.ResultSet | getImportedKeys(String catalog, String schema, String table) Get a description of the primary key columns that are referenced by a
table's foreign key columns (the primary keys imported by a table). | public ResultSet | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) Get a description of a table's indices and statistics. | public java.sql.ResultSet | getPrimaryKeys(String catalog, String schema, String table) Get a description of a table's primary key columns. | public ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) Get a description of stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name
criteria are returned. | public ResultSet | getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) Get a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type
criteria are returned. |
getColumnPrivileges | public java.sql.ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException(Code) | | Get a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are
ordered by COLUMN_NAME and PRIVILEGE.
Each privilige description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- GRANTOR => grantor of access (may be null)
- GRANTEE String => grantee of access
- PRIVILEGE String => name of access (SELECT, INSERT, UPDATE,
REFRENCES, ...)
- IS_GRANTABLE String => "YES" if grantee is permitted to
grant to others; "NO" if not; null if unknown
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schema - a schema name; "" retrieves those without a schema Parameters: table - a table name Parameters: columnNamePattern - a column name pattern ResultSet each row is a column privilege description throws: SQLException - if a database access error occurs See Also: DatabaseMetaDataUsingInfoSchema.getSearchStringEscape |
getColumns | public ResultSet getColumns(String catalog, String schemaPattern, String tableName, String columnNamePattern) throws SQLException(Code) | | Get a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column
name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME
and ORDINAL_POSITION.
Each column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- DATA_TYPE short => SQL type from java.sql.Types
- TYPE_NAME String => Data source dependent type name
- COLUMN_SIZE int => column size. For char or date types this
is the maximum number of characters, for numeric or decimal types this is
precision.
- BUFFER_LENGTH is not used.
- DECIMAL_DIGITS int => the number of fractional digits
- NUM_PREC_RADIX int => Radix (typically either 10 or 2)
- NULLABLE int => is NULL allowed?
- columnNoNulls - might not allow NULL values
- columnNullable - definitely allows NULL values
- columnNullableUnknown - nullability unknown
- REMARKS String => comment describing column (may be null)
- COLUMN_DEF String => default value (may be null)
- SQL_DATA_TYPE int => unused
- SQL_DATETIME_SUB int => unused
- CHAR_OCTET_LENGTH int => for char types the maximum number
of bytes in the column
- ORDINAL_POSITION int => index of column in table (starting
at 1)
- IS_NULLABLE String => "NO" means column definitely does not
allow NULL values; "YES" means the column might allow NULL values. An
empty string means nobody knows.
|
getCrossReference | public java.sql.ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException(Code) | | Get a description of the foreign key columns in the foreign key table
that reference the primary key columns of the primary key table (describe
how one table imports another's key.) This should normally return a
single foreign key/primary key pair (most tables only import a foreign
key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM,
FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog (may be
null)
- PKTABLE_SCHEM String => primary key table schema (may be
null)
- PKTABLE_NAME String => primary key table name
- PKCOLUMN_NAME String => primary key column name
- FKTABLE_CAT String => foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String => foreign key table name being exported
- FKCOLUMN_NAME String => foreign key column name being
exported
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key identifier (may be null)
- PK_NAME String => primary key identifier (may be null)
Parameters: primaryCatalog - a catalog name; "" retrieves those without a catalog Parameters: primarySchema - a schema name pattern; "" retrieves those without a schema Parameters: primaryTable - a table name Parameters: foreignCatalog - a catalog name; "" retrieves those without a catalog Parameters: foreignSchema - a schema name pattern; "" retrieves those without a schema Parameters: foreignTable - a table name ResultSet each row is a foreign key column description throws: SQLException - if a database access error occurs |
getExportedKeys | public java.sql.ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException(Code) | | Get a description of a foreign key columns that reference a table's
primary key columns (the foreign keys exported by a table). They are
ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog (may be
null)
- PKTABLE_SCHEM String => primary key table schema (may be
null)
- PKTABLE_NAME String => primary key table name
- PKCOLUMN_NAME String => primary key column name
- FKTABLE_CAT String => foreign key table catalog (may be
null) being exported (may be null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null) being exported (may be null)
- FKTABLE_NAME String => foreign key table name being exported
- FKCOLUMN_NAME String => foreign key column name being
exported
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key identifier (may be null)
- PK_NAME String => primary key identifier (may be null)
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schema - a schema name pattern; "" retrieves those without a schema Parameters: table - a table name ResultSet each row is a foreign key column description throws: SQLException - if a database access error occurs See Also: DatabaseMetaDataUsingInfoSchema.getImportedKeys |
getImportedKeys | public java.sql.ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException(Code) | | Get a description of the primary key columns that are referenced by a
table's foreign key columns (the primary keys imported by a table). They
are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
- PKTABLE_CAT String => primary key table catalog being
imported (may be null)
- PKTABLE_SCHEM String => primary key table schema being
imported (may be null)
- PKTABLE_NAME String => primary key table name being imported
- PKCOLUMN_NAME String => primary key column name being
imported
- FKTABLE_CAT String => foreign key table catalog (may be
null)
- FKTABLE_SCHEM String => foreign key table schema (may be
null)
- FKTABLE_NAME String => foreign key table name
- FKCOLUMN_NAME String => foreign key column name
- KEY_SEQ short => sequence number within foreign key
- UPDATE_RULE short => What happens to foreign key when
primary is updated:
- importedKeyCascade - change imported key to agree with primary key
update
- importedKeyRestrict - do not allow update of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been updated
- DELETE_RULE short => What happens to the foreign key when
primary is deleted.
- importedKeyCascade - delete rows that import a deleted key
- importedKeyRestrict - do not allow delete of primary key if it has
been imported
- importedKeySetNull - change imported key to NULL if its primary key
has been deleted
- FK_NAME String => foreign key name (may be null)
- PK_NAME String => primary key name (may be null)
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schema - a schema name pattern; "" retrieves those without a schema Parameters: table - a table name ResultSet each row is a primary key column description throws: SQLException - if a database access error occurs See Also: DatabaseMetaDataUsingInfoSchema.getExportedKeys |
getIndexInfo | public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException(Code) | | Get a description of a table's indices and statistics. They are ordered
by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- NON_UNIQUE boolean => Can index values be non-unique? false
when TYPE is tableIndexStatistic
- INDEX_QUALIFIER String => index catalog (may be null); null
when TYPE is tableIndexStatistic
- INDEX_NAME String => index name; null when TYPE is
tableIndexStatistic
- TYPE short => index type:
- tableIndexStatistic - this identifies table statistics that are
returned in conjuction with a table's index descriptions
- tableIndexClustered - this is a clustered index
- tableIndexHashed - this is a hashed index
- tableIndexOther - this is some other style of index
- ORDINAL_POSITION short => column sequence number within
index; zero when TYPE is tableIndexStatistic
- COLUMN_NAME String => column name; null when TYPE is
tableIndexStatistic
- ASC_OR_DESC String => column sort sequence, "A" =>
ascending, "D" => descending, may be null if sort sequence is not
supported; null when TYPE is tableIndexStatistic
- CARDINALITY int => When TYPE is tableIndexStatisic then this
is the number of rows in the table; otherwise it is the number of unique
values in the index.
- PAGES int => When TYPE is tableIndexStatisic then this is
the number of pages used for the table, otherwise it is the number of
pages used for the current index.
- FILTER_CONDITION String => Filter condition, if any. (may be
null)
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schema - a schema name pattern; "" retrieves those without a schema Parameters: table - a table name Parameters: unique - when true, return only indices for unique values; when false,return indices regardless of whether unique or not Parameters: approximate - when true, result is allowed to reflect approximate or out ofdata values; when false, results are requested to be accurate ResultSet each row is an index column description throws: SQLException - DOCUMENT ME! |
getPrimaryKeys | public java.sql.ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException(Code) | | Get a description of a table's primary key columns. They are ordered by
COLUMN_NAME.
Each column description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- COLUMN_NAME String => column name
- KEY_SEQ short => sequence number within primary key
- PK_NAME String => primary key name (may be null)
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schema - a schema name pattern; "" retrieves those without a schema Parameters: table - a table name ResultSet each row is a primary key column description throws: SQLException - DOCUMENT ME! |
getProcedures | public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException(Code) | | Get a description of stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name
criteria are returned. They are ordered by PROCEDURE_SCHEM, and
PROCEDURE_NAME.
Each procedure description has the the following columns:
- PROCEDURE_CAT String => procedure catalog (may be null)
- PROCEDURE_SCHEM String => procedure schema (may be null)
- PROCEDURE_NAME String => procedure name
- reserved for future use
- reserved for future use
- reserved for future use
- REMARKS String => explanatory comment on the procedure
- PROCEDURE_TYPE short => kind of procedure:
- procedureResultUnknown - May return a result
- procedureNoResult - Does not return a result
- procedureReturnsResult - Returns a result
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schemaPattern - a schema name pattern; "" retrieves those without a schema Parameters: procedureNamePattern - a procedure name pattern ResultSet each row is a procedure description throws: SQLException - if a database access error occurs See Also: DatabaseMetaDataUsingInfoSchema.getSearchStringEscape |
getTables | public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException(Code) | | Get a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type
criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and
TABLE_NAME.
Each table description has the following columns:
- TABLE_CAT String => table catalog (may be null)
- TABLE_SCHEM String => table schema (may be null)
- TABLE_NAME String => table name
- TABLE_TYPE String => table type. Typical types are "TABLE",
"VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS",
"SYNONYM".
- REMARKS String => explanatory comment on the table
Note: Some databases may not return information for all tables.
Parameters: catalog - a catalog name; "" retrieves those without a catalog Parameters: schemaPattern - a schema name pattern; "" retrieves those without a schema Parameters: tableNamePattern - a table name pattern Parameters: types - a list of table types to include; null returns all types ResultSet each row is a table description throws: SQLException - DOCUMENT ME! See Also: DatabaseMetaDataUsingInfoSchema.getSearchStringEscape |
Methods inherited from com.mysql.jdbc.DatabaseMetaData | public boolean allProceduresAreCallable() throws SQLException(Code)(Java Doc) public boolean allTablesAreSelectable() throws SQLException(Code)(Java Doc) static java.sql.ResultSet buildResultSet(com.mysql.jdbc.Field[] fields, java.util.ArrayList rows, ConnectionImpl c) throws SQLException(Code)(Java Doc) public boolean dataDefinitionCausesTransactionCommit() throws SQLException(Code)(Java Doc) public boolean dataDefinitionIgnoredInTransactions() throws SQLException(Code)(Java Doc) public boolean deletesAreDetected(int type) throws SQLException(Code)(Java Doc) public boolean doesMaxRowSizeIncludeBlobs() throws SQLException(Code)(Java Doc) public List extractForeignKeyForTable(ArrayList rows, java.sql.ResultSet rs, String catalog) throws SQLException(Code)(Java Doc) public ResultSet extractForeignKeyFromCreateTable(String catalog, String tableName) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getAttributes(String arg0, String arg1, String arg2, String arg3) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException(Code)(Java Doc) protected IteratorWithCleanup getCatalogIterator(String catalogSpec) throws SQLException(Code)(Java Doc) public String getCatalogSeparator() throws SQLException(Code)(Java Doc) public String getCatalogTerm() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getCatalogs() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException(Code)(Java Doc) public java.sql.Connection getConnection() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException(Code)(Java Doc) public int getDatabaseMajorVersion() throws SQLException(Code)(Java Doc) public int getDatabaseMinorVersion() throws SQLException(Code)(Java Doc) public String getDatabaseProductName() throws SQLException(Code)(Java Doc) public String getDatabaseProductVersion() throws SQLException(Code)(Java Doc) public int getDefaultTransactionIsolation() throws SQLException(Code)(Java Doc) public int getDriverMajorVersion()(Code)(Java Doc) public int getDriverMinorVersion()(Code)(Java Doc) public String getDriverName() throws SQLException(Code)(Java Doc) public String getDriverVersion() throws java.sql.SQLException(Code)(Java Doc) public java.sql.ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc) public String getExtraNameCharacters() throws SQLException(Code)(Java Doc) public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException(Code)(Java Doc) public String getIdentifierQuoteString() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException(Code)(Java Doc) protected static DatabaseMetaData getInstance(ConnectionImpl connToSet, String databaseToSet) throws SQLException(Code)(Java Doc) protected int getJDBC4FunctionNoTableConstant()(Code)(Java Doc) public int getJDBCMajorVersion() throws SQLException(Code)(Java Doc) public int getJDBCMinorVersion() throws SQLException(Code)(Java Doc) public int getMaxBinaryLiteralLength() throws SQLException(Code)(Java Doc) public int getMaxCatalogNameLength() throws SQLException(Code)(Java Doc) public int getMaxCharLiteralLength() throws SQLException(Code)(Java Doc) public int getMaxColumnNameLength() throws SQLException(Code)(Java Doc) public int getMaxColumnsInGroupBy() throws SQLException(Code)(Java Doc) public int getMaxColumnsInIndex() throws SQLException(Code)(Java Doc) public int getMaxColumnsInOrderBy() throws SQLException(Code)(Java Doc) public int getMaxColumnsInSelect() throws SQLException(Code)(Java Doc) public int getMaxColumnsInTable() throws SQLException(Code)(Java Doc) public int getMaxConnections() throws SQLException(Code)(Java Doc) public int getMaxCursorNameLength() throws SQLException(Code)(Java Doc) public int getMaxIndexLength() throws SQLException(Code)(Java Doc) public int getMaxProcedureNameLength() throws SQLException(Code)(Java Doc) public int getMaxRowSize() throws SQLException(Code)(Java Doc) public int getMaxSchemaNameLength() throws SQLException(Code)(Java Doc) public int getMaxStatementLength() throws SQLException(Code)(Java Doc) public int getMaxStatements() throws SQLException(Code)(Java Doc) public int getMaxTableNameLength() throws SQLException(Code)(Java Doc) public int getMaxTablesInSelect() throws SQLException(Code)(Java Doc) public int getMaxUserNameLength() throws SQLException(Code)(Java Doc) public String getNumericFunctions() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException(Code)(Java Doc) protected java.sql.ResultSet getProcedureOrFunctionColumns(Field[] fields, String catalog, String schemaPattern, String procedureOrFunctionNamePattern, String columnNamePattern, boolean returnProcedures, boolean returnFunctions) throws SQLException(Code)(Java Doc) public String getProcedureTerm() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException(Code)(Java Doc) protected java.sql.ResultSet getProceduresAndOrFunctions(Field[] fields, String catalog, String schemaPattern, String procedureNamePattern, boolean returnProcedures, boolean returnFunctions) throws SQLException(Code)(Java Doc) public int getResultSetHoldability() throws SQLException(Code)(Java Doc) public String getSQLKeywords() throws SQLException(Code)(Java Doc) public int getSQLStateType() throws SQLException(Code)(Java Doc) public String getSchemaTerm() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getSchemas() throws SQLException(Code)(Java Doc) public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException(Code)(Java Doc) public String getSearchStringEscape() throws SQLException(Code)(Java Doc) public String getStringFunctions() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getSuperTables(String arg0, String arg1, String arg2) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getSuperTypes(String arg0, String arg1, String arg2) throws SQLException(Code)(Java Doc) public String getSystemFunctions() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException(Code)(Java Doc) public java.sql.ResultSet getTableTypes() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException(Code)(Java Doc) public String getTimeDateFunctions() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getTypeInfo() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException(Code)(Java Doc) public String getURL() throws SQLException(Code)(Java Doc) public String getUserName() throws SQLException(Code)(Java Doc) public java.sql.ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException(Code)(Java Doc) public boolean insertsAreDetected(int type) throws SQLException(Code)(Java Doc) public boolean isCatalogAtStart() throws SQLException(Code)(Java Doc) public boolean isReadOnly() throws SQLException(Code)(Java Doc) public boolean locatorsUpdateCopy() throws SQLException(Code)(Java Doc) public boolean nullPlusNonNullIsNull() throws SQLException(Code)(Java Doc) public boolean nullsAreSortedAtEnd() throws SQLException(Code)(Java Doc) public boolean nullsAreSortedAtStart() throws SQLException(Code)(Java Doc) public boolean nullsAreSortedHigh() throws SQLException(Code)(Java Doc) public boolean nullsAreSortedLow() throws SQLException(Code)(Java Doc) public boolean othersDeletesAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean othersInsertsAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean othersUpdatesAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean ownDeletesAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean ownInsertsAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean ownUpdatesAreVisible(int type) throws SQLException(Code)(Java Doc) public boolean providesQueryObjectGenerator() throws SQLException(Code)(Java Doc) protected byte[] s2b(String s) throws SQLException(Code)(Java Doc) public boolean storesLowerCaseIdentifiers() throws SQLException(Code)(Java Doc) public boolean storesLowerCaseQuotedIdentifiers() throws SQLException(Code)(Java Doc) public boolean storesMixedCaseIdentifiers() throws SQLException(Code)(Java Doc) public boolean storesMixedCaseQuotedIdentifiers() throws SQLException(Code)(Java Doc) public boolean storesUpperCaseIdentifiers() throws SQLException(Code)(Java Doc) public boolean storesUpperCaseQuotedIdentifiers() throws SQLException(Code)(Java Doc) public boolean supportsANSI92EntryLevelSQL() throws SQLException(Code)(Java Doc) public boolean supportsANSI92FullSQL() throws SQLException(Code)(Java Doc) public boolean supportsANSI92IntermediateSQL() throws SQLException(Code)(Java Doc) public boolean supportsAlterTableWithAddColumn() throws SQLException(Code)(Java Doc) public boolean supportsAlterTableWithDropColumn() throws SQLException(Code)(Java Doc) public boolean supportsBatchUpdates() throws SQLException(Code)(Java Doc) public boolean supportsCatalogsInDataManipulation() throws SQLException(Code)(Java Doc) public boolean supportsCatalogsInIndexDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsCatalogsInProcedureCalls() throws SQLException(Code)(Java Doc) public boolean supportsCatalogsInTableDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsColumnAliasing() throws SQLException(Code)(Java Doc) public boolean supportsConvert() throws SQLException(Code)(Java Doc) public boolean supportsConvert(int fromType, int toType) throws SQLException(Code)(Java Doc) public boolean supportsCoreSQLGrammar() throws SQLException(Code)(Java Doc) public boolean supportsCorrelatedSubqueries() throws SQLException(Code)(Java Doc) public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException(Code)(Java Doc) public boolean supportsDataManipulationTransactionsOnly() throws SQLException(Code)(Java Doc) public boolean supportsDifferentTableCorrelationNames() throws SQLException(Code)(Java Doc) public boolean supportsExpressionsInOrderBy() throws SQLException(Code)(Java Doc) public boolean supportsExtendedSQLGrammar() throws SQLException(Code)(Java Doc) public boolean supportsFullOuterJoins() throws SQLException(Code)(Java Doc) public boolean supportsGetGeneratedKeys()(Code)(Java Doc) public boolean supportsGroupBy() throws SQLException(Code)(Java Doc) public boolean supportsGroupByBeyondSelect() throws SQLException(Code)(Java Doc) public boolean supportsGroupByUnrelated() throws SQLException(Code)(Java Doc) public boolean supportsIntegrityEnhancementFacility() throws SQLException(Code)(Java Doc) public boolean supportsLikeEscapeClause() throws SQLException(Code)(Java Doc) public boolean supportsLimitedOuterJoins() throws SQLException(Code)(Java Doc) public boolean supportsMinimumSQLGrammar() throws SQLException(Code)(Java Doc) public boolean supportsMixedCaseIdentifiers() throws SQLException(Code)(Java Doc) public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException(Code)(Java Doc) public boolean supportsMultipleOpenResults() throws SQLException(Code)(Java Doc) public boolean supportsMultipleResultSets() throws SQLException(Code)(Java Doc) public boolean supportsMultipleTransactions() throws SQLException(Code)(Java Doc) public boolean supportsNamedParameters() throws SQLException(Code)(Java Doc) public boolean supportsNonNullableColumns() throws SQLException(Code)(Java Doc) public boolean supportsOpenCursorsAcrossCommit() throws SQLException(Code)(Java Doc) public boolean supportsOpenCursorsAcrossRollback() throws SQLException(Code)(Java Doc) public boolean supportsOpenStatementsAcrossCommit() throws SQLException(Code)(Java Doc) public boolean supportsOpenStatementsAcrossRollback() throws SQLException(Code)(Java Doc) public boolean supportsOrderByUnrelated() throws SQLException(Code)(Java Doc) public boolean supportsOuterJoins() throws SQLException(Code)(Java Doc) public boolean supportsPositionedDelete() throws SQLException(Code)(Java Doc) public boolean supportsPositionedUpdate() throws SQLException(Code)(Java Doc) public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException(Code)(Java Doc) public boolean supportsResultSetHoldability(int holdability) throws SQLException(Code)(Java Doc) public boolean supportsResultSetType(int type) throws SQLException(Code)(Java Doc) public boolean supportsSavepoints() throws SQLException(Code)(Java Doc) public boolean supportsSchemasInDataManipulation() throws SQLException(Code)(Java Doc) public boolean supportsSchemasInIndexDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsSchemasInProcedureCalls() throws SQLException(Code)(Java Doc) public boolean supportsSchemasInTableDefinitions() throws SQLException(Code)(Java Doc) public boolean supportsSelectForUpdate() throws SQLException(Code)(Java Doc) public boolean supportsStatementPooling() throws SQLException(Code)(Java Doc) public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException(Code)(Java Doc) public boolean supportsStoredProcedures() throws SQLException(Code)(Java Doc) public boolean supportsSubqueriesInComparisons() throws SQLException(Code)(Java Doc) public boolean supportsSubqueriesInExists() throws SQLException(Code)(Java Doc) public boolean supportsSubqueriesInIns() throws SQLException(Code)(Java Doc) public boolean supportsSubqueriesInQuantifieds() throws SQLException(Code)(Java Doc) public boolean supportsTableCorrelationNames() throws SQLException(Code)(Java Doc) public boolean supportsTransactionIsolationLevel(int level) throws SQLException(Code)(Java Doc) public boolean supportsTransactions() throws SQLException(Code)(Java Doc) public boolean supportsUnion() throws SQLException(Code)(Java Doc) public boolean supportsUnionAll() throws SQLException(Code)(Java Doc) public boolean updatesAreDetected(int type) throws SQLException(Code)(Java Doc) public boolean usesLocalFilePerTable() throws SQLException(Code)(Java Doc) public boolean usesLocalFiles() throws SQLException(Code)(Java Doc)
|
|
|