|
JavaTM 2 Platform Std. Ed. v1.4.2 |
||||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||||
| Packages that use SQLException | |
| java.sql | Provides the API for accessing and processing data stored in a data source (usually a relational database) using the JavaTM programming language. |
| javax.sql | Provides the API for server side data source access and processing from the JavaTM programming language. |
| Uses of SQLException in java.sql |
| Subclasses of SQLException in java.sql | |
class |
BatchUpdateException
An exception thrown when an error occurs during a batch update operation. |
class |
DataTruncation
An exception that reports a DataTruncation warning (on reads) or throws a DataTruncation exception (on writes) when JDBC unexpectedly truncates a data value. |
class |
SQLWarning
An exception that provides information on database access warnings. |
| Methods in java.sql that return SQLException | |
SQLException |
SQLException.getNextException()
Retrieves the exception chained to this SQLException object. |
| Methods in java.sql with parameters of type SQLException | |
void |
SQLException.setNextException(SQLException ex)
Adds an SQLException object to the end of the chain. |
| Methods in java.sql that throw SQLException | |
static Connection |
DriverManager.getConnection(String url,
Properties info)
Attempts to establish a connection to the given database URL. |
static Connection |
DriverManager.getConnection(String url,
String user,
String password)
Attempts to establish a connection to the given database URL. |
static Connection |
DriverManager.getConnection(String url)
Attempts to establish a connection to the given database URL. |
static Driver |
DriverManager.getDriver(String url)
Attempts to locate a driver that understands the given URL. |
static void |
DriverManager.registerDriver(Driver driver)
Registers the given driver with the DriverManager. |
static void |
DriverManager.deregisterDriver(Driver driver)
Drops a driver from the DriverManager's list. |
Connection |
Driver.connect(String url,
Properties info)
Attempts to make a database connection to the given URL. |
boolean |
Driver.acceptsURL(String url)
Retrieves whether the driver thinks that it can open a connection to the given URL. |
DriverPropertyInfo[] |
Driver.getPropertyInfo(String url,
Properties info)
Gets information about the possible properties for this driver. |
String |
Struct.getSQLTypeName()
Retrieves the SQL type name of the SQL structured type that this Struct object represents. |
Object[] |
Struct.getAttributes()
Produces the ordered values of the attributes of the SQL structurec type that this Struct object represents. |
Object[] |
Struct.getAttributes(Map map)
Produces the ordered values of the attributes of the SQL structurec type that this Struct object represents. |
void |
SQLOutput.writeString(String x)
Writes the next attribute to the stream as a String
in the Java programming language. |
void |
SQLOutput.writeBoolean(boolean x)
Writes the next attribute to the stream as a Java boolean. |
void |
SQLOutput.writeByte(byte x)
Writes the next attribute to the stream as a Java byte. |
void |
SQLOutput.writeShort(short x)
Writes the next attribute to the stream as a Java short. |
void |
SQLOutput.writeInt(int x)
Writes the next attribute to the stream as a Java int. |
void |
SQLOutput.writeLong(long x)
Writes the next attribute to the stream as a Java long. |
void |
SQLOutput.writeFloat(float x)
Writes the next attribute to the stream as a Java float. |
void |
SQLOutput.writeDouble(double x)
Writes the next attribute to the stream as a Java double. |
void |
SQLOutput.writeBigDecimal(BigDecimal x)
Writes the next attribute to the stream as a java.math.BigDecimal object. |
void |
SQLOutput.writeBytes(byte[] x)
Writes the next attribute to the stream as an array of bytes. |
void |
SQLOutput.writeDate(Date x)
Writes the next attribute to the stream as a java.sql.Date object. |
void |
SQLOutput.writeTime(Time x)
Writes the next attribute to the stream as a java.sql.Time object. |
void |
SQLOutput.writeTimestamp(Timestamp x)
Writes the next attribute to the stream as a java.sql.Timestamp object. |
void |
SQLOutput.writeCharacterStream(Reader x)
Writes the next attribute to the stream as a stream of Unicode characters. |
void |
SQLOutput.writeAsciiStream(InputStream x)
Writes the next attribute to the stream as a stream of ASCII characters. |
void |
SQLOutput.writeBinaryStream(InputStream x)
Writes the next attribute to the stream as a stream of uninterpreted bytes. |
void |
SQLOutput.writeObject(SQLData x)
Writes to the stream the data contained in the given SQLData object. |
void |
SQLOutput.writeRef(Ref x)
Writes an SQL REF value to the stream. |
void |
SQLOutput.writeBlob(Blob x)
Writes an SQL BLOB value to the stream. |
void |
SQLOutput.writeClob(Clob x)
Writes an SQL CLOB value to the stream. |
void |
SQLOutput.writeStruct(Struct x)
Writes an SQL structured type value to the stream. |
void |
SQLOutput.writeArray(Array x)
Writes an SQL ARRAY value to the stream. |
void |
SQLOutput.writeURL(URL x)
Writes a SQL DATALINK value to the stream. |
String |
SQLInput.readString()
Reads the next attribute in the stream and returns it as a String
in the Java programming language. |
boolean |
SQLInput.readBoolean()
Reads the next attribute in the stream and returns it as a boolean
in the Java programming language. |
byte |
SQLInput.readByte()
Reads the next attribute in the stream and returns it as a byte
in the Java programming language. |
short |
SQLInput.readShort()
Reads the next attribute in the stream and returns it as a short
in the Java programming language. |
int |
SQLInput.readInt()
Reads the next attribute in the stream and returns it as an int
in the Java programming language. |
long |
SQLInput.readLong()
Reads the next attribute in the stream and returns it as a long
in the Java programming language. |
float |
SQLInput.readFloat()
Reads the next attribute in the stream and returns it as a float
in the Java programming language. |
double |
SQLInput.readDouble()
Reads the next attribute in the stream and returns it as a double
in the Java programming language. |
BigDecimal |
SQLInput.readBigDecimal()
Reads the next attribute in the stream and returns it as a java.math.BigDecimal
object in the Java programming language. |
byte[] |
SQLInput.readBytes()
Reads the next attribute in the stream and returns it as an array of bytes in the Java programming language. |
Date |
SQLInput.readDate()
Reads the next attribute in the stream and returns it as a java.sql.Date object. |
Time |
SQLInput.readTime()
Reads the next attribute in the stream and returns it as a java.sql.Time object. |
Timestamp |
SQLInput.readTimestamp()
Reads the next attribute in the stream and returns it as a java.sql.Timestamp object. |
Reader |
SQLInput.readCharacterStream()
Reads the next attribute in the stream and returns it as a stream of Unicode characters. |
InputStream |
SQLInput.readAsciiStream()
Reads the next attribute in the stream and returns it as a stream of ASCII characters. |
InputStream |
SQLInput.readBinaryStream()
Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes. |
Object |
SQLInput.readObject()
Reads the datum at the head of the stream and returns it as an Object in the Java programming language. |
Ref |
SQLInput.readRef()
Reads an SQL REF value from the stream and returns it as a
Ref object in the Java programming language. |
Blob |
SQLInput.readBlob()
Reads an SQL BLOB value from the stream and returns it as a
Blob object in the Java programming language. |
Clob |
SQLInput.readClob()
Reads an SQL CLOB value from the stream and returns it as a
Clob object in the Java programming language. |
Array |
SQLInput.readArray()
Reads an SQL ARRAY value from the stream and returns it as an
Array object in the Java programming language. |
boolean |
SQLInput.wasNull()
Retrieves whether the last value read was SQL NULL. |
URL |
SQLInput.readURL()
Reads an SQL DATALINK value from the stream and returns it as a
java.net.URL object in the Java programming language. |
String |
SQLData.getSQLTypeName()
Returns the fully-qualified name of the SQL user-defined type that this object represents. |
void |
SQLData.readSQL(SQLInput stream,
String typeName)
Populates this object with data read from the database. |
void |
SQLData.writeSQL(SQLOutput stream)
Writes this object to the given SQL data stream, converting it back to its SQL value in the data source. |
int |
Savepoint.getSavepointId()
Retrieves the generated ID for the savepoint that this Savepoint object represents. |
String |
Savepoint.getSavepointName()
Retrieves the name of the savepoint that this Savepoint
object represents. |
boolean |
DatabaseMetaData.allProceduresAreCallable()
Retrieves whether the current user can call all the procedures returned by the method getProcedures. |
boolean |
DatabaseMetaData.allTablesAreSelectable()
Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT
statement. |
String |
DatabaseMetaData.getURL()
Retrieves the URL for this DBMS. |
String |
DatabaseMetaData.getUserName()
Retrieves the user name as known to this database. |
boolean |
DatabaseMetaData.isReadOnly()
Retrieves whether this database is in read-only mode. |
boolean |
DatabaseMetaData.nullsAreSortedHigh()
Retrieves whether NULL values are sorted high. |
boolean |
DatabaseMetaData.nullsAreSortedLow()
Retrieves whether NULL values are sorted low. |
boolean |
DatabaseMetaData.nullsAreSortedAtStart()
Retrieves whether NULL values are sorted at the start regardless
of sort order. |
boolean |
DatabaseMetaData.nullsAreSortedAtEnd()
Retrieves whether NULL values are sorted at the end regardless of
sort order. |
String |
DatabaseMetaData.getDatabaseProductName()
Retrieves the name of this database product. |
String |
DatabaseMetaData.getDatabaseProductVersion()
Retrieves the version number of this database product. |
String |
DatabaseMetaData.getDriverName()
Retrieves the name of this JDBC driver. |
String |
DatabaseMetaData.getDriverVersion()
Retrieves the version number of this JDBC driver as a String. |
boolean |
DatabaseMetaData.usesLocalFiles()
Retrieves whether this database stores tables in a local file. |
boolean |
DatabaseMetaData.usesLocalFilePerTable()
Retrieves whether this database uses a file for each table. |
boolean |
DatabaseMetaData.supportsMixedCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
boolean |
DatabaseMetaData.storesUpperCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case. |
boolean |
DatabaseMetaData.storesLowerCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case. |
boolean |
DatabaseMetaData.storesMixedCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case. |
boolean |
DatabaseMetaData.supportsMixedCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case. |
boolean |
DatabaseMetaData.storesUpperCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case. |
boolean |
DatabaseMetaData.storesLowerCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case. |
boolean |
DatabaseMetaData.storesMixedCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case. |
String |
DatabaseMetaData.getIdentifierQuoteString()
Retrieves the string used to quote SQL identifiers. |
String |
DatabaseMetaData.getSQLKeywords()
Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL92 keywords. |
String |
DatabaseMetaData.getNumericFunctions()
Retrieves a comma-separated list of math functions available with this database. |
String |
DatabaseMetaData.getStringFunctions()
Retrieves a comma-separated list of string functions available with this database. |
String |
DatabaseMetaData.getSystemFunctions()
Retrieves a comma-separated list of system functions available with this database. |
String |
DatabaseMetaData.getTimeDateFunctions()
Retrieves a comma-separated list of the time and date functions available with this database. |
String |
DatabaseMetaData.getSearchStringEscape()
Retrieves the string that can be used to escape wildcard characters. |
String |
DatabaseMetaData.getExtraNameCharacters()
Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _). |
boolean |
DatabaseMetaData.supportsAlterTableWithAddColumn()
Retrieves whether this database supports ALTER TABLE
with add column. |
boolean |
DatabaseMetaData.supportsAlterTableWithDropColumn()
Retrieves whether this database supports ALTER TABLE
with drop column. |
boolean |
DatabaseMetaData.supportsColumnAliasing()
Retrieves whether this database supports column aliasing. |
boolean |
DatabaseMetaData.nullPlusNonNullIsNull()
Retrieves whether this database supports concatenations between NULL and non-NULL values being
NULL. |
boolean |
DatabaseMetaData.supportsConvert()
Retrieves whether this database supports the CONVERT
function between SQL types. |
boolean |
DatabaseMetaData.supportsConvert(int fromType,
int toType)
Retrieves whether this database supports the CONVERT
for two given SQL types. |
boolean |
DatabaseMetaData.supportsTableCorrelationNames()
Retrieves whether this database supports table correlation names. |
boolean |
DatabaseMetaData.supportsDifferentTableCorrelationNames()
Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables. |
boolean |
DatabaseMetaData.supportsExpressionsInOrderBy()
Retrieves whether this database supports expressions in ORDER BY lists. |
boolean |
DatabaseMetaData.supportsOrderByUnrelated()
Retrieves whether this database supports using a column that is not in the SELECT statement in an
ORDER BY clause. |
boolean |
DatabaseMetaData.supportsGroupBy()
Retrieves whether this database supports some form of GROUP BY clause. |
boolean |
DatabaseMetaData.supportsGroupByUnrelated()
Retrieves whether this database supports using a column that is not in the SELECT statement in a
GROUP BY clause. |
boolean |
DatabaseMetaData.supportsGroupByBeyondSelect()
Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause
provided that all of the columns in the SELECT statement
are included in the GROUP BY clause. |
boolean |
DatabaseMetaData.supportsLikeEscapeClause()
Retrieves whether this database supports specifying a LIKE escape clause. |
boolean |
DatabaseMetaData.supportsMultipleResultSets()
Retrieves whether this database supports getting multiple ResultSet objects from a single call to the
method execute. |
boolean |
DatabaseMetaData.supportsMultipleTransactions()
Retrieves whether this database allows having multiple transactions open at once (on different connections). |
boolean |
DatabaseMetaData.supportsNonNullableColumns()
Retrieves whether columns in this database may be defined as non-nullable. |
boolean |
DatabaseMetaData.supportsMinimumSQLGrammar()
Retrieves whether this database supports the ODBC Minimum SQL grammar. |
boolean |
DatabaseMetaData.supportsCoreSQLGrammar()
Retrieves whether this database supports the ODBC Core SQL grammar. |
boolean |
DatabaseMetaData.supportsExtendedSQLGrammar()
Retrieves whether this database supports the ODBC Extended SQL grammar. |
boolean |
DatabaseMetaData.supportsANSI92EntryLevelSQL()
Retrieves whether this database supports the ANSI92 entry level SQL grammar. |
boolean |
DatabaseMetaData.supportsANSI92IntermediateSQL()
Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. |
boolean |
DatabaseMetaData.supportsANSI92FullSQL()
Retrieves whether this database supports the ANSI92 full SQL grammar supported. |
boolean |
DatabaseMetaData.supportsIntegrityEnhancementFacility()
Retrieves whether this database supports the SQL Integrity Enhancement Facility. |
boolean |
DatabaseMetaData.supportsOuterJoins()
Retrieves whether this database supports some form of outer join. |
boolean |
DatabaseMetaData.supportsFullOuterJoins()
Retrieves whether this database supports full nested outer joins. |
boolean |
DatabaseMetaData.supportsLimitedOuterJoins()
Retrieves whether this database provides limited support for outer joins. |
String |
DatabaseMetaData.getSchemaTerm()
Retrieves the database vendor's preferred term for "schema". |
String |
DatabaseMetaData.getProcedureTerm()
Retrieves the database vendor's preferred term for "procedure". |
String |
DatabaseMetaData.getCatalogTerm()
Retrieves the database vendor's preferred term for "catalog". |
boolean |
DatabaseMetaData.isCatalogAtStart()
Retrieves whether a catalog appears at the start of a fully qualified table name. |
String |
DatabaseMetaData.getCatalogSeparator()
Retrieves the String that this database uses as the
separator between a catalog and table name. |
boolean |
DatabaseMetaData.supportsSchemasInDataManipulation()
Retrieves whether a schema name can be used in a data manipulation statement. |
boolean |
DatabaseMetaData.supportsSchemasInProcedureCalls()
Retrieves whether a schema name can be used in a procedure call statement. |
boolean |
DatabaseMetaData.supportsSchemasInTableDefinitions()
Retrieves whether a schema name can be used in a table definition statement. |
boolean |
DatabaseMetaData.supportsSchemasInIndexDefinitions()
Retrieves whether a schema name can be used in an index definition statement. |
boolean |
DatabaseMetaData.supportsSchemasInPrivilegeDefinitions()
Retrieves whether a schema name can be used in a privilege definition statement. |
boolean |
DatabaseMetaData.supportsCatalogsInDataManipulation()
Retrieves whether a catalog name can be used in a data manipulation statement. |
boolean |
DatabaseMetaData.supportsCatalogsInProcedureCalls()
Retrieves whether a catalog name can be used in a procedure call statement. |
boolean |
DatabaseMetaData.supportsCatalogsInTableDefinitions()
Retrieves whether a catalog name can be used in a table definition statement. |
boolean |
DatabaseMetaData.supportsCatalogsInIndexDefinitions()
Retrieves whether a catalog name can be used in an index definition statement. |
boolean |
DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions()
Retrieves whether a catalog name can be used in a privilege definition statement. |
boolean |
DatabaseMetaData.supportsPositionedDelete()
Retrieves whether this database supports positioned DELETE
statements. |
boolean |
DatabaseMetaData.supportsPositionedUpdate()
Retrieves whether this database supports positioned UPDATE
statements. |
boolean |
DatabaseMetaData.supportsSelectForUpdate()
Retrieves whether this database supports SELECT FOR UPDATE
statements. |
boolean |
DatabaseMetaData.supportsStoredProcedures()
Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax. |
boolean |
DatabaseMetaData.supportsSubqueriesInComparisons()
Retrieves whether this database supports subqueries in comparison expressions. |
boolean |
DatabaseMetaData.supportsSubqueriesInExists()
Retrieves whether this database supports subqueries in EXISTS expressions. |
boolean |
DatabaseMetaData.supportsSubqueriesInIns()
Retrieves whether this database supports subqueries in IN statements. |
boolean |
DatabaseMetaData.supportsSubqueriesInQuantifieds()
Retrieves whether this database supports subqueries in quantified expressions. |
boolean |
DatabaseMetaData.supportsCorrelatedSubqueries()
Retrieves whether this database supports correlated subqueries. |
boolean |
DatabaseMetaData.supportsUnion()
Retrieves whether this database supports SQL UNION. |
boolean |
DatabaseMetaData.supportsUnionAll()
Retrieves whether this database supports SQL UNION ALL. |
boolean |
DatabaseMetaData.supportsOpenCursorsAcrossCommit()
Retrieves whether this database supports keeping cursors open across commits. |
boolean |
DatabaseMetaData.supportsOpenCursorsAcrossRollback()
Retrieves whether this database supports keeping cursors open across rollbacks. |
boolean |
DatabaseMetaData.supportsOpenStatementsAcrossCommit()
Retrieves whether this database supports keeping statements open across commits. |
boolean |
DatabaseMetaData.supportsOpenStatementsAcrossRollback()
Retrieves whether this database supports keeping statements open across rollbacks. |
int |
DatabaseMetaData.getMaxBinaryLiteralLength()
Retrieves the maximum number of hex characters this database allows in an inline binary literal. |
int |
DatabaseMetaData.getMaxCharLiteralLength()
Retrieves the maximum number of characters this database allows for a character literal. |
int |
DatabaseMetaData.getMaxColumnNameLength()
Retrieves the maximum number of characters this database allows for a column name. |
int |
DatabaseMetaData.getMaxColumnsInGroupBy()
Retrieves the maximum number of columns this database allows in a GROUP BY clause. |
int |
DatabaseMetaData.getMaxColumnsInIndex()
Retrieves the maximum number of columns this database allows in an index. |
int |
DatabaseMetaData.getMaxColumnsInOrderBy()
Retrieves the maximum number of columns this database allows in an ORDER BY clause. |
int |
DatabaseMetaData.getMaxColumnsInSelect()
Retrieves the maximum number of columns this database allows in a SELECT list. |
int |
DatabaseMetaData.getMaxColumnsInTable()
Retrieves the maximum number of columns this database allows in a table. |
int |
DatabaseMetaData.getMaxConnections()
Retrieves the maximum number of concurrent connections to this database that are possible. |
int |
DatabaseMetaData.getMaxCursorNameLength()
Retrieves the maximum number of characters that this database allows in a cursor name. |
int |
DatabaseMetaData.getMaxIndexLength()
Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index. |
int |
DatabaseMetaData.getMaxSchemaNameLength()
Retrieves the maximum number of characters that this database allows in a schema name. |
int |
DatabaseMetaData.getMaxProcedureNameLength()
Retrieves the maximum number of characters that this database allows in a procedure name. |
int |
DatabaseMetaData.getMaxCatalogNameLength()
Retrieves the maximum number of characters that this database allows in a catalog name. |
int |
DatabaseMetaData.getMaxRowSize()
Retrieves the maximum number of bytes this database allows in a single row. |
boolean |
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
Retrieves whether the return value for the method getMaxRowSize includes the SQL data types
LONGVARCHAR and LONGVARBINARY. |
int |
DatabaseMetaData.getMaxStatementLength()
Retrieves the maximum number of characters this database allows in an SQL statement. |
int |
DatabaseMetaData.getMaxStatements()
Retrieves the maximum number of active statements to this database that can be open at the same time. |
int |
DatabaseMetaData.getMaxTableNameLength()
Retrieves the maximum number of characters this database allows in a table name. |
int |
DatabaseMetaData.getMaxTablesInSelect()
Retrieves the maximum number of tables this database allows in a SELECT statement. |
int |
DatabaseMetaData.getMaxUserNameLength()
Retrieves the maximum number of characters this database allows in a user name. |
int |
DatabaseMetaData.getDefaultTransactionIsolation()
Retrieves this database's default transaction isolation level. |
boolean |
DatabaseMetaData.supportsTransactions()
Retrieves whether this database supports transactions. |
boolean |
DatabaseMetaData.supportsTransactionIsolationLevel(int level)
Retrieves whether this database supports the given transaction isolation level. |
boolean |
DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()
Retrieves whether this database supports both data definition and data manipulation statements within a transaction. |
boolean |
DatabaseMetaData.supportsDataManipulationTransactionsOnly()
Retrieves whether this database supports only data manipulation statements within a transaction. |
boolean |
DatabaseMetaData.dataDefinitionCausesTransactionCommit()
Retrieves whether a data definition statement within a transaction forces the transaction to commit. |
boolean |
DatabaseMetaData.dataDefinitionIgnoredInTransactions()
Retrieves whether this database ignores a data definition statement within a transaction. |
ResultSet |
DatabaseMetaData.getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
Retrieves a description of the stored procedures available in the given catalog. |
ResultSet |
DatabaseMetaData.getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's stored procedure parameter and result columns. |
ResultSet |
DatabaseMetaData.getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
Retrieves a description of the tables available in the given catalog. |
ResultSet |
DatabaseMetaData.getSchemas()
Retrieves the schema names available in this database. |
ResultSet |
DatabaseMetaData.getCatalogs()
Retrieves the catalog names available in this database. |
ResultSet |
DatabaseMetaData.getTableTypes()
Retrieves the table types available in this database. |
ResultSet |
DatabaseMetaData.getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
Retrieves a description of table columns available in the specified catalog. |
ResultSet |
DatabaseMetaData.getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern)
Retrieves a description of the access rights for a table's columns. |
ResultSet |
DatabaseMetaData.getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the access rights for each table available in a catalog. |
ResultSet |
DatabaseMetaData.getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Retrieves a description of a table's optimal set of columns that uniquely identifies a row. |
ResultSet |
DatabaseMetaData.getVersionColumns(String catalog,
String schema,
String table)
Retrieves a description of a table's columns that are automatically updated when any value in a row is updated. |
ResultSet |
DatabaseMetaData.getPrimaryKeys(String catalog,
String schema,
String table)
Retrieves a description of the given table's primary key columns. |
ResultSet |
DatabaseMetaData.getImportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). |
ResultSet |
DatabaseMetaData.getExportedKeys(String catalog,
String schema,
String table)
Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table). |
ResultSet |
DatabaseMetaData.getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key columns of the given primary key table (describe how one table imports another's key). |
ResultSet |
DatabaseMetaData.getTypeInfo()
Retrieves a description of all the standard SQL types supported by this database. |
ResultSet |
DatabaseMetaData.getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate)
Retrieves a description of the given table's indices and statistics. |
boolean |
DatabaseMetaData.supportsResultSetType(int type)
Retrieves whether this database supports the given result set type. |
boolean |
DatabaseMetaData.supportsResultSetConcurrency(int type,
int concurrency)
Retrieves whether this database supports the given concurrency type in combination with the given result set type. |
boolean |
DatabaseMetaData.ownUpdatesAreVisible(int type)
Retrieves whether for the given type of ResultSet object,
the result set's own updates are visible. |
boolean |
DatabaseMetaData.ownDeletesAreVisible(int type)
Retrieves whether a result set's own deletes are visible. |
boolean |
DatabaseMetaData.ownInsertsAreVisible(int type)
Retrieves whether a result set's own inserts are visible. |
boolean |
DatabaseMetaData.othersUpdatesAreVisible(int type)
Retrieves whether updates made by others are visible. |
boolean |
DatabaseMetaData.othersDeletesAreVisible(int type)
Retrieves whether deletes made by others are visible. |
boolean |
DatabaseMetaData.othersInsertsAreVisible(int type)
Retrieves whether inserts made by others are visible. |
boolean |
DatabaseMetaData.updatesAreDetected(int type)
Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated. |
boolean |
DatabaseMetaData.deletesAreDetected(int type)
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted. |
boolean |
DatabaseMetaData.insertsAreDetected(int type)
Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted. |
boolean |
DatabaseMetaData.supportsBatchUpdates()
Retrieves whether this database supports batch updates. |
ResultSet |
DatabaseMetaData.getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Retrieves a description of the user-defined types (UDTs) defined in a particular schema. |
Connection |
DatabaseMetaData.getConnection()
Retrieves the connection that produced this metadata object. |
boolean |
DatabaseMetaData.supportsSavepoints()
Retrieves whether this database supports savepoints. |
boolean |
DatabaseMetaData.supportsNamedParameters()
Retrieves whether this database supports named parameters to callable statements. |
boolean |
DatabaseMetaData.supportsMultipleOpenResults()
Retrieves whether it is possible to have multiple ResultSet objects
returned from a CallableStatement object
simultaneously. |
boolean |
DatabaseMetaData.supportsGetGeneratedKeys()
Retrieves whether auto-generated keys can be retrieved after a statement has been executed. |
ResultSet |
DatabaseMetaData.getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database. |
ResultSet |
DatabaseMetaData.getSuperTables(String catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular schema in this database. |
ResultSet |
DatabaseMetaData.getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog. |
boolean |
DatabaseMetaData.supportsResultSetHoldability(int holdability)
Retrieves whether this database supports the given result set holdability. |
int |
DatabaseMetaData.getResultSetHoldability()
Retrieves the default holdability of this ResultSet
object. |
int |
DatabaseMetaData.getDatabaseMajorVersion()
Retrieves the major version number of the underlying database. |
int |
DatabaseMetaData.getDatabaseMinorVersion()
Retrieves the minor version number of the underlying database. |
int |
DatabaseMetaData.getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver. |
int |
DatabaseMetaData.getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver. |
int |
DatabaseMetaData.getSQLStateType()
Indicates whether the SQLSTATE returned by SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99. |
boolean |
DatabaseMetaData.locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB. |
boolean |
DatabaseMetaData.supportsStatementPooling()
Retrieves whether this database supports statement pooling. |
void |
CallableStatement.registerOutParameter(int parameterIndex,
int sqlType)
Registers the OUT parameter in ordinal position parameterIndex to the JDBC type
sqlType. |
void |
CallableStatement.registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the parameter in ordinal position parameterIndex to be of JDBC type
sqlType. |
boolean |
CallableStatement.wasNull()
Retrieves whether the last OUT parameter read had the value of SQL NULL. |
String |
CallableStatement.getString(int parameterIndex)
Retrieves the value of the designated JDBC CHAR,
VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language. |
boolean |
CallableStatement.getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC BIT parameter as a
boolean in the Java programming language. |
byte |
CallableStatement.getByte(int parameterIndex)
Retrieves the value of the designated JDBC TINYINT parameter
as a byte in the Java programming language. |
short |
CallableStatement.getShort(int parameterIndex)
Retrieves the value of the designated JDBC SMALLINT parameter
as a short in the Java programming language. |
int |
CallableStatement.getInt(int parameterIndex)
Retrieves the value of the designated JDBC INTEGER parameter
as an int in the Java programming language. |
long |
CallableStatement.getLong(int parameterIndex)
Retrieves the value of the designated JDBC BIGINT parameter
as a long in the Java programming language. |
float |
CallableStatement.getFloat(int parameterIndex)
&n |