Method Summary |
|
public void | addPropertyChangeListener(PropertyChangeListener listener) |
public boolean | allProceduresAreCallable() |
public boolean | allTablesAreSelectable() |
public boolean | autoCommitFailureClosesAllResultSets() |
public boolean | dataDefinitionCausesTransactionCommit() |
public boolean | dataDefinitionIgnoredInTransactions() |
public boolean | deletesAreDetected(int type) Indicates whether or not a visible row delete can be detected by
calling ResultSet.rowDeleted(). |
public boolean | doesMaxRowSizeIncludeBlobs() |
public int | getANSI92EntryLevelSQL() |
public int | getANSI92FullSQL() |
public int | getANSI92IntermediateSQL() |
public int | getAlterTableWithAddColumn() |
public int | getAlterTableWithDropColumn() |
public ResultSet | getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) |
public int | getBatchUpdates() |
public ResultSet | getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) Gets a description of a table's optimal set of columns that
uniquely identifies a row. |
public String | getBestRowIdentifierQuery() |
public boolean | getCapitializeUsername() |
public String | getCatalogSeparator() |
public String | getCatalogTerm() |
public ResultSet | getCatalogs() Gets the catalog names available in this database. |
public int | getCatalogsInDataManipulation() |
public int | getCatalogsInIndexDefinitions() |
public int | getCatalogsInPrivilegeDefinitions() |
public int | getCatalogsInProcedureCalls() |
public int | getCatalogsInTableDefinitions() |
public String | getCatalogsQuery() |
public ResultSet | getClientInfoProperties() |
public int | getColumnAliasing() |
public ResultSet | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) Gets a description of the access rights for a table's columns. |
public String | getColumnPrivilegesQuery() |
public ResultSet | getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Gets a description of table columns available in
the specified catalog. |
public String | getColumnsQuery() |
public Connection | getConnection() Retrieves the connection that produced this metadata object. |
public int | getConvert() |
public int | getCoreSQLGrammar() |
public int | getCorrelatedSubqueries() |
public ResultSet | getCrossReference(String catalog, String schema, String table, String foreignCatalog, String foreignSchema, String foreignTable) Gets 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 String | getCrossReferenceQuery() |
public int | getDataDefinitionAndDataManipulationTransactions() |
public int | getDataDefinitionCausesTransactionCommit() |
public int | getDataDefinitionIgnoredInTransactions() |
public int | getDataManipulationTransactionsOnly() |
public int | getDatabaseMajorVersion() |
public int | getDatabaseMinorVersion() |
public String | getDatabaseProductName() |
public String | getDatabaseProductVersion() |
public int | getDefaultTransactionIsolation() What's the database's default transaction isolation level? The
values are defined in java.sql.Connection . |
public int | getDifferentTableCorrelationNames() |
public int | getDriverMajorVersion() |
public int | getDriverMinorVersion() |
public String | getDriverName() |
public String | getDriverVersion() |
public ResultSet | getExportedKeys(String catalog, String schema, String table) Gets a description of the foreign key columns that reference a
table's primary key columns (the foreign keys exported by a
table). |
public String | getExportedKeysQuery() |
public int | getExpressionsInOrderBy() |
public int | getExtendedSQLGrammar() |
public String | getExtraNameCharacters() Gets all the "extra" characters that can be used in unquoted
identifier names (those beyond a-z, A-Z, 0-9 and _). |
public int | getFullOuterJoins() |
public ResultSet | getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) |
public ResultSet | getFunctions(String catalog, String schemaPattern, String functionNamePattern) |
public int | getGroupBy() |
public int | getGroupByBeyondSelect() |
public int | getGroupByUnrelated() |
public String | getIdentifierQuoteString() What's the string used to quote SQL identifiers?
This returns a space " " if identifier quoting isn't supported. |
public int | getIdentifierStore() |
public ResultSet | getImportedKeys(String catalog, String schema, String table) Gets 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 String | getImportedKeysQuery() |
public ResultSet | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) Gets a description of a table's indices and statistics. |
public String | getIndexInfoQuery() |
public int | getIntegrityEnhancementFacility() |
public int | getJDBCMajorVersion() |
public int | getJDBCMinorVersion() |
public int | getLikeEscapeClause() |
public int | getLimitedOuterJoins() |
public int | getLocalFilePerTable() |
public int | getLocalFiles() |
public int | getMaxBinaryLiteralLength() |
public int | getMaxCatalogNameLength() |
public int | getMaxCharLiteralLength() |
public int | getMaxColumnNameLength() |
public int | getMaxColumnsInGroupBy() |
public int | getMaxColumnsInIndex() |
public int | getMaxColumnsInOrderBy() |
public int | getMaxColumnsInSelect() |
public int | getMaxColumnsInTable() |
public int | getMaxConnections() |
public int | getMaxCursorNameLength() |
public int | getMaxIndexLength() |
public int | getMaxProcedureNameLength() |
public int | getMaxRowSize() |
public int | getMaxRowSizeIncludeBlobs() |
public int | getMaxSchemaNameLength() |
public int | getMaxStatementLength() |
public int | getMaxStatements() |
public int | getMaxTableNameLength() |
public int | getMaxTablesInSelect() |
public int | getMaxUserNameLength() |
public DatabaseMetaData | getMetaData() |
public int | getMinimumSQLGrammar() |
public int | getMixedCaseIdentifiers() |
public int | getMixedCaseQuotedIdentifiers() |
public int | getMultipleResultSets() |
public int | getMultipleTransactions() |
public int | getNonNullableColumns() |
public int | getNullPlusNonNullIsNull() |
public int | getNullSort() |
public String | getNumericFunctions() Gets a comma-separated list of math functions. |
public int | getOpenCursorsAcrossCommit() |
public int | getOpenCursorsAcrossRollback() |
public int | getOpenStatementsAcrossCommit() |
public int | getOpenStatementsAcrossRollback() |
public int | getOrderByUnrelated() |
public int | getOuterJoins() |
public int | getPositionedDelete() |
public int | getPositionedUpdate() |
public ResultSet | getPrimaryKeys(String catalog, String schema, String table) Gets a description of a table's primary key columns. |
public String | getPrimaryKeysQuery() |
public ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) Gets a description of a catalog's stored procedure parameters
and result columns. |
public String | getProcedureColumnsQuery() |
public String | getProcedureTerm() |
public ResultSet | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) Gets a description of the stored procedures available in a
catalog. |
public int | getProceduresAreCallable() |
public String | getProceduresQuery() |
public int | getQuotedIdentifierStore() |
public int | getResultSetHoldability() |
public java.sql.RowIdLifetime | getRowIdLifetime() |
public String | getSQLKeywords() Gets a comma-separated list of all a database's SQL keywords
that are NOT also SQL92 keywords. |
public int | getSQLStateType() |
public String | getSchemaTerm() |
public ResultSet | getSchemas() Gets the schema names available in this database. |
public ResultSet | getSchemas(String catalog, String schemaPattern) |
public int | getSchemasInDataManipulation() |
public int | getSchemasInIndexDefinitions() |
public int | getSchemasInPrivilegeDefinitions() |
public int | getSchemasInProcedureCalls() |
public int | getSchemasInTableDefinitions() |
public String | getSchemasQuery() |
public String | getSearchStringEscape() Gets the string that can be used to escape wildcard characters. |
public int | getSelectForUpdate() |
public int | getStoredProcedures() |
public String | getStringFunctions() Gets a comma-separated list of string functions. |
public int | getSubqueriesInComparisons() |
public int | getSubqueriesInExists() |
public int | getSubqueriesInIns() |
public int | getSubqueriesInQuantifieds() |
public ResultSet | getSuperTables(String catalog, String schemaPattern, String tableNamePattern) |
public ResultSet | getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) |
public String | getSystemFunctions() Gets a comma-separated list of system functions. |
public int | getTableCorrelationNames() |
public ResultSet | getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) Gets a description of the access rights for each table available
in a catalog. |
public String | getTablePrivilegesQuery() |
public ResultSet | getTableTypes() Gets the table types available in this database. |
public String | getTableTypesQuery() |
public ResultSet | getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) Gets a description of tables available in a catalog. |
public int | getTablesAreSelectable() |
public String | getTablesQuery() |
public String | getTimeDateFunctions() Gets a comma-separated list of time and date functions. |
public int | getTransactions() |
public ResultSet | getTypeInfo() Gets a description of all the standard SQL types supported by
this database. |
public String | getTypeInfoQuery() |
public ResultSet | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) Gets a description of the user-defined types defined in a particular
schema. |
public String | getUDTsQuery() |
public String | getURL() |
public int | getUnion() |
public int | getUnionAll() |
public String | getUserName() |
public ResultSet | getVersionColumns(String catalog, String schema, String table) Gets a description of a table's columns that are automatically
updated when any value in a row is updated. |
public String | getVersionColumnsQuery() |
public int | getcatalogAtStart() |
public int | getreadOnly() |
public boolean | insertsAreDetected(int type) Indicates whether or not a visible row insert can be detected
by calling ResultSet.rowInserted().
Parameters: result - set type, i.e. |
public boolean | isCatalogAtStart() |
public boolean | isReadOnly() |
public boolean | isWrapperFor(Class clazz) |
public boolean | locatorsUpdateCopy() |
public boolean | nullPlusNonNullIsNull() Are concatenations between NULL and non-NULL values NULL?
A JDBC CompliantTM driver always returns true. |
public boolean | nullsAreSortedAtEnd() |
public boolean | nullsAreSortedAtStart() |
public boolean | nullsAreSortedHigh() |
public boolean | nullsAreSortedLow() |
public boolean | othersDeletesAreVisible(int type) Indicates whether deletes made by others are visible.
Parameters: result - set type, i.e. |
public boolean | othersInsertsAreVisible(int type) Indicates whether inserts made by others are visible.
Parameters: result - set type, i.e. |
public boolean | othersUpdatesAreVisible(int type) Indicates whether updates made by others are visible.
Parameters: result - set type, i.e. |
public boolean | ownDeletesAreVisible(int type) Indicates whether a result set's own deletes are visible.
Parameters: result - set type, i.e. |
public boolean | ownInsertsAreVisible(int type) Indicates whether a result set's own inserts are visible.
Parameters: result - set type, i.e. |
public boolean | ownUpdatesAreVisible(int type) Indicates whether a result set's own updates are visible.
Parameters: result - set type, i.e. |
public boolean | providesQueryObjectGenerator() |
public void | removePropertyChangeListener(PropertyChangeListener listener) |
public void | setANSI92EntryLevelSQL(int value) |
public void | setANSI92FullSQL(int value) |
public void | setANSI92IntermediateSQL(int value) |
public void | setAlterTableWithAddColumn(int value) |
public void | setAlterTableWithDropColumn(int value) |
public void | setBatchUpdates(int value) |
public void | setBestRowIdentifierQuery(String value) |
public void | setCapitializeUsername(boolean value) |
public void | setCatalogSeparator(String value) |
public void | setCatalogTerm(String value) |
public void | setCatalogsInDataManipulation(int value) |
public void | setCatalogsInIndexDefinitions(int value) |
public void | setCatalogsInPrivilegeDefinitions(int value) |
public void | setCatalogsInProcedureCalls(int value) |
public void | setCatalogsInTableDefinitions(int value) |
public void | setCatalogsQuery(String value) |
public void | setColumnAliasing(int value) |
public void | setColumnPrivilegesQuery(String value) |
public void | setColumnsQuery(String value) |
public void | setConnection(Connection conn) Sets the connection that produced this metadata object. |
public void | setConvert(int value) |
public void | setCoreSQLGrammar(int value) |
public void | setCorrelatedSubqueries(int value) |
public void | setCrossReferenceQuery(String value) |
public void | setDataDefinitionAndDataManipulationTransactions(int value) |
public void | setDataDefinitionCausesTransactionCommit(int value) |
public void | setDataDefinitionIgnoredInTransactions(int value) |
public void | setDataManipulationTransactionsOnly(int value) |
public void | setDatabaseProductName(String value) |
public void | setDatabaseProductVersion(String value) |
public void | setDefaultTransactionIsolation(int value) |
public void | setDifferentTableCorrelationNames(int value) |
public void | setDriverMajorVersion(int value) |
public void | setDriverMinorVersion(int value) |
public void | setDriverName(String value) |
public void | setDriverVersion(String value) |
public void | setExportedKeysQuery(String value) |
public void | setExpressionsInOrderBy(int value) |
public void | setExtendedSQLGrammar(int value) |
public void | setExtraNameCharacters(String value) |
public void | setFullOuterJoins(int value) |
public void | setGroupBy(int value) |
public void | setGroupByBeyondSelect(int value) |
public void | setGroupByUnrelated(int value) |
public void | setIdentifierQuoteString(String value) |
public void | setIdentifierStore(int value) |
public void | setImportedKeysQuery(String value) |
public void | setIndexInfoQuery(String value) |
public void | setIntegrityEnhancementFacility(int value) |
public void | setLikeEscapeClause(int value) |
public void | setLimitedOuterJoins(int value) |
public void | setLocalFilePerTable(int value) |
public void | setLocalFiles(int value) |
public void | setMaxBinaryLiteralLength(int value) |
public void | setMaxCatalogNameLength(int value) |
public void | setMaxCharLiteralLength(int value) |
public void | setMaxColumnNameLength(int value) |
public void | setMaxColumnsInGroupBy(int value) |
public void | setMaxColumnsInIndex(int value) |
public void | setMaxColumnsInOrderBy(int value) |
public void | setMaxColumnsInSelect(int value) |
public void | setMaxColumnsInTable(int value) |
public void | setMaxConnections(int value) |
public void | setMaxCursorNameLength(int value) |
public void | setMaxIndexLength(int value) |
public void | setMaxProcedureNameLength(int value) |
public void | setMaxRowSize(int value) |
public void | setMaxRowSizeIncludeBlobs(int value) |
public void | setMaxSchemaNameLength(int value) |
public void | setMaxStatementLength(int value) |
public void | setMaxStatements(int value) |
public void | setMaxTableNameLength(int value) |
public void | setMaxTablesInSelect(int value) |
public void | setMaxUserNameLength(int value) |
public void | setMinimumSQLGrammar(int value) |
public void | setMixedCaseIdentifiers(int value) |
public void | setMixedCaseQuotedIdentifiers(int value) |
public void | setMultipleResultSets(int value) |
public void | setMultipleTransactions(int value) |
public void | setNonNullableColumns(int value) |
public void | setNullPlusNonNullIsNull(int value) |
public void | setNullSort(int value) |
public void | setNumericFunctions(String value) |
public void | setOpenCursorsAcrossCommit(int value) |
public void | setOpenCursorsAcrossRollback(int value) |
public void | setOpenStatementsAcrossCommit(int value) |
public void | setOpenStatementsAcrossRollback(int value) |
public void | setOrderByUnrelated(int value) |
public void | setOuterJoins(int value) |
public void | setPositionedDelete(int value) |
public void | setPositionedUpdate(int value) |
public void | setPrimaryKeysQuery(String value) |
public void | setProcedureColumnsQuery(String value) |
public void | setProcedureTerm(String value) |
public void | setProceduresAreCallable(int value) |
public void | setProceduresQuery(String value) |
public void | setQuotedIdentifierStore(int value) |
public void | setSQLKeywords(String value) |
public void | setSchemaTerm(String value) |
public void | setSchemasInDataManipulation(int value) |
public void | setSchemasInIndexDefinitions(int value) |
public void | setSchemasInPrivilegeDefinitions(int value) |
public void | setSchemasInProcedureCalls(int value) |
public void | setSchemasInTableDefinitions(int value) |
public void | setSchemasQuery(String value) |
public void | setSearchStringEscape(String value) |
public void | setSelectForUpdate(int value) |
public void | setStoredProcedures(int value) |
public void | setStringFunctions(String value) |
public void | setSubqueriesInComparisons(int value) |
public void | setSubqueriesInExists(int value) |
public void | setSubqueriesInIns(int value) |
public void | setSubqueriesInQuantifieds(int value) |
public void | setSystemFunctions(String value) |
public void | setTableCorrelationNames(int value) |
public void | setTablePrivilegesQuery(String value) |
public void | setTableTypesQuery(String value) |
public void | setTablesAreSelectable(int value) |
public void | setTablesQuery(String value) |
public void | setTimeDateFunctions(String value) |
public void | setTransactions(int value) |
public void | setTypeInfoQuery(String value) |
public void | setUDTsQuery(String value) |
public void | setURL(String value) |
public void | setUnion(int value) |
public void | setUnionAll(int value) |
public void | setUserName(String value) |
public void | setVersionColumnsQuery(String value) |
public void | setcatalogAtStart(int value) |
public void | setreadOnly(int flag) |
public boolean | storesLowerCaseIdentifiers() |
public boolean | storesLowerCaseQuotedIdentifiers() |
public boolean | storesMixedCaseIdentifiers() |
public boolean | storesMixedCaseQuotedIdentifiers() |
public boolean | storesUpperCaseIdentifiers() |
public boolean | storesUpperCaseQuotedIdentifiers() |
public boolean | supportsANSI92EntryLevelSQL() Is the ANSI92 entry level SQL grammar supported?
All JDBC CompliantTM drivers must return true. |
public boolean | supportsANSI92FullSQL() |
public boolean | supportsANSI92IntermediateSQL() |
public boolean | supportsAlterTableWithAddColumn() |
public boolean | supportsAlterTableWithDropColumn() |
public boolean | supportsBatchUpdates() Indicates whether the driver supports batch updates. |
public boolean | supportsCatalogsInDataManipulation() |
public boolean | supportsCatalogsInIndexDefinitions() |
public boolean | supportsCatalogsInPrivilegeDefinitions() |
public boolean | supportsCatalogsInProcedureCalls() |
public boolean | supportsCatalogsInTableDefinitions() |
public boolean | supportsColumnAliasing() Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for
computed columns or to provide alias names for columns as
required. |
public boolean | supportsConvert() |
public boolean | supportsConvert(int fromType, int toType) |
public boolean | supportsCoreSQLGrammar() |
public boolean | supportsCorrelatedSubqueries() Are correlated subqueries supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsDataDefinitionAndDataManipulationTransactions() |
public boolean | supportsDataManipulationTransactionsOnly() |
public boolean | supportsDifferentTableCorrelationNames() |
public boolean | supportsExpressionsInOrderBy() |
public boolean | supportsExtendedSQLGrammar() |
public boolean | supportsFullOuterJoins() |
public boolean | supportsGetGeneratedKeys() |
public boolean | supportsGroupBy() |
public boolean | supportsGroupByBeyondSelect() |
public boolean | supportsGroupByUnrelated() |
public boolean | supportsIntegrityEnhancementFacility() |
public boolean | supportsLikeEscapeClause() Is the escape character in "LIKE" clauses supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsLimitedOuterJoins() |
public boolean | supportsMinimumSQLGrammar() Is the ODBC Minimum SQL grammar supported?
All JDBC CompliantTM drivers must return true. |
public boolean | supportsMixedCaseIdentifiers() |
public boolean | supportsMixedCaseQuotedIdentifiers() Does the database treat mixed case quoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC CompliantTM driver will always return true. |
public boolean | supportsMultipleOpenResults() |
public boolean | supportsMultipleResultSets() |
public boolean | supportsMultipleTransactions() |
public boolean | supportsNamedParameters() |
public boolean | supportsNonNullableColumns() Can columns be defined as non-nullable?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsOpenCursorsAcrossCommit() |
public boolean | supportsOpenCursorsAcrossRollback() |
public boolean | supportsOpenStatementsAcrossCommit() |
public boolean | supportsOpenStatementsAcrossRollback() |
public boolean | supportsOrderByUnrelated() |
public boolean | supportsOuterJoins() |
public boolean | supportsPositionedDelete() |
public boolean | supportsPositionedUpdate() |
public boolean | supportsResultSetConcurrency(int type, int concurrency) |
public boolean | supportsResultSetHoldability(int holdability) |
public boolean | supportsResultSetType(int type) |
public boolean | supportsSavepoints() |
public boolean | supportsSchemasInDataManipulation() |
public boolean | supportsSchemasInIndexDefinitions() |
public boolean | supportsSchemasInPrivilegeDefinitions() |
public boolean | supportsSchemasInProcedureCalls() |
public boolean | supportsSchemasInTableDefinitions() |
public boolean | supportsSelectForUpdate() |
public boolean | supportsStatementPooling() |
public boolean | supportsStoredFunctionsUsingCallSyntax() |
public boolean | supportsStoredProcedures() |
public boolean | supportsSubqueriesInComparisons() Are subqueries in comparison expressions supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsSubqueriesInExists() Are subqueries in 'exists' expressions supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsSubqueriesInIns() Are subqueries in 'in' statements supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsSubqueriesInQuantifieds() Are subqueries in quantified expressions supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsTableCorrelationNames() Are table correlation names supported?
A JDBC CompliantTM driver always returns true. |
public boolean | supportsTransactionIsolationLevel(int level) |
public boolean | supportsTransactions() |
public boolean | supportsUnion() |
public boolean | supportsUnionAll() |
public Object | unwrap(java.lang.Class iface) |
public boolean | updatesAreDetected(int type) Indicates whether or not a visible row update can be detected by
calling the method ResultSet.rowUpdated .
Parameters: result - set type, i.e. |
public boolean | usesLocalFilePerTable() |
public boolean | usesLocalFiles() |