/* DatabaseMetaData.java -- Information about the database itself. Copyright (C) 1999, 2000, 2001, 2002, 2006 Free Software Foundation, Inc. This file is part of GNU Classpath. GNU Classpath is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2, or (at your option) any later version. GNU Classpath is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with GNU Classpath; see the file COPYING. If not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Linking this library statically or dynamically with other modules is making a combined work based on this library. Thus, the terms and conditions of the GNU General Public License cover the whole combination. As a special exception, the copyright holders of this library give you permission to link this library with independent modules to produce an executable, regardless of the license terms of these independent modules, and to copy and distribute the resulting executable under terms of your choice, provided that you also meet, for each linked independent module, the terms and conditions of the license of that module. An independent module is a module which is not derived from or based on this library. If you modify this library, you may extend this exception to your version of the library, but you are not obligated to do so. If you do not wish to do so, delete this exception statement from your version. */ package java.sql; public interface DatabaseMetaData { /** * It is unknown whether or not the procedure returns a result. */ int procedureResultUnknown = 0; /** * The procedure does not return a result. */ int procedureNoResult = 1; /** * The procedure returns a result. */ int procedureReturnsResult = 2; /** * The column type is unknown. */ int procedureColumnUnknown = 0; /** * The column type is input. */ int procedureColumnIn = 1; /** * The column type is input/output. */ int procedureColumnInOut = 2; /** * The column type is output */ int procedureColumnOut = 4; /** * The column is used for return values. */ int procedureColumnReturn = 5; /** * The column is used for storing results */ int procedureColumnResult = 3; /** * NULL values are not allowed. */ int procedureNoNulls = 0; /** * NULL values are allowed. */ int procedureNullable = 1; /** * It is unknown whether or not NULL values are allowed. */ int procedureNullableUnknown = 2; /** * The column does not allow NULL */ int columnNoNulls = 0; /** * The column does allow NULL */ int columnNullable = 1; /** * It is unknown whether or not the column allows NULL */ int columnNullableUnknown = 2; /** * The best row's scope is only guaranteed to be valid so long as the * row is actually being used. */ int bestRowTemporary = 0; /** * The best row identifier is valid to the end of the transaction. */ int bestRowTransaction = 1; /** * The best row identifier is valid to the end of the session. */ int bestRowSession = 2; /** * The best row may or may not be a pseudo-column. */ int bestRowUnknown = 0; /** * The best row identifier is not a pseudo-column. */ int bestRowNotPseudo = 1; /** * The best row identifier is a pseudo-column. */ int bestRowPseudo = 2; /** * It is unknown whether or not the version column is a pseudo-column. */ int versionColumnUnknown = 0; /** * The version column is not a pseudo-column */ int versionColumnNotPseudo = 1; /** * The version column is a pseudo-column */ int versionColumnPseudo = 2; /** * Foreign key changes are cascaded in updates or deletes. */ int importedKeyCascade = 0; /** * Column may not be updated or deleted in use as a foreign key. */ int importedKeyRestrict = 1; /** * When primary key is updated or deleted, the foreign key is set to NULL. */ int importedKeySetNull = 2; /** * If the primary key is a foreign key, it cannot be udpated or deleted. */ int importedKeyNoAction = 3; /** * If the primary key is updated or deleted, the foreign key is set to * a default value. */ int importedKeySetDefault = 4; /** * Wish I knew what this meant. */ int importedKeyInitiallyDeferred = 5; /** * Wish I knew what this meant. */ int importedKeyInitiallyImmediate = 6; /** * Wish I knew what this meant. */ int importedKeyNotDeferrable = 7; /** * A NULL value is not allowed for this data type. */ int typeNoNulls = 0; /** * A NULL value is allowed for this data type. */ int typeNullable = 1; /** * It is unknown whether or not NULL values are allowed for this data type. */ int typeNullableUnknown = 2; /** * Where clauses are not supported for this type. */ int typePredNone = 0; /** * Only "WHERE..LIKE" style WHERE clauses are allowed on this data type. */ int typePredChar = 1; /** * All WHERE clauses except "WHERE..LIKE" style are allowed on this data type. */ int typePredBasic = 2; /** * Any type of WHERE clause is allowed for this data type. */ int typeSearchable = 3; /** * This column contains table statistics. */ short tableIndexStatistic = 0; /** * This table index is clustered. */ short tableIndexClustered = 1; /** * This table index is hashed. */ short tableIndexHashed = 2; /** * This table index is of another type. */ short tableIndexOther = 3; /** * A NULL value is not allowed for this attribute. */ short attributeNoNulls = 0; /** * A NULL value is allowed for this attribute. */ short attributeNullable = 1; /** * It is unknown whether or not NULL values are allowed for this attribute. */ short attributeNullableUnknown = 2; int sqlStateXOpen = 1; int sqlStateSQL99 = 2; /** * This method tests whether or not all the procedures returned by * the getProcedures method can be called by this user. * * @return true if all the procedures can be called, * false otherwise. * @exception SQLException If an error occurs. */ boolean allProceduresAreCallable() throws SQLException; /** * This method tests whether or not all the table returned by the * getTables method can be selected by this user. * * @return true if all the procedures can be called, * false otherwise. * * @exception SQLException If an error occurs. */ boolean allTablesAreSelectable() throws SQLException; /** * This method returns the URL for this database. * * @return The URL string for this database, or null if it * is not known. * @exception SQLException If an error occurs. */ String getURL() throws SQLException; /** * This method returns the database username for this connection. * * @return The database username. * @exception SQLException If an error occurs. */ String getUserName() throws SQLException; /** * This method tests whether or not the database is in read only mode. * * @return true if the database is in read only mode, * false otherwise. * @exception SQLException If an error occurs. */ boolean isReadOnly() throws SQLException; /** * This method tests whether or not NULL's sort as high values. * * @return true if NULL's sort as high values, false * otherwise. * @exception SQLException If an error occurs. */ boolean nullsAreSortedHigh() throws SQLException; /** * This method tests whether or not NULL's sort as low values. * * @return true if NULL's sort as low values, false * otherwise. * @exception SQLException If an error occurs. */ boolean nullsAreSortedLow() throws SQLException; /** * This method tests whether or not NULL's sort as high values. * * @return true if NULL's sort as high values, false * otherwise. * @exception SQLException If an error occurs. */ boolean nullsAreSortedAtStart() throws SQLException; /** * This method test whether or not NULL's are sorted to the end * of the list regardless of ascending or descending sort order. * * @return true if NULL's always sort to the end, * false otherwise. * @exception SQLException If an error occurs. */ boolean nullsAreSortedAtEnd() throws SQLException; /** * This method returns the name of the database product. * * @return The database product. * @exception SQLException If an error occurs. */ String getDatabaseProductName() throws SQLException; /** * This method returns the version of the database product. * * @return The version of the database product. * @exception SQLException If an error occurs. */ String getDatabaseProductVersion() throws SQLException; /** * This method returns the name of the JDBC driver. * * @return The name of the JDBC driver. * @exception SQLException If an error occurs. */ String getDriverName() throws SQLException; /** * This method returns the version of the JDBC driver. * * @return The version of the JDBC driver. * @exception SQLException If an error occurs. */ String getDriverVersion() throws SQLException; /** * This method returns the major version number of the JDBC driver. * * @return The major version number of the JDBC driver. */ int getDriverMajorVersion(); /** * This method returns the minor version number of the JDBC driver. * * @return The minor version number of the JDBC driver. */ int getDriverMinorVersion(); /** * This method tests whether or not the database uses local files to * store tables. * * @return true if the database uses local files, * false otherwise. * * @exception SQLException If an error occurs. */ boolean usesLocalFiles() throws SQLException; /** * This method tests whether or not the database uses a separate file for * each table. * * @return true if the database uses a separate file for each * table false otherwise. * * @exception SQLException If an error occurs. */ boolean usesLocalFilePerTable() throws SQLException; /** * This method tests whether or not the database supports identifiers * with mixed case. * * @return true if the database supports mixed case identifiers, * false otherwise. * * @exception SQLException If an error occurs. */ boolean supportsMixedCaseIdentifiers() throws SQLException; /** * This method tests whether or not the database treats mixed case * identifiers as all upper case. * * @return true if the database treats all identifiers as * upper case, false otherwise. * @exception SQLException If an error occurs. */ boolean storesUpperCaseIdentifiers() throws SQLException; /** * This method tests whether or not the database treats mixed case * identifiers as all lower case. * * @return true if the database treats all identifiers as * lower case, false otherwise. * @exception SQLException If an error occurs. */ boolean storesLowerCaseIdentifiers() throws SQLException; /** * This method tests whether or not the database stores mixed case * identifers even if it treats them as case insensitive. * * @return true if the database stores mixed case identifiers, * false otherwise. * @exception SQLException If an error occurs. */ boolean storesMixedCaseIdentifiers() throws SQLException; /** * This method tests whether or not the database supports quoted identifiers * with mixed case. * * @return true if the database supports mixed case quoted * identifiers, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsMixedCaseQuotedIdentifiers() throws SQLException; /** * This method tests whether or not the database treats mixed case * quoted identifiers as all upper case. * * @return true if the database treats all quoted identifiers * as upper case, false otherwise. * @exception SQLException If an error occurs. */ boolean storesUpperCaseQuotedIdentifiers() throws SQLException; /** * This method tests whether or not the database treats mixed case * quoted identifiers as all lower case. * * @return true if the database treats all quoted identifiers * as lower case, false otherwise. * @exception SQLException If an error occurs. */ boolean storesLowerCaseQuotedIdentifiers() throws SQLException; /** * This method tests whether or not the database stores mixed case * quoted identifers even if it treats them as case insensitive. * * @return true if the database stores mixed case quoted * identifiers, false otherwise. * @exception SQLException If an error occurs. */ boolean storesMixedCaseQuotedIdentifiers() throws SQLException; /** * This metohd returns the quote string for SQL identifiers. * * @return The quote string for SQL identifers, or a space if quoting * is not supported. * @exception SQLException If an error occurs. */ String getIdentifierQuoteString() throws SQLException; /** * This method returns a comma separated list of all the SQL keywords in * the database that are not in SQL92. * * @return The list of SQL keywords not in SQL92. * @exception SQLException If an error occurs. */ String getSQLKeywords() throws SQLException; /** * This method returns a comma separated list of math functions. * * @return The list of math functions. * @exception SQLException If an error occurs. */ String getNumericFunctions() throws SQLException; /** * This method returns a comma separated list of string functions. * * @return The list of string functions. * @exception SQLException If an error occurs. */ String getStringFunctions() throws SQLException; /** * This method returns a comma separated list of of system functions. * * @return A comma separated list of system functions. * @exception SQLException If an error occurs. */ String getSystemFunctions() throws SQLException; /** * This method returns comma separated list of time/date functions. * * @return The list of time/date functions. * @exception SQLException If an error occurs. */ String getTimeDateFunctions() throws SQLException; /** * This method returns the string used to escape wildcards in search strings. * * @return The string used to escape wildcards in search strings. * @exception SQLException If an error occurs. */ String getSearchStringEscape() throws SQLException; /** * This methods returns non-standard characters that can appear in * unquoted identifiers. * * @return Non-standard characters that can appear in unquoted identifiers. * @exception SQLException If an error occurs. */ String getExtraNameCharacters() throws SQLException; /** * This method tests whether or not the database supports * "ALTER TABLE ADD COLUMN" * * @return true if column add supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsAlterTableWithAddColumn() throws SQLException; /** * This method tests whether or not the database supports * "ALTER TABLE DROP COLUMN" * * @return true if column drop supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsAlterTableWithDropColumn() throws SQLException; /** * This method tests whether or not column aliasing is supported. * * @return true if column aliasing is supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsColumnAliasing() throws SQLException; /** * This method tests whether the concatenation of a NULL and non-NULL * value results in a NULL. This will always be true in fully JDBC compliant * drivers. * * @return true if concatenating NULL and a non-NULL value * returns a NULL, false otherwise. * @exception SQLException If an error occurs. */ boolean nullPlusNonNullIsNull() throws SQLException; /** * Tests whether or not CONVERT is supported. * * @return true if CONVERT is supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsConvert() throws SQLException; /** * This method tests whether or not CONVERT can be performed between the * specified types. The types are contants from Types. * * @param fromType The SQL type to convert from. * @param toType The SQL type to convert to. * @return true if the conversion can be performed, * false otherwise. * @see Types */ boolean supportsConvert(int fromType, int toType) throws SQLException; /** * This method tests whether or not table correlation names are * supported. This will be always be true in a fully JDBC * compliant driver. * * @return true if table correlation names are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsTableCorrelationNames() throws SQLException; /** * This method tests whether correlation names must be different from the * name of the table. * * @return true if the correlation name must be different from * the table name, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsDifferentTableCorrelationNames() throws SQLException; /** * This method tests whether or not expressions are allowed in an * ORDER BY lists. * * @return true if expressions are allowed in ORDER BY * lists, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsExpressionsInOrderBy() throws SQLException; /** * This method tests whether or ORDER BY on a non-selected column is * allowed. * * @return true if a non-selected column can be used in an * ORDER BY, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsOrderByUnrelated() throws SQLException; /** * This method tests whether or not GROUP BY is supported. * * @return true if GROUP BY is supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsGroupBy() throws SQLException; /** * This method tests whether GROUP BY on a non-selected column is * allowed. * * @return true if a non-selected column can be used in a * GROUP BY, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsGroupByUnrelated() throws SQLException; /** * This method tests whether or not a GROUP BY can add columns not in the * select if it includes all the columns in the select. * * @return true if GROUP BY an add columns provided it includes * all columns in the select, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsGroupByBeyondSelect() throws SQLException; /** * This method tests whether or not the escape character is supported in * LIKE expressions. A fully JDBC compliant driver will always return * true. * * @return true if escapes are supported in LIKE expressions, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsLikeEscapeClause() throws SQLException; /** * This method tests whether multiple result sets for a single statement are * supported. * * @return true if multiple result sets are supported for a * single statement, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsMultipleResultSets() throws SQLException; /** * This method test whether or not multiple transactions may be open * at once, as long as they are on different connections. * * @return true if multiple transactions on different * connections are supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsMultipleTransactions() throws SQLException; /** * This method tests whether or not columns can be defined as NOT NULL. A * fully JDBC compliant driver always returns true. * * @return true if NOT NULL columns are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsNonNullableColumns() throws SQLException; /** * This method tests whether or not the minimum grammer for ODBC is supported. * A fully JDBC compliant driver will always return true. * * @return true if the ODBC minimum grammar is supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsMinimumSQLGrammar() throws SQLException; /** * This method tests whether or not the core grammer for ODBC is supported. * * @return true if the ODBC core grammar is supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCoreSQLGrammar() throws SQLException; /** * This method tests whether or not the extended grammer for ODBC is supported. * * @return true if the ODBC extended grammar is supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsExtendedSQLGrammar() throws SQLException; /** * This method tests whether or not the ANSI92 entry level SQL * grammar is supported. A fully JDBC compliant drivers must return * true. * * @return true if the ANSI92 entry level SQL grammar is * supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsANSI92EntryLevelSQL() throws SQLException; /** * This method tests whether or not the ANSI92 intermediate SQL * grammar is supported. * * @return true if the ANSI92 intermediate SQL grammar is * supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsANSI92IntermediateSQL() throws SQLException; /** * This method tests whether or not the ANSI92 full SQL * grammar is supported. * * @return true if the ANSI92 full SQL grammar is * supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsANSI92FullSQL() throws SQLException; /** * This method tests whether or not the SQL integrity enhancement * facility is supported. * * @return true if the integrity enhancement facility is * supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsIntegrityEnhancementFacility() throws SQLException; /** * This method tests whether or not the database supports outer joins. * * @return true if outer joins are supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsOuterJoins() throws SQLException; /** * This method tests whether or not the database supports full outer joins. * * @return true if full outer joins are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsFullOuterJoins() throws SQLException; /** * This method tests whether or not the database supports limited outer joins. * * @return true if limited outer joins are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsLimitedOuterJoins() throws SQLException; /** * This method returns the vendor's term for "schema". * * @return The vendor's term for schema. * @exception SQLException if an error occurs. */ String getSchemaTerm() throws SQLException; /** * This method returns the vendor's term for "procedure". * * @return The vendor's term for procedure. * @exception SQLException if an error occurs. */ String getProcedureTerm() throws SQLException; /** * This method returns the vendor's term for "catalog". * * @return The vendor's term for catalog. * @exception SQLException if an error occurs. */ String getCatalogTerm() throws SQLException; /** * This method tests whether a catalog name appears at the beginning of * a fully qualified table name. * * @return true if the catalog name appears at the beginning, * false if it appears at the end. * @exception SQLException If an error occurs. */ boolean isCatalogAtStart() throws SQLException; /** * This method returns the separator between the catalog name and the * table name. * * @return The separator between the catalog name and the table name. * @exception SQLException If an error occurs. */ String getCatalogSeparator() throws SQLException; /** * This method tests whether a catalog name can appear in a data * manipulation statement. * * @return true if a catalog name can appear in a data * manipulation statement, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSchemasInDataManipulation() throws SQLException; /** * This method tests whether a catalog name can appear in a procedure * call * * @return true if a catalog name can appear in a procedure * call, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSchemasInProcedureCalls() throws SQLException; /** * This method tests whether a catalog name can appear in a table definition. * * @return true if a catalog name can appear in a table * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSchemasInTableDefinitions() throws SQLException; /** * This method tests whether a catalog name can appear in an index definition. * * @return true if a catalog name can appear in an index * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSchemasInIndexDefinitions() throws SQLException; /** * This method tests whether a catalog name can appear in privilege definitions. * * @return true if a catalog name can appear in privilege * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSchemasInPrivilegeDefinitions() throws SQLException; /** * This method tests whether a catalog name can appear in a data * manipulation statement. * * @return true if a catalog name can appear in a data * manipulation statement, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCatalogsInDataManipulation() throws SQLException; /** * This method tests whether a catalog name can appear in a procedure * call * * @return true if a catalog name can appear in a procedure * call, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCatalogsInProcedureCalls() throws SQLException; /** * This method tests whether a catalog name can appear in a table definition. * * @return true if a catalog name can appear in a table * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCatalogsInTableDefinitions() throws SQLException; /** * This method tests whether a catalog name can appear in an index definition. * * @return true if a catalog name can appear in an index * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCatalogsInIndexDefinitions() throws SQLException; /** * This method tests whether a catalog name can appear in privilege definitions. * * @return true if a catalog name can appear in privilege * definition, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException; /** * This method tests whether or not that database supports positioned * deletes. * * @return true if positioned deletes are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsPositionedDelete() throws SQLException; /** * This method tests whether or not that database supports positioned * updates. * * @return true if positioned updates are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsPositionedUpdate() throws SQLException; /** * This method tests whether or not SELECT FOR UPDATE is supported by the * database. * * @return true if SELECT FOR UPDATE is supported * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSelectForUpdate() throws SQLException; /** * This method tests whether or not stored procedures are supported on * this database. * * @return true if stored procedures are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsStoredProcedures() throws SQLException; /** * This method tests whether or not subqueries are allowed in comparisons. * A fully JDBC compliant driver will always return true. * * @return true if subqueries are allowed in comparisons, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSubqueriesInComparisons() throws SQLException; /** * This method tests whether or not subqueries are allowed in exists * expressions. A fully JDBC compliant driver will always return * true. * * @return true if subqueries are allowed in exists * expressions, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSubqueriesInExists() throws SQLException; /** * This method tests whether subqueries are allowed in IN statements. * A fully JDBC compliant driver will always return true. * * @return true if the driver supports subqueries in IN * statements, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSubqueriesInIns() throws SQLException; /** * This method tests whether or not subqueries are allowed in quantified * expressions. A fully JDBC compliant driver will always return * true. * * @return true if subqueries are allowed in quantified * expressions, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsSubqueriesInQuantifieds() throws SQLException; /** * This method test whether or not correlated subqueries are allowed. A * fully JDBC compliant driver will always return true. * * @return true if correlated subqueries are allowed, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsCorrelatedSubqueries() throws SQLException; /** * This method tests whether or not the UNION statement is supported. * * @return true if UNION is supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsUnion() throws SQLException; /** * This method tests whether or not the UNION ALL statement is supported. * * @return true if UNION ALL is supported, false * otherwise. * @exception SQLException If an error occurs. */ boolean supportsUnionAll() throws SQLException; /** * This method tests whether or not the database supports cursors * remaining open across commits. * * @return true if cursors can remain open across commits, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsOpenCursorsAcrossCommit() throws SQLException; /** * This method tests whether or not the database supports cursors * remaining open across rollbacks. * * @return true if cursors can remain open across rollbacks, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsOpenCursorsAcrossRollback() throws SQLException; /** * This method tests whether or not the database supports statements * remaining open across commits. * * @return true if statements can remain open across commits, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsOpenStatementsAcrossCommit() throws SQLException; /** * This method tests whether or not the database supports statements * remaining open across rollbacks. * * @return true if statements can remain open across rollbacks, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsOpenStatementsAcrossRollback() throws SQLException; /** * This method returns the number of hex characters allowed in an inline * binary literal. * * @return The number of hex characters allowed in a binary literal, 0 meaning * either an unknown or unlimited number. * @exception SQLException If an error occurs. */ int getMaxBinaryLiteralLength() throws SQLException; /** * This method returns the maximum length of a character literal. * * @return The maximum length of a character literal. * @exception SQLException If an error occurs. */ int getMaxCharLiteralLength() throws SQLException; /** * This method returns the maximum length of a column name. * * @return The maximum length of a column name. * @exception SQLException If an error occurs. */ int getMaxColumnNameLength() throws SQLException; /** * This method returns the maximum number of columns in a GROUP BY statement. * * @return The maximum number of columns in a GROUP BY statement. * @exception SQLException If an error occurs. */ int getMaxColumnsInGroupBy() throws SQLException; /** * This method returns the maximum number of columns in an index. * * @return The maximum number of columns in an index. * @exception SQLException If an error occurs. */ int getMaxColumnsInIndex() throws SQLException; /** * This method returns the maximum number of columns in an ORDER BY statement. * * @return The maximum number of columns in an ORDER BY statement. * @exception SQLException If an error occurs. */ int getMaxColumnsInOrderBy() throws SQLException; /** * This method returns the maximum number of columns in a SELECT statement. * * @return The maximum number of columns in a SELECT statement. * @exception SQLException If an error occurs. */ int getMaxColumnsInSelect() throws SQLException; /** * This method returns the maximum number of columns in a table. * * @return The maximum number of columns in a table. * @exception SQLException If an error occurs. */ int getMaxColumnsInTable() throws SQLException; /** * This method returns the maximum number of connections this client * can have to the database. * * @return The maximum number of database connections. * @SQLException If an error occurs. */ int getMaxConnections() throws SQLException; /** * This method returns the maximum length of a cursor name. * * @return The maximum length of a cursor name. * @exception SQLException If an error occurs. */ int getMaxCursorNameLength() throws SQLException; /** * This method returns the maximum length of an index. * * @return The maximum length of an index. * @exception SQLException If an error occurs. */ int getMaxIndexLength() throws SQLException; /** * This method returns the maximum length of a schema name. * * @return The maximum length of a schema name. * @exception SQLException If an error occurs. */ int getMaxSchemaNameLength() throws SQLException; /** * This method returns the maximum length of a procedure name. * * @return The maximum length of a procedure name. * @exception SQLException If an error occurs. */ int getMaxProcedureNameLength() throws SQLException; /** * This method returns the maximum length of a catalog name. * * @return The maximum length of a catalog name. * @exception SQLException If an error occurs. */ int getMaxCatalogNameLength() throws SQLException; /** * This method returns the maximum size of a row in bytes. * * @return The maximum size of a row. * @exception SQLException If an error occurs. */ int getMaxRowSize() throws SQLException; /** * This method tests whether or not the maximum row size includes BLOB's * * @return true if the maximum row size includes BLOB's, * false otherwise. * @exception SQLException If an error occurs. */ boolean doesMaxRowSizeIncludeBlobs() throws SQLException; /** * This method includes the maximum length of a SQL statement. * * @return The maximum length of a SQL statement. * @exception SQLException If an error occurs. */ int getMaxStatementLength() throws SQLException; /** * This method returns the maximum number of statements that can be * active at any time. * * @return The maximum number of statements that can be active at any time. * @exception SQLException If an error occurs. */ int getMaxStatements() throws SQLException; /** * This method returns the maximum length of a table name. * * @return The maximum length of a table name. * @exception SQLException If an error occurs. */ int getMaxTableNameLength() throws SQLException; /** * This method returns the maximum number of tables that may be referenced * in a SELECT statement. * * @return The maximum number of tables allowed in a SELECT statement. * @exception SQLException If an error occurs. */ int getMaxTablesInSelect() throws SQLException; /** * This method returns the maximum length of a user name. * * @return The maximum length of a user name. * @exception SQLException If an error occurs. */ int getMaxUserNameLength() throws SQLException; /** * This method returns the default transaction isolation level of the * database. * * @return The default transaction isolation level of the database. * @exception SQLException If an error occurs. * @see Connection */ int getDefaultTransactionIsolation() throws SQLException; /** * This method tests whether or not the database supports transactions. * * @return true if the database supports transactions, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsTransactions() throws SQLException; /** * This method tests whether or not the database supports the specified * transaction isolation level. * * @param level The transaction isolation level. * * @return true if the specified transaction isolation level * is supported, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsTransactionIsolationLevel(int level) throws SQLException; /** * This method tests whether or not DDL and DML statements allowed within * the same transaction. * * @return true if DDL and DML statements are allowed in the * same transaction, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException; /** * This method tests whether or not only DML statement are allowed * inside a transaction. * * @return true if only DML statements are allowed in * transactions, false otherwise. * @exception SQLException If an error occurs. */ boolean supportsDataManipulationTransactionsOnly() throws SQLException; /** * This method tests whether or not a DDL statement will cause the * current transaction to be automatically committed. * * @return true if DDL causes an immediate transaction commit, * false otherwise. * @exception SQLException If an error occurs. */ boolean dataDefinitionCausesTransactionCommit() throws SQLException; /** * This method tests whether or not DDL statements are ignored in * transactions. * * @return true if DDL statements are ignored in transactions, * false otherwise. * @exception SQLException If an error occurs. */ boolean dataDefinitionIgnoredInTransactions() throws SQLException; /** * This method returns a list of all the stored procedures matching the * specified pattern in the given schema and catalog. This is returned * a ResultSet with the following columns: *

*

    *
  1. PROCEDURE_CAT - The catalog the procedure is in, which may be * null.
    2. *
  2. PROCEDURE_SCHEM - The schema the procedures is in, which may be * null.
    3. *
  3. PROCEDURE_NAME - The name of the procedure.
    4. *
  4. Unused
    5. *
  5. Unused
    6. *
  6. Unused
    7. *
  7. REMARKS - A description of the procedure
    8. *
  8. PROCEDURE_TYPE - Indicates the return type of the procedure, which * is one of the contstants defined in this class * (procedureResultUnknown, procedureNoResult, or * procedureReturnsResult).
    9. *
* * @param catalog The name of the catalog to return stored procedured from, * or "" to return procedures from all catalogs. * @param schemaPattern A schema pattern for the schemas to return stored * procedures from, or "" to return procedures from all schemas. * @param procedurePattern The pattern of procedure names to return. * @returns A ResultSet with all the requested procedures. * @exception SQLException If an error occurs. */ ResultSet getProcedures(String catalog, String schemaPattern, String procedurePattern) throws SQLException; /** * This method returns a list of the parameter and result columns for * the requested stored procedures. This is returned in the form of a * ResultSet with the following columns: *

*

    *
  1. PROCEDURE_CAT - The catalog the procedure is in, which may be * null.
    2. *
  2. PROCEDURE_SCHEM - The schema the procedures is in, which may be * null.
    3. *
  3. PROCEDURE_NAME - The name of the procedure.
    4. *
  4. COLUMN_NAME - The name of the column
    5. *
  5. COLUMN_TYPE - The type of the column, which will be one of the * contants defined in this class (procedureColumnUnknown, * procedureColumnIn, procedureColumnInOut, * procedureColumnOut, procedureColumnReturn, * or procedureColumnResult).
    6. *
  6. DATA_TYPE - The SQL type of the column. This is one of the constants * defined in Types.
    7. *
  7. TYPE_NAME - The string name of the data type for this column.
    8. *
  8. PRECISION - The precision of the column.
    9. *
  9. LENGTH - The length of the column in bytes
    10. *
  10. SCALE - The scale of the column.
    11. *
  11. RADIX - The radix of the column.
    12. *
  12. NULLABLE - Whether or not the column is NULLABLE. This is one of * the constants defined in this class (procedureNoNulls, * procedureNullable, or procedureNullableUnknown)
    13. *
  13. REMARKS - A description of the column.
    14. *
* * @param catalog The name of the catalog to return stored procedured from, * or "" to return procedures from all catalogs. * @param schemaPattern A schema pattern for the schemas to return stored * procedures from, or "" to return procedures from all schemas. * @param procedurePattern The pattern of procedures names to return. * @param columnPattern The pattern of column names to return. * @returns A ResultSet with all the requested procedures. * @exception SQLException If an error occurs. */ ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedurePattern, String columnPattern) throws SQLException; /** * This method returns a list of the requested table as a * ResultSet with the following columns: * *
    *
  1. TABLE_CAT - The catalog the table is in, which may be null.
    2. *
  2. TABLE_SCHEM - The schema the table is in, which may be null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. TABLE_TYPE - A string describing the table type. This will be one * of the values returned by the getTableTypes() method.
    5. *
  5. REMARKS - Comments about the table.
    6. *
* * @param catalog The name of the catalog to return tables from, * or "" to return tables from all catalogs. * @param schemaPattern A schema pattern for the schemas to return tables * from, or "" to return tables from all schemas. * @param tablePattern The pattern of table names to return. * @param types The list of table types to include; null returns all types. * @returns A ResultSet with all the requested tables. * @exception SQLException If an error occurs. */ ResultSet getTables(String catalog, String schemaPattern, String tablePattern, String[] types) throws SQLException; /** * This method returns the list of database schemas as a * ResultSet, with one column - TABLE_SCHEM - that is the * name of the schema. * * @return A ResultSet with all the requested schemas. * @exception SQLException If an error occurs. */ ResultSet getSchemas() throws SQLException; /** * This method returns the list of database catalogs as a * ResultSet with one column - TABLE_CAT - that is the * name of the catalog. * * @return A ResultSet with all the requested catalogs. * @exception SQLException If an error occurs. */ ResultSet getCatalogs() throws SQLException; /** * This method returns the list of database table types as a * ResultSet with one column - TABLE_TYPE - that is the * name of the table type. * * @return A ResultSet with all the requested table types. * @exception SQLException If an error occurs. */ ResultSet getTableTypes() throws SQLException; /** * This method returns a list of the tables columns for * the requested tables. This is returned in the form of a * ResultSet with the following columns: *

*

    *
  1. TABLE_CAT - The catalog the table is in, which may be * null.
    2. *
  2. TABLE_SCHEM - The schema the tables is in, which may be * null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. COLUMN_NAME - The name of the column
    5. *
  5. DATA_TYPE - The SQL type of the column. This is one of the constants * defined in Types.
    6. *
  6. TYPE_NAME - The string name of the data type for this column.
    7. *
  7. COLUMN_SIZE - The size of the column.
    8. *
  8. Unused
    9. *
  9. NUM_PREC_RADIX - The radix of the column.
    10. *
  10. NULLABLE - Whether or not the column is NULLABLE. This is one of * the constants defined in this class (tableNoNulls, * tableNullable, or tableNullableUnknown)
    11. *
  11. REMARKS - A description of the column.
    12. *
  12. COLUMN_DEF - The default value for the column, may be null.
    13. *
  13. SQL_DATA_TYPE - Unused
    14. *
  14. SQL_DATETIME_SUB - Unused
    15. *
  15. CHAR_OCTET_LENGTH - For character columns, the maximum number of bytes * in the column.
    16. *
  16. ORDINAL_POSITION - The index of the column in the table.
    17. *
  17. IS_NULLABLE - "NO" means no, "YES" means maybe, and an empty string * means unknown.
    18. *
* * @param catalog The name of the catalog to return table from, * or "" to return tables from all catalogs. * @param schemaPattern A schema pattern for the schemas to return * tables from, or "" to return tables from all schemas. * @param tablePattern The pattern of table names to return. * @param columnPattern The pattern of column names to return. * @returns A ResultSet with all the requested tables. * @exception SQLException If an error occurs. */ ResultSet getColumns(String catalog, String schemaPattern, String tablePattern, String columnPattern) throws SQLException; /** * This method returns the access rights that have been granted to the * requested columns. This information is returned as a ResultSet * with the following columns: * *
    *
  1. TABLE_CAT - The catalog the table is in, which may be * null.
    2. *
  2. TABLE_SCHEM - The schema the tables is in, which may be * null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. COLUMN_NAME - The name of the column.
    5. *
  5. GRANTOR - The entity that granted the access.
    6. *
  6. GRANTEE - The entity granted the access.
    7. *
  7. PRIVILEGE - The name of the privilege granted.
    8. *
  8. IS_GRANTABLE - "YES" if the grantee can grant the privilege to * others, "NO" if not, and null if unknown.
    9. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @param columnPattern A pattern of column names to return information for. * @return A ResultSet with all the requested privileges. * @exception SQLException If an error occurs. */ ResultSet getColumnPrivileges(String catalog, String schema, String tableName, String columnPattern) throws SQLException; /** * This method returns the access rights that have been granted to the * requested tables. This information is returned as a ResultSet * with the following columns: * *
    *
  1. TABLE_CAT - The catalog the table is in, which may be * null.
    2. *
  2. TABLE_SCHEM - The schema the tables is in, which may be * null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. GRANTOR - The entity that granted the access.
    5. *
  5. GRANTEE - The entity granted the access.
    6. *
  6. PRIVILEGE - The name of the privilege granted.
    7. *
  7. IS_GRANTABLE - "YES" if the grantee can grant the privilege to * others, "NO" if not, and null if unknown.
    8. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schemaPattern The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tablePattern The table name pattern of tables to return * information for. * @return A ResultSet with all the requested privileges. * @exception SQLException If an error occurs. */ ResultSet getTablePrivileges(String catalog, String schemaPattern, String tablePattern) throws SQLException; /** * This method returns the best set of columns for uniquely identifying * a row. It returns this information as a ResultSet with * the following columns: * *
    *
  1. SCOPE - The scope of the results returned. This is one of the * constants defined in this class (bestRowTemporary, * bestRowTransaction, or bestRowSession).
    2. *
  2. COLUMN_NAME - The name of the column.
    3. *
  3. DATA_TYPE - The SQL type of the column. This is one of the constants * defined in Types.
    4. *
  4. TYPE_NAME - The string name of the data type for this column.
    5. *
  5. COLUMN_SIZE - The precision of the columns
    6. *
  6. BUFFER_LENGTH - Unused
    7. *
  7. DECIMAL_DIGITS - The scale of the column.
    8. *
  8. PSEUDO_COLUMN - Whether or not the best row identifier is a * pseudo_column. This is one of the constants defined in this class * (bestRowUnknown, bestRowNotPseudo, or * bestRowPseudo).
    9. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @param scope One of the best row id scope constants from this class. * @param nullable true to include columns that are nullable, * false otherwise. * @return A ResultSet with the best row identifier. * @exception SQLException If an error occurs. */ ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable) throws SQLException; /** * This method returns the set of columns that are automatically updated * when the row is update. It returns this information as a * ResultSet with the following columns: * *
    *
  1. SCOPE - Unused
    2. *
  2. COLUMN_NAME - The name of the column.
    3. *
  3. DATA_TYPE - The SQL type of the column. This is one of the constants * defined in Types.
    4. *
  4. TYPE_NAME - The string name of the data type for this column.
    5. *
  5. COLUMN_SIZE - The precision of the columns
    6. *
  6. BUFFER_LENGTH - Unused
    7. *
  7. DECIMAL_DIGITS - The scale of the column.
    8. *
  8. PSEUDO_COLUMN - Whether or not the best row identifier is a * pseudo_column. This is one of the constants defined in this class * (versionRowUnknown, versionRowNotPseudo, or * versionRowPseudo).
    9. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for * @return A ResultSet with the version columns. * @exception SQLException If an error occurs. */ ResultSet getVersionColumns(String catalog, String schema, String tableName) throws SQLException; /** * This method returns a list of a table's primary key columns. These * are returned as a ResultSet with the following columns. * *
    *
  1. TABLE_CAT - The catalog of the table, which may be null.
    2. *
  2. TABLE_SCHEM - The schema of the table, which may be null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. COLUMN_NAME - The name of the column.
    5. *
  5. KEY_SEQ - The sequence number of the column within the primary key.
    6. *
  6. PK_NAME - The name of the primary key, which may be null.
    7. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @return A ResultSet with the primary key columns. * @exception SQLException If an error occurs. */ ResultSet getPrimaryKeys(String catalog, String schema, String tableName) throws SQLException; /** * This method returns a list of the table's foreign keys. These are * returned as a ResultSet with the following columns: * *
    *
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
    2. *
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
    3. *
  3. PKTABLE_NAME - The name of the table the key was imported from.
    4. *
  4. PKCOLUMN_NAME - The name of the column that was imported.
    5. *
  5. FKTABLE_CAT - The foreign key catalog name.
    6. *
  6. FKTABLE_SCHEM - The foreign key schema name.
    7. *
  7. FKTABLE_NAME - The foreign key table name.
    8. *
  8. FKCOLUMN_NAME - The foreign key column name.
    9. *
  9. KEY_SEQ - The sequence number of the column within the foreign key.
    10. *
  10. UPDATE_RULE - How the foreign key behaves when the primary key is * updated. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, importedKeySetDefault, or * importedKeyRestrict).
    11. *
  11. DELETE_RULE - How the foreign key behaves when the primary key is * deleted. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, or importedKeySetDefault)
    12. *
  12. FK_NAME - The name of the foreign key.
    13. *
  13. PK_NAME - The name of the primary key.
    14. *
  14. DEFERRABILITY - The deferrability value. This is one of the * constants defined in this table (importedKeyInitiallyDeferred, * importedKeyInitiallyImmediate, or * importedKeyNotDeferrable).
    15. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @return A ResultSet with the foreign key columns. * @exception SQLException If an error occurs. */ ResultSet getImportedKeys(String catalog, String schema, String tableName) throws SQLException; /** * This method returns a list of the table's which use this table's * primary key as a foreign key. The information is * returned as a ResultSet with the following columns: * *
    *
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
    2. *
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
    3. *
  3. PKTABLE_NAME - The name of the table the key was imported from.
    4. *
  4. PKCOLUMN_NAME - The name of the column that was imported.
    5. *
  5. FKTABLE_CAT - The foreign key catalog name.
    6. *
  6. FKTABLE_SCHEM - The foreign key schema name.
    7. *
  7. FKTABLE_NAME - The foreign key table name.
    8. *
  8. FKCOLUMN_NAME - The foreign key column name.
    9. *
  9. KEY_SEQ - The sequence number of the column within the foreign key.
    10. *
  10. UPDATE_RULE - How the foreign key behaves when the primary key is * updated. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, importedKeySetDefault, or * importedKeyRestrict).
    11. *
  11. DELETE_RULE - How the foreign key behaves when the primary key is * deleted. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, or importedKeySetDefault)
    12. *
  12. FK_NAME - The name of the foreign key.
    13. *
  13. PK_NAME - The name of the primary key.
    14. *
  14. DEFERRABILITY - The deferrability value. This is one of the * constants defined in this table (importedKeyInitiallyDeferred, * importedKeyInitiallyImmediate, or * importedKeyNotDeferrable).
    15. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @return A ResultSet with the requested information * @exception SQLException If an error occurs. */ ResultSet getExportedKeys(String catalog, String schema, String tableName) throws SQLException; /** * This method returns a description of how one table imports another * table's primary key as a foreign key. The information is * returned as a ResultSet with the following columns: * *
    *
  1. PKTABLE_CAT - The catalog of the table the key was imported from.
    2. *
  2. PKTABLE_SCHEM - The schema of the table the key was imported from.
    3. *
  3. PKTABLE_NAME - The name of the table the key was imported from.
    4. *
  4. PKCOLUMN_NAME - The name of the column that was imported.
    5. *
  5. FKTABLE_CAT - The foreign key catalog name.
    6. *
  6. FKTABLE_SCHEM - The foreign key schema name.
    7. *
  7. FKTABLE_NAME - The foreign key table name.
    8. *
  8. FKCOLUMN_NAME - The foreign key column name.
    9. *
  9. KEY_SEQ - The sequence number of the column within the foreign key.
    10. *
  10. UPDATE_RULE - How the foreign key behaves when the primary key is * updated. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, importedKeySetDefault, or * importedKeyRestrict).
    11. *
  11. DELETE_RULE - How the foreign key behaves when the primary key is * deleted. This is one of the constants defined in this class * (importedNoAction, importedKeyCascade, * importedKeySetNull, or importedKeySetDefault)
    12. *
  12. FK_NAME - The name of the foreign key.
    13. *
  13. PK_NAME - The name of the primary key.
    14. *
  14. DEFERRABILITY - The deferrability value. This is one of the * constants defined in this table (importedKeyInitiallyDeferred, * importedKeyInitiallyImmediate, or * importedKeyNotDeferrable).
    15. *
* * @param primaryCatalog The catalog to retrieve information from, or the * empty string to return entities not associated with a catalog, or * null to return information from all catalogs, on the * exporting side. * @param primarySchema The schema to retrieve information from, or the empty * string to return entities not associated with a schema, on the * exporting side. * @param primaryTableName The table name to return information for, on the * exporting side. * @param foreignCatalog The catalog to retrieve information from, or the * empty string to return entities not associated with a catalog, * or null to return information from all catalogs, on * the importing side. * @param foreignSchema The schema to retrieve information from, or the * empty string to return entities not associated with a schema on * the importing side. * @param foreignTableName The table name to return information for on the * importing side. * @return A ResultSet with the requested information * @exception SQLException If an error occurs. */ ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTableName, String foreignCatalog, String foreignSchema, String foreignTableName) throws SQLException; /** * This method returns a list of the SQL types supported by this * database. The information is returned as a ResultSet * with the following columns: * *
    *
  1. TYPE_NAME - The name of the data type.
    2. *
  2. DATA_TYPE - A data type constant from Types for this * type.
    3. *
  3. PRECISION - The maximum precision of this type.
    4. *
  4. LITERAL_PREFIX - Prefix value used to quote a literal, which may be * null.
    5. *
  5. LITERAL_SUFFIX - Suffix value used to quote a literal, which may be * null.
    6. *
  6. CREATE_PARAMS - The parameters used to create the type, which may be * null.
    7. *
  7. NULLABLE - Whether or not this type supports NULL values. This will * be one of the constants defined in this interface * (typeNoNulls, typeNullable, or * typeNullableUnknown).
    8. *
  8. CASE_SENSITIVE - Whether or not the value is case sensitive.
    9. *
  9. SEARCHABLE - Whether or not "LIKE" expressions are supported in * WHERE clauses for this type. This will be one of the constants defined * in this interface (typePredNone, typePredChar, * typePredBasic, or typeSearchable).
    10. *
  10. UNSIGNED_ATTRIBUTE - Is the value of this type unsigned.
    11. *
  11. FIXED_PREC_SCALE - Whether or not this type can be used for money.
    12. *
  12. AUTO_INCREMENT - Whether or not this type supports auto-incrementing.
    13. *
  13. LOCAL_TYPE_NAME - A localized name for this data type.
    14. *
  14. MINIMUM_SCALE - The minimum scale supported by this type.
    15. *
  15. MAXIMUM_SCALE - The maximum scale supported by this type.
    16. *
  16. SQL_DATA_TYPE - Unused.
    17. *
  17. SQL_DATETIME_SUB - Unused.
    18. *
  18. NUM_PREC_RADIX - The radix of this data type.
    19. *
* * @return A ResultSet with the list of available data types. * @exception SQLException If an error occurs. */ ResultSet getTypeInfo() throws SQLException; /** * This method returns information about a tables indices and statistics. * It is returned as a ResultSet with the following columns: * *
    *
  1. TABLE_CAT - The catalog of the table, which may be null.
    2. *
  2. TABLE_SCHEM - The schema of the table, which may be null.
    3. *
  3. TABLE_NAME - The name of the table.
    4. *
  4. NON_UNIQUE - Are index values non-unique?
    5. *
  5. INDEX_QUALIFIER The index catalog, which may be null
    6. *
  6. INDEX_NAME - The name of the index.
    7. *
  7. TYPE - The type of index, which will be one of the constants defined * in this interface (tableIndexStatistic, * tableIndexClustered, tableIndexHashed, or * tableIndexOther).
    8. *
  8. ORDINAL_POSITION - The sequence number of this column in the index. * This will be 0 when the index type is tableIndexStatistic.
    9. *
  9. COLUMN_NAME - The name of this column in the index.
    10. *
  10. ASC_OR_DESC - "A" for an ascending sort sequence, "D" for a * descending sort sequence or null if a sort sequence is not * supported.
    11. *
  11. CARDINALITY - The number of unique rows in the index, or the number * of rows in the table if the index type is tableIndexStatistic.
    12. *
  12. PAGES - The number of pages used for the index, or the number of pages * in the table if the index type is tableIndexStatistic.
    13. *
  13. FILTER_CONDITION - The filter condition for this index, which may be * null.
    14. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or * null to return information from all catalogs. * @param schema The schema to retrieve information from, or the empty string * to return entities not associated with a schema. * @param tableName The table name to return information for. * @param unique true to return only unique indexes, * false otherwise. * @param approximate true if data values can be approximations, * false otherwise. * @return A ResultSet with the requested index information * @exception SQLException If an error occurs. */ ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate) throws SQLException; /** * This method tests whether or not the datbase supports the specified * result type. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * * @return true if the result set type is supported, * false otherwise. * * @exception SQLException If an error occurs. * * @see ResultSet */ boolean supportsResultSetType(int type) throws SQLException; /** * This method tests whether the specified result set type and result set * concurrency type are supported by the database. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @param concurrency The desired concurrency type, which is one of the * constants defined in ResultSet. * @return true if the result set type is supported, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException; /** * This method tests whether or not the specified result set type sees its * own updates. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees its own updates, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean ownUpdatesAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type sees its * own deletes. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees its own deletes, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean ownDeletesAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type sees its * own inserts. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees its own inserts, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean ownInsertsAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type sees * updates committed by others. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees other updates, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean othersUpdatesAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type sees * deletes committed by others. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees other deletes, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean othersDeletesAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type sees * inserts committed by others. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type sees other inserts, * false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean othersInsertsAreVisible(int type) throws SQLException; /** * This method tests whether or not the specified result set type can detect * a visible update by calling the rowUpdated method. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type can detect visible updates * using rowUpdated, false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean updatesAreDetected(int type) throws SQLException; /** * This method tests whether or not the specified result set type can detect * a visible delete by calling the rowUpdated method. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type can detect visible deletes * using rowUpdated, false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean deletesAreDetected(int type) throws SQLException; /** * This method tests whether or not the specified result set type can detect * a visible insert by calling the rowUpdated method. * * @param type The desired result type, which is one of the constants * defined in ResultSet. * @return true if the result set type can detect visible inserts * using rowUpdated, false otherwise. * @exception SQLException If an error occurs. * @see ResultSet */ boolean insertsAreDetected(int type) throws SQLException; /** * This method tests whether or not the database supports batch updates. * * @return true if batch updates are supported, * false otherwise. * @exception SQLException If an error occurs. */ boolean supportsBatchUpdates() throws SQLException; /** * This method returns the list of user defined data types in use. These * are returned as a ResultSet with the following columns: * *
    *
  1. TYPE_CAT - The catalog name, which may be null.
    2. *
  2. TYPE_SCEHM - The schema name, which may be null.
    3. *
  3. TYPE_NAME - The user defined data type name.
    4. *
  4. CLASS_NAME - The Java class name this type maps to.
    5. *
  5. DATA_TYPE - A type identifier from Types for this type. * This will be one of JAVA_OBJECT, STRUCT, or * DISTINCT.
    6. *
  6. REMARKS - Comments about this data type.
    7. *
* * @param catalog The catalog to retrieve information from, or the empty string * to return entities not associated with a catalog, or null * to return information from all catalogs. * @param schemaPattern The schema to retrieve information from, or the * empty string to return entities not associated with a schema. * @param typePattern The type name pattern to match. * @param types The type identifier patterns (from Types) to * match. * @return A ResultSet with the requested type information * @exception SQLException If an error occurs. */ ResultSet getUDTs(String catalog, String schemaPattern, String typePattern, int[] types) throws SQLException; /** * This method returns the Connection object that was used * to generate the metadata in this object. * * @return The connection for this object. * @exception SQLException If an error occurs. */ Connection getConnection() throws SQLException; /** * This method tests whether the databse supports savepoints. * * @return true if the database supports savepoints, * false if it does not. * @exception SQLException If an error occurs. * @see Savepoint * @since 1.4 */ boolean supportsSavepoints() throws SQLException; /** * This method tests whether the database supports named parameters. * * @return true if the database supports named parameters, * false if it does not. * @exception SQLException If an error occurs. * @since 1.4 */ boolean supportsNamedParameters() throws SQLException; /** * This method tests whether the database supports returning multiple * ResultSetS from a CallableStatement at once. * * @return true if the database supports returnig multiple * results at once, false if it does not. * @exception SQLException If an error occurs. * @since 1.4 */ boolean supportsMultipleOpenResults() throws SQLException; /** * @since 1.4 */ boolean supportsGetGeneratedKeys() throws SQLException; /** * @since 1.4 */ ResultSet getSuperTypes(String catalog, String schemaPattern, String typePattern) throws SQLException; /** * @since 1.4 */ ResultSet getSuperTables(String catalog, String schemaPattern, String tablePattern) throws SQLException; /** * @since 1.4 */ ResultSet getAttributes(String catalog, String schemaPattern, String typePattern, String attributePattern) throws SQLException; /** * This method tests if the database supports the specified holdability type. * Valid values for this parameter are specified in the * ResultSet class. * * @param holdability The holdability type to test. * @return true if the database supports the holdability type, * false if it does not. * @exception SQLException If an error occurs. * @see ResultSet * @since 1.4 */ boolean supportsResultSetHoldability(int holdability) throws SQLException; /** * This method returns the default holdability type of ResultSetS * retrieved from this database. The possible values are specified in the * ResultSet class. * * @return The default holdability type. * @exception SQLException If an error occurs. * @since 1.4 */ int getResultSetHoldability() throws SQLException; /** * This method returns the major version number of the database. * * @return The major version number of the database. * @exception SQLException If an error occurs. * @since 1.4 */ int getDatabaseMajorVersion() throws SQLException; /** * This method returns the minor version number of the database. * * @return The minor version number of the database. * @exception SQLException If an error occurs. * @since 1.4 */ int getDatabaseMinorVersion() throws SQLException; /** * This method returns the major version number of the JDBC driver. * * @return The major version number of the JDBC driver. * @exception SQLException If an error occurs. * @since 1.4 */ int getJDBCMajorVersion() throws SQLException; /** * This method returns the minor version number of the JDBC driver. * * @return The minor version number of the database. * @exception SQLException If an error occurs. * @since 1.4 */ int getJDBCMinorVersion() throws SQLException; /** * @since 1.4 */ int getSQLStateType() throws SQLException; /** * @since 1.4 */ boolean locatorsUpdateCopy() throws SQLException; /** * @since 1.4 */ boolean supportsStatementPooling() throws SQLException; }