|
JavaTM 2 Platform Std. Ed. v1.4.0 |
||||||||||
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 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 SQLSTATEs 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 weather 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)
Retrieves the value of the designated JDBC FLOAT parameter
as a float in the Java programming language. |
double |
CallableStatement.getDouble(int parameterIndex)
Retrieves the value of the designated JDBC DOUBLE parameter as a double
in the Java programming language. |
BigDecimal |
CallableStatement.getBigDecimal(int parameterIndex,
int scale)
Deprecated. use getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName) |
byte[] |
CallableStatement.getBytes(int parameterIndex)
Retrieves the value of the designated JDBC BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language. |
Date |
CallableStatement.getDate(int parameterIndex)
Retrieves the value of the designated JDBC DATE parameter as a
java.sql.Date object. |
Time |
CallableStatement.getTime(int parameterIndex)
Retrieves the value of the designated JDBC TIME parameter as a
java.sql.Time object. |
Timestamp |
CallableStatement.getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a
java.sql.Timestamp object. |
Object |
CallableStatement.getObject(int parameterIndex)
Retrieves the value of the designated parameter as an Object
in the Java programming language. |
BigDecimal |
CallableStatement.getBigDecimal(int parameterIndex)
Retrieves the value of the designated JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
Object |
CallableStatement.getObject(int i,
Map map)
Returns an object representing the value of OUT parameter i and uses map for the custom
mapping of the parameter value. |
Ref |
CallableStatement.getRef(int i)
Retrieves the value of the designated JDBC REF(<structured-type>)
parameter as a Ref object in the Java programming language. |
Blob |
CallableStatement.getBlob(int i)
Retrieves the value of the designated JDBC BLOB parameter as a
Blob object in the Java programming language. |
Clob |
CallableStatement.getClob(int i)
Retrieves the value of the designated JDBC CLOB parameter as a
Clob object in the Java programming language. |
Array |
CallableStatement.getArray(int i)
Retrieves the value of the designated JDBC ARRAY parameter as an
Array object in the Java programming language. |
Date |
CallableStatement.getDate(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
Time |
CallableStatement.getTime(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
Timestamp |
CallableStatement.getTimestamp(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
void |
CallableStatement.registerOutParameter(int paramIndex,
int sqlType,
String typeName)
Registers the designated output parameter. |
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType)
Registers the OUT parameter named parameterName to the JDBC type
sqlType . |
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the parameter named parameterName to be of JDBC type
sqlType . |
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the designated output parameter. |
URL |
CallableStatement.getURL(int parameterIndex)
Retrieves the value of the designated JDBC DATALINK parameter as a
java.net.URL object. |
void |
CallableStatement.setURL(String parameterName,
URL val)
Sets the designated parameter to the given java.net.URL object. |
void |
CallableStatement.setNull(String parameterName,
int sqlType)
Sets the designated parameter to SQL NULL . |
void |
CallableStatement.setBoolean(String parameterName,
boolean x)
Sets the designated parameter to the given Java boolean value. |
void |
CallableStatement.setByte(String parameterName,
byte x)
Sets the designated parameter to the given Java byte value. |
void |
CallableStatement.setShort(String parameterName,
short x)
Sets the designated parameter to the given Java short value. |
void |
CallableStatement.setInt(String parameterName,
int x)
Sets the designated parameter to the given Java int value. |
void |
CallableStatement.setLong(String parameterName,
long x)
Sets the designated parameter to the given Java long value. |
void |
CallableStatement.setFloat(String parameterName,
float x)
Sets the designated parameter to the given Java float value. |
void |
CallableStatement.setDouble(String parameterName,
double x)
Sets the designated parameter to the given Java double value. |
void |
CallableStatement.setBigDecimal(String parameterName,
BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
void |
CallableStatement.setString(String parameterName,
String x)
Sets the designated parameter to the given Java String value. |
void |
CallableStatement.setBytes(String parameterName,
byte[] x)
Sets the designated parameter to the given Java array of bytes. |
void |
CallableStatement.setDate(String parameterName,
Date x)
Sets the designated parameter to the given java.sql.Date value. |
void |
CallableStatement.setTime(String parameterName,
Time x)
Sets the designated parameter to the given java.sql.Time value. |
void |
CallableStatement.setTimestamp(String parameterName,
Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
CallableStatement.setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
CallableStatement.setBinaryStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
CallableStatement.setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object. |
void |
CallableStatement.setObject(String parameterName,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object. |
void |
CallableStatement.setObject(String parameterName,
Object x)
Sets the value of the designated parameter with the given object. |
void |
CallableStatement.setCharacterStream(String parameterName,
Reader reader,
int length)
Sets the designated parameter to the given Reader
object, which is the given number of characters long. |
void |
CallableStatement.setDate(String parameterName,
Date x,
Calendar cal)
Sets the designated parameter to the given java.sql.Date value,
using the given Calendar object. |
void |
CallableStatement.setTime(String parameterName,
Time x,
Calendar cal)
Sets the designated parameter to the given java.sql.Time value,
using the given Calendar object. |
void |
CallableStatement.setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value,
using the given Calendar object. |
void |
CallableStatement.setNull(String parameterName,
int sqlType,
String typeName)
Sets the designated parameter to SQL NULL . |
String |
CallableStatement.getString(String parameterName)
Retrieves the value of a JDBC CHAR , VARCHAR ,
or LONGVARCHAR parameter as a String in
the Java programming language. |
boolean |
CallableStatement.getBoolean(String parameterName)
Retrieves the value of a JDBC BIT parameter as a
boolean in the Java programming language. |
byte |
CallableStatement.getByte(String parameterName)
Retrieves the value of a JDBC TINYINT parameter as a byte
in the Java programming language. |
short |
CallableStatement.getShort(String parameterName)
Retrieves the value of a JDBC SMALLINT parameter as a short
in the Java programming language. |
int |
CallableStatement.getInt(String parameterName)
Retrieves the value of a JDBC INTEGER parameter as an int
in the Java programming language. |
long |
CallableStatement.getLong(String parameterName)
Retrieves the value of a JDBC BIGINT parameter as a long
in the Java programming language. |
float |
CallableStatement.getFloat(String parameterName)
Retrieves the value of a JDBC FLOAT parameter as a float
in the Java programming language. |
double |
CallableStatement.getDouble(String parameterName)
Retrieves the value of a JDBC DOUBLE parameter as a double
in the Java programming language. |
byte[] |
CallableStatement.getBytes(String parameterName)
Retrieves the value of a JDBC BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language. |
Date |
CallableStatement.getDate(String parameterName)
Retrieves the value of a JDBC DATE parameter as a
java.sql.Date object. |
Time |
CallableStatement.getTime(String parameterName)
Retrieves the value of a JDBC TIME parameter as a
java.sql.Time object. |
Timestamp |
CallableStatement.getTimestamp(String parameterName)
Retrieves the value of a JDBC TIMESTAMP parameter as a
java.sql.Timestamp object. |
Object |
CallableStatement.getObject(String parameterName)
Retrieves the value of a parameter as an Object in the Java
programming language. |
BigDecimal |
CallableStatement.getBigDecimal(String parameterName)
Retrieves the value of a JDBC NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
Object |
CallableStatement.getObject(String parameterName,
Map map)
Returns an object representing the value of OUT parameter i and uses map for the custom
mapping of the parameter value. |
Ref |
CallableStatement.getRef(String parameterName)
Retrieves the value of a JDBC REF(<structured-type>)
parameter as a Ref object in the Java programming language. |
Blob |
CallableStatement.getBlob(String parameterName)
Retrieves the value of a JDBC BLOB parameter as a
Blob object in the Java programming language. |
Clob |
CallableStatement.getClob(String parameterName)
Retrieves the value of a JDBC CLOB parameter as a
Clob object in the Java programming language. |
Array |
CallableStatement.getArray(String parameterName)
Retrieves the value of a JDBC ARRAY parameter as an
Array object in the Java programming language. |
Date |
CallableStatement.getDate(String parameterName,
Calendar cal)
Retrieves the value of a JDBC DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
Time |
CallableStatement.getTime(String parameterName,
Calendar cal)
Retrieves the value of a JDBC TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
Timestamp |
CallableStatement.getTimestamp(String parameterName,
Calendar cal)
Retrieves the value of a JDBC TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
URL |
CallableStatement.getURL(String parameterName)
Retrieves the value of a JDBC DATALINK parameter as a
java.net.URL object. |
int |
ParameterMetaData.getParameterCount()
Retrieves the number of parameters in the PreparedStatement
object for which this ParameterMetaData object contains
information. |
int |
ParameterMetaData.isNullable(int param)
Retrieves whether null values are allowed in the designated parameter. |
boolean |
ParameterMetaData.isSigned(int param)
Retrieves whether values for the designated parameter can be signed numbers. |
int |
ParameterMetaData.getPrecision(int param)
Retrieves the designated parameter's number of decimal digits. |
int |
ParameterMetaData.getScale(int param)
Retrieves the designated parameter's number of digits to right of the decimal point. |
int |
ParameterMetaData.getParameterType(int param)
Retrieves the designated parameter's SQL type. |
String |
ParameterMetaData.getParameterTypeName(int param)
Retrieves the designated parameter's database-specific type name. |
String |
ParameterMetaData.getParameterClassName(int param)
Retrieves the fully-qualified name of the Java class whose instances should be passed to the method PreparedStatement.setObject . |
int |
ParameterMetaData.getParameterMode(int param)
Retrieves the designated parameter's mode. |
long |
Clob.length()
Retrieves the number of characters in the CLOB value
designated by this Clob object. |
String |
Clob.getSubString(long pos,
int length)
Retrieves a copy of the specified substring in the CLOB value
designated by this Clob object. |
Reader |
Clob.getCharacterStream()
Retrieves the CLOB value designated by this Clob
object as a java.io.Reader object (or as a stream of
characters). |
InputStream |
Clob.getAsciiStream()
Retrieves the CLOB value designated by this Clob
object as an ascii stream. |
long |
Clob.position(String searchstr,
long start)
Retrieves the character position at which the specified substring searchstr appears in the SQL CLOB value
represented by this Clob object. |
long |
Clob.position(Clob searchstr,
long start)
Retrieves the character position at which the specified Clob object searchstr appears in this
Clob object. |
int |
Clob.setString(long pos,
String str)
Writes the given Java String to the CLOB
value that this Clob object designates at the position
pos . |
int |
Clob.setString(long pos,
String str,
int offset,
int len)
Writes len characters of str , starting
at character offset , to the CLOB value
that this Clob represents. |
OutputStream |
Clob.setAsciiStream(long pos)
Retrieves a stream to be used to write Ascii characters to the CLOB value that this Clob object represents,
starting at position pos . |
Writer |
Clob.setCharacterStream(long pos)
Retrieves a stream to be used to write a stream of Unicode characters to the CLOB value that this Clob object
represents, at position pos . |
void |
Clob.truncate(long len)
Truncates the CLOB value that this Clob
designates to have a length of len
characters. |
long |
Blob.length()
Returns the number of bytes in the BLOB value
designated by this Blob object. |
byte[] |
Blob.getBytes(long pos,
int length)
Retrieves all or part of the BLOB
value that this Blob object represents, as an array of
bytes. |
InputStream |
Blob.getBinaryStream()
Retrieves the BLOB value designated by this
Blob instance as a stream. |
long |
Blob.position(byte[] pattern,
long start)
Retrieves the byte position at which the specified byte array pattern begins within the BLOB
value that this Blob object represents. |
long |
Blob.position(Blob pattern,
long start)
Retrieves the byte position in the BLOB value
designated by this Blob object at which
pattern begins. |
int |
Blob.setBytes(long pos,
byte[] bytes)
Writes the given array of bytes to the BLOB value that
this Blob object represents, starting at position
pos , and returns the number of bytes written. |
int |
Blob.setBytes(long pos,
byte[] bytes,
int offset,
int len)
Writes all or part of the given byte array to the
BLOB value that this Blob object represents
and returns the number of bytes written. |
OutputStream |
Blob.setBinaryStream(long pos)
Retrieves a stream that can be used to write to the BLOB
value that this Blob object represents. |
void |
Blob.truncate(long len)
Truncates the BLOB value that this Blob
object represents to be len bytes in length. |
String |
Ref.getBaseTypeName()
Retrieves the fully-qualified SQL name of the SQL structured type that this Ref object references. |
Object |
Ref.getObject(Map map)
Retrieves the referenced object and maps it to a Java type using the given type map. |
Object |
Ref.getObject()
Retrieves the SQL structured type instance referenced by this Ref object. |
void |
Ref.setObject(Object value)
Sets the structured type value that this Ref
object references to the given instance of Object . |
ResultSet |
PreparedStatement.executeQuery()
Executes the SQL query in this PreparedStatement object
and returns the ResultSet object generated by the query. |
int |
PreparedStatement.executeUpdate()
Executes the SQL statement in this PreparedStatement object,
which must be an SQL INSERT , UPDATE or
DELETE statement; or an SQL statement that returns nothing,
such as a DDL statement. |
void |
PreparedStatement.setNull(int parameterIndex,
int sqlType)
Sets the designated parameter to SQL NULL . |
void |
PreparedStatement.setBoolean(int parameterIndex,
boolean x)
Sets the designated parameter to the given Java boolean value. |
void |
PreparedStatement.setByte(int parameterIndex,
byte x)
Sets the designated parameter to the given Java byte value. |
void |
PreparedStatement.setShort(int parameterIndex,
short x)
Sets the designated parameter to the given Java short value. |
void |
PreparedStatement.setInt(int parameterIndex,
int x)
Sets the designated parameter to the given Java int value. |
void |
PreparedStatement.setLong(int parameterIndex,
long x)
Sets the designated parameter to the given Java long value. |
void |
PreparedStatement.setFloat(int parameterIndex,
float x)
Sets the designated parameter to the given Java float value. |
void |
PreparedStatement.setDouble(int parameterIndex,
double x)
Sets the designated parameter to the given Java double value. |
void |
PreparedStatement.setBigDecimal(int parameterIndex,
BigDecimal x)
Sets the designated parameter to the given java.math.BigDecimal value. |
void |
PreparedStatement.setString(int parameterIndex,
String x)
Sets the designated parameter to the given Java String value. |
void |
PreparedStatement.setBytes(int parameterIndex,
byte[] x)
Sets the designated parameter to the given Java array of bytes. |
void |
PreparedStatement.setDate(int parameterIndex,
Date x)
Sets the designated parameter to the given java.sql.Date value. |
void |
PreparedStatement.setTime(int parameterIndex,
Time x)
Sets the designated parameter to the given java.sql.Time value. |
void |
PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x)
Sets the designated parameter to the given java.sql.Timestamp value. |
void |
PreparedStatement.setAsciiStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
PreparedStatement.setUnicodeStream(int parameterIndex,
InputStream x,
int length)
Deprecated. |
void |
PreparedStatement.setBinaryStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
void |
PreparedStatement.clearParameters()
Clears the current parameter values immediately. |
void |
PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object. |
void |
PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object. |
void |
PreparedStatement.setObject(int parameterIndex,
Object x)
Sets the value of the designated parameter using the given object. |
boolean |
PreparedStatement.execute()
Executes the SQL statement in this PreparedStatement object,
which may be any kind of SQL statement. |
void |
PreparedStatement.addBatch()
Adds a set of parameters to this PreparedStatement
object's batch of commands. |
void |
PreparedStatement.setCharacterStream(int parameterIndex,
Reader reader,
int length)
Sets the designated parameter to the given Reader
object, which is the given number of characters long. |
void |
PreparedStatement.setRef(int i,
Ref x)
Sets the designated parameter to the given REF(<structured-type>) value. |
void |
PreparedStatement.setBlob(int i,
Blob x)
Sets the designated parameter to the given Blob object. |
void |
PreparedStatement.setClob(int i,
Clob x)
Sets the designated parameter to the given Clob object. |
void |
PreparedStatement.setArray(int i,
Array x)
Sets the designated parameter to the given Array object. |
ResultSetMetaData |
PreparedStatement.getMetaData()
Retrieves a ResultSetMetaData object that contains
information about the columns of the ResultSet object
that will be returned when this PreparedStatement object
is executed. |
void |
PreparedStatement.setDate(int parameterIndex,
Date x,
Calendar cal)
Sets the designated parameter to the given java.sql.Date value,
using the given Calendar object. |
void |
PreparedStatement.setTime(int parameterIndex,
Time x,
Calendar cal)
Sets the designated parameter to the given java.sql.Time value,
using the given Calendar object. |
void |
PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given java.sql.Timestamp value,
using the given Calendar object. |
void |
PreparedStatement.setNull(int paramIndex,
int sqlType,
String typeName)
Sets the designated parameter to SQL NULL . |
void |
PreparedStatement.setURL(int parameterIndex,
URL x)
Sets the designated parameter to the given java.net.URL value. |
ParameterMetaData |
PreparedStatement.getParameterMetaData()
Retrieves the number, types and properties of this PreparedStatement object's parameters. |
Statement |
Connection.createStatement()
Creates a Statement object for sending
SQL statements to the database. |
PreparedStatement |
Connection.prepareStatement(String sql)
Creates a PreparedStatement object for sending
parameterized SQL statements to the database. |
CallableStatement |
Connection.prepareCall(String sql)
Creates a CallableStatement object for calling
database stored procedures. |
String |
Connection.nativeSQL(String sql)
Converts the given SQL statement into the system's native SQL grammar. |
void |
Connection.setAutoCommit(boolean autoCommit)
Sets this connection's auto-commit mode to the given state. |
boolean |
Connection.getAutoCommit()
Retrieves the current auto-commit mode for this Connection
object. |
void |
Connection.commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. |
void |
Connection.rollback()
Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object. |
void |
Connection.close()
Releases this Connection object's database and JDBC resources
immediately instead of waiting for them to be automatically released. |
boolean |
Connection.isClosed()
Retrieves whether this Connection object has been
closed. |
DatabaseMetaData |
Connection.getMetaData()
Retrieves a DatabaseMetaData object that contains
metadata about the database to which this
Connection object represents a connection. |
void |
Connection.setReadOnly(boolean readOnly)
Puts this connection in read-only mode as a hint to the driver to enable database optimizations. |
boolean |
Connection.isReadOnly()
Retrieves whether this Connection
object is in read-only mode. |
void |
Connection.setCatalog(String catalog)
Sets the given catalog name in order to select a subspace of this Connection object's database
in which to work. |
String |
Connection.getCatalog()
Retrieves this Connection object's current catalog name. |
void |
Connection.setTransactionIsolation(int level)
Attempts to change the transaction isolation level for this Connection object to the one given. |
int |
Connection.getTransactionIsolation()
Retrieves this Connection object's current
transaction isolation level. |
SQLWarning |
Connection.getWarnings()
Retrieves the first warning reported by calls on this Connection object. |
void |
Connection.clearWarnings()
Clears all warnings reported for this Connection object. |
Statement |
Connection.createStatement(int resultSetType,
int resultSetConcurrency)
Creates a Statement object that will generate
ResultSet objects with the given type and concurrency. |
PreparedStatement |
Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
Creates a PreparedStatement object that will generate
ResultSet objects with the given type and concurrency. |
CallableStatement |
Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency)
Creates a CallableStatement object that will generate
ResultSet objects with the given type and concurrency. |
Map |
Connection.getTypeMap()
Retrieves the Map object associated with this
Connection object. |
void |
Connection.setTypeMap(Map map)
Installs the given TypeMap object as the type map for
this Connection object. |
void |
Connection.setHoldability(int holdability)
Changes the holdability of ResultSet objects
created using this Connection object to the given
holdability. |
int |
Connection.getHoldability()
Retrieves the current holdability of ResultSet objects
created using this Connection object. |
Savepoint |
Connection.setSavepoint()
Creates an unnamed savepoint in the current transaction and returns the new Savepoint object that represents it. |
Savepoint |
Connection.setSavepoint(String name)
Creates a savepoint with the given name in the current transaction and returns the new Savepoint object that represents it. |
void |
Connection.rollback(Savepoint savepoint)
Undoes all changes made after the given Savepoint object
was set. |
void |
Connection.releaseSavepoint(Savepoint savepoint)
Removes the given Savepoint object from the current
transaction. |
Statement |
Connection.createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a Statement object that will generate
ResultSet objects with the given type, concurrency,
and holdability. |
PreparedStatement |
Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a PreparedStatement object that will generate
ResultSet objects with the given type, concurrency,
and holdability. |
CallableStatement |
Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a CallableStatement object that will generate
ResultSet objects with the given type and concurrency. |
PreparedStatement |
Connection.prepareStatement(String sql,
int autoGeneratedKeys)
Creates a default PreparedStatement object that has
the capability to retrieve auto-generated keys. |
PreparedStatement |
Connection.prepareStatement(String sql,
int[] columnIndexes)
Creates a default PreparedStatement object capable
of returning the auto-generated keys designated by the given array. |
PreparedStatement |
Connection.prepareStatement(String sql,
String[] columnNames)
Creates a default PreparedStatement object capable
of returning the auto-generated keys designated by the given array. |
ResultSet |
Statement.executeQuery(String sql)
Executes the given SQL statement, which returns a single ResultSet object. |
int |
Statement.executeUpdate(String sql)
Executes the given SQL statement, which may be an INSERT ,
UPDATE , or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement. |
void |
Statement.close()
Releases this Statement object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
int |
Statement.getMaxFieldSize()
Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet
object produced by this Statement object. |
void |
Statement.setMaxFieldSize(int max)
Sets the limit for the maximum number of bytes in a ResultSet
column storing character or binary values to
the given number of bytes. |
int |
Statement.getMaxRows()
Retrieves the maximum number of rows that a ResultSet object produced by this
Statement object can contain. |
void |
Statement.setMaxRows(int max)
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. |
void |
Statement.setEscapeProcessing(boolean enable)
Sets escape processing on or off. |
int |
Statement.getQueryTimeout()
Retrieves the number of seconds the driver will wait for a Statement object to execute. |
void |
Statement.setQueryTimeout(int seconds)
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds. |
void |
Statement.cancel()
Cancels this Statement object if both the DBMS and
driver support aborting an SQL statement. |
SQLWarning |
Statement.getWarnings()
Retrieves the first warning reported by calls on this Statement object. |
void |
Statement.clearWarnings()
Clears all the warnings reported on this Statement
object. |
void |
Statement.setCursorName(String name)
Sets the SQL cursor name to the given String , which
will be used by subsequent Statement object
execute methods. |
boolean |
Statement.execute(String sql)
Executes the given SQL statement, which may return multiple results. |
ResultSet |
Statement.getResultSet()
Retrieves the current result as a ResultSet object. |
int |
Statement.getUpdateCount()
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1
is returned. |
boolean |
Statement.getMoreResults()
Moves to this Statement object's next result, returns
true if it is a ResultSet object, and
implicitly closes any current ResultSet
object(s) obtained with the method getResultSet . |
void |
Statement.setFetchDirection(int direction)
Gives the driver a hint as to the direction in which rows will be processed in ResultSet
objects created using this Statement object. |
int |
Statement.getFetchDirection()
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object. |
void |
Statement.setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. |
int |
Statement.getFetchSize()
Retrieves the number of result set rows that is the default fetch size for ResultSet objects
generated from this Statement object. |
int |
Statement.getResultSetConcurrency()
Retrieves the result set concurrency for ResultSet objects
generated by this Statement object. |
int |
Statement.getResultSetType()
Retrieves the result set type for ResultSet objects
generated by this Statement object. |
void |
Statement.addBatch(String sql)
Adds the given SQL command to the current list of commmands for this Statement object. |
void |
Statement.clearBatch()
Empties this Statement object's current list of
SQL commands. |
int[] |
Statement.executeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. |
Connection |
Statement.getConnection()
Retrieves the Connection object
that produced this Statement object. |
boolean |
Statement.getMoreResults(int current)
Moves to this Statement object's next result, deals with
any current ResultSet object(s) according to the instructions
specified by the given flag, and returns
true if the next result is a ResultSet object. |
ResultSet |
Statement.getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing this Statement object. |
int |
Statement.executeUpdate(String sql,
int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object
should be made available for retrieval. |
int |
Statement.executeUpdate(String sql,
int[] columnIndexes)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int |
Statement.executeUpdate(String sql,
String[] columnNames)
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
boolean |
Statement.execute(String sql,
int autoGeneratedKeys)
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. |
boolean |
Statement.execute(String sql,
int[] columnIndexes)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
boolean |
Statement.execute(String sql,
String[] columnNames)
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. |
int |
Statement.getResultSetHoldability()
Retrieves the result set holdability for ResultSet objects
generated by this Statement object. |
int |
ResultSetMetaData.getColumnCount()
Returns the number of columns in this ResultSet object. |
boolean |
ResultSetMetaData.isAutoIncrement(int column)
Indicates whether the designated column is automatically numbered, thus read-only. |
boolean |
ResultSetMetaData.isCaseSensitive(int column)
Indicates whether a column's case matters. |
boolean |
ResultSetMetaData.isSearchable(int column)
Indicates whether the designated column can be used in a where clause. |
boolean |
ResultSetMetaData.isCurrency(int column)
Indicates whether the designated column is a cash value. |
int |
ResultSetMetaData.isNullable(int column)
Indicates the nullability of values in the designated column. |
boolean |
ResultSetMetaData.isSigned(int column)
Indicates whether values in the designated column are signed numbers. |
int |
ResultSetMetaData.getColumnDisplaySize(int column)
Indicates the designated column's normal maximum width in characters. |
String |
ResultSetMetaData.getColumnLabel(int column)
Gets the designated column's suggested title for use in printouts and displays. |
String |
ResultSetMetaData.getColumnName(int column)
Get the designated column's name. |
String |
ResultSetMetaData.getSchemaName(int column)
Get the designated column's table's schema. |
int |
ResultSetMetaData.getPrecision(int column)
Get the designated column's number of decimal digits. |
int |
ResultSetMetaData.getScale(int column)
Gets the designated column's number of digits to right of the decimal point. |
String |
ResultSetMetaData.getTableName(int column)
Gets the designated column's table name. |
String |
ResultSetMetaData.getCatalogName(int column)
Gets the designated column's table's catalog name. |
int |
ResultSetMetaData.getColumnType(int column)
Retrieves the designated column's SQL type. |
String |
ResultSetMetaData.getColumnTypeName(int column)
Retrieves the designated column's database-specific type name. |
boolean |
ResultSetMetaData.isReadOnly(int column)
Indicates whether the designated column is definitely not writable. |
boolean |
ResultSetMetaData.isWritable(int column)
Indicates whether it is possible for a write on the designated column to succeed. |
boolean |
ResultSetMetaData.isDefinitelyWritable(int column)
Indicates whether a write on the designated column will definitely succeed. |
String |
ResultSetMetaData.getColumnClassName(int column)
Returns the fully-qualified name of the Java class whose instances are manufactured if the method ResultSet.getObject
is called to retrieve a value
from the column. |
boolean |
ResultSet.next()
Moves the cursor down one row from its current position. |
void |
ResultSet.close()
Releases this ResultSet object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
boolean |
ResultSet.wasNull()
Reports whether the last column read had a value of SQL NULL . |
String |
ResultSet.getString(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
boolean |
ResultSet.getBoolean(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
byte |
ResultSet.getByte(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
short |
ResultSet.getShort(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a short in the Java programming language. |
int |
ResultSet.getInt(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
long |
ResultSet.getLong(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
float |
ResultSet.getFloat(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
double |
ResultSet.getDouble(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex,
int scale)
Deprecated. |
byte[] |
ResultSet.getBytes(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
Date |
ResultSet.getDate(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
Time |
ResultSet.getTime(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Time object in the Java programming language. |
Timestamp |
ResultSet.getTimestamp(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Timestamp object in the Java programming language. |
InputStream |
ResultSet.getAsciiStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as
a stream of ASCII characters. |
InputStream |
ResultSet.getUnicodeStream(int columnIndex)
Deprecated. use getCharacterStream in place of
getUnicodeStream |
InputStream |
ResultSet.getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a binary stream of
uninterpreted bytes. |
String |
ResultSet.getString(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a String in the Java programming language. |
boolean |
ResultSet.getBoolean(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a boolean in the Java programming language. |
byte |
ResultSet.getByte(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte in the Java programming language. |
short |
ResultSet.getShort(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a short in the Java programming language. |
int |
ResultSet.getInt(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
an int in the Java programming language. |
long |
ResultSet.getLong(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a long in the Java programming language. |
float |
ResultSet.getFloat(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a float in the Java programming language. |
double |
ResultSet.getDouble(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a double in the Java programming language. |
BigDecimal |
ResultSet.getBigDecimal(String columnName,
int scale)
Deprecated. |
byte[] |
ResultSet.getBytes(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a byte array in the Java programming language. |
Date |
ResultSet.getDate(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Date object in the Java programming language. |
Time |
ResultSet.getTime(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Time object in the Java programming language. |
Timestamp |
ResultSet.getTimestamp(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as
a java.sql.Timestamp object. |
InputStream |
ResultSet.getAsciiStream(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of
ASCII characters. |
InputStream |
ResultSet.getUnicodeStream(String columnName)
Deprecated. use getCharacterStream instead |
InputStream |
ResultSet.getBinaryStream(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted
byte s. |
SQLWarning |
ResultSet.getWarnings()
Retrieves the first warning reported by calls on this ResultSet object. |
void |
ResultSet.clearWarnings()
Clears all warnings reported on this ResultSet object. |
String |
ResultSet.getCursorName()
Retrieves the name of the SQL cursor used by this ResultSet
object. |
ResultSetMetaData |
ResultSet.getMetaData()
Retrieves the number, types and properties of this ResultSet object's columns. |
Object |
ResultSet.getObject(int columnIndex)
Gets the value of the designated column in the current row of this ResultSet object as
an Object in the Java programming language. |
Object |
ResultSet.getObject(String columnName)
Gets the value of the designated column in the current row of this ResultSet object as
an Object in the Java programming language. |
int |
ResultSet.findColumn(String columnName)
Maps the given ResultSet column name to its
ResultSet column index. |
Reader |
ResultSet.getCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
Reader |
ResultSet.getCharacterStream(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.io.Reader object. |
BigDecimal |
ResultSet.getBigDecimal(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
BigDecimal |
ResultSet.getBigDecimal(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a
java.math.BigDecimal with full precision. |
boolean |
ResultSet.isBeforeFirst()
Retrieves whether the cursor is before the first row in this ResultSet object. |
boolean |
ResultSet.isAfterLast()
Retrieves whether the cursor is after the last row in this ResultSet object. |
boolean |
ResultSet.isFirst()
Retrieves whether the cursor is on the first row of this ResultSet object. |
boolean |
ResultSet.isLast()
Retrieves whether the cursor is on the last row of this ResultSet object. |
void |
ResultSet.beforeFirst()
Moves the cursor to the front of this ResultSet object, just before the
first row. |
void |
ResultSet.afterLast()
Moves the cursor to the end of this ResultSet object, just after the
last row. |
boolean |
ResultSet.first()
Moves the cursor to the first row in this ResultSet object. |
boolean |
ResultSet.last()
Moves the cursor to the last row in this ResultSet object. |
int |
ResultSet.getRow()
Retrieves the current row number. |
boolean |
ResultSet.absolute(int row)
Moves the cursor to the given row number in this ResultSet object. |
boolean |
ResultSet.relative(int rows)
Moves the cursor a relative number of rows, either positive or negative. |
boolean |
ResultSet.previous()
Moves the cursor to the previous row in this ResultSet object. |
void |
ResultSet.setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in this ResultSet object will be processed. |
int |
ResultSet.getFetchDirection()
Retrieves the fetch direction for this ResultSet object. |
void |
ResultSet.setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. |
int |
ResultSet.getFetchSize()
Retrieves the fetch size for this ResultSet object. |
int |
ResultSet.getType()
Retrieves the type of this ResultSet object. |
int |
ResultSet.getConcurrency()
Retrieves the concurrency mode of this ResultSet object. |
boolean |
ResultSet.rowUpdated()
Retrieves whether the current row has been updated. |
boolean |
ResultSet.rowInserted()
Retrieves whether the current row has had an insertion. |
boolean |
ResultSet.rowDeleted()
Retrieves whether a row has been deleted. |
void |
ResultSet.updateNull(int columnIndex)
Gives a nullable column a null value. |
void |
ResultSet.updateBoolean(int columnIndex,
boolean x)
Updates the designated column with a boolean value. |
void |
ResultSet.updateByte(int columnIndex,
byte x)
Updates the designated column with a byte value. |
void |
ResultSet.updateShort(int columnIndex,
short x)
Updates the designated column with a short value. |
void |
ResultSet.updateInt(int columnIndex,
int x)
Updates the designated column with an int value. |
void |
ResultSet.updateLong(int columnIndex,
long x)
Updates the designated column with a long value. |
void |
ResultSet.updateFloat(int columnIndex,
float x)
Updates the designated column with a float value. |
void |
ResultSet.updateDouble(int columnIndex,
double x)
Updates the designated column with a double value. |
void |
ResultSet.updateBigDecimal(int columnIndex,
BigDecimal x)
Updates the designated column with a java.math.BigDecimal
value. |
void |
ResultSet.updateString(int columnIndex,
String x)
Updates the designated column with a String value. |
void |
ResultSet.updateBytes(int columnIndex,
byte[] x)
Updates the designated column with a byte array value. |
void |
ResultSet.updateDate(int columnIndex,
Date x)
Updates the designated column with a java.sql.Date value. |
void |
ResultSet.updateTime(int columnIndex,
Time x)
Updates the designated column with a java.sql.Time value. |
void |
ResultSet.updateTimestamp(int columnIndex,
Timestamp x)
Updates the designated column with a java.sql.Timestamp
value. |
void |
ResultSet.updateAsciiStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with an ascii stream value. |
void |
ResultSet.updateBinaryStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with a binary stream value. |
void |
ResultSet.updateCharacterStream(int columnIndex,
Reader x,
int length)
Updates the designated column with a character stream value. |
void |
ResultSet.updateObject(int columnIndex,
Object x,
int scale)
Updates the designated column with an Object value. |
void |
ResultSet.updateObject(int columnIndex,
Object x)
Updates the designated column with an Object value. |
void |
ResultSet.updateNull(String columnName)
Updates the designated column with a null value. |
void |
ResultSet.updateBoolean(String columnName,
boolean x)
Updates the designated column with a boolean value. |
void |
ResultSet.updateByte(String columnName,
byte x)
Updates the designated column with a byte value. |
void |
ResultSet.updateShort(String columnName,
short x)
Updates the designated column with a short value. |
void |
ResultSet.updateInt(String columnName,
int x)
Updates the designated column with an int value. |
void |
ResultSet.updateLong(String columnName,
long x)
Updates the designated column with a long value. |
void |
ResultSet.updateFloat(String columnName,
float x)
Updates the designated column with a float value. |
void |
ResultSet.updateDouble(String columnName,
double x)
Updates the designated column with a double value. |
void |
ResultSet.updateBigDecimal(String columnName,
BigDecimal x)
Updates the designated column with a java.sql.BigDecimal
value. |
void |
ResultSet.updateString(String columnName,
String x)
Updates the designated column with a String value. |
void |
ResultSet.updateBytes(String columnName,
byte[] x)
Updates the designated column with a byte array value. |
void |
ResultSet.updateDate(String columnName,
Date x)
Updates the designated column with a java.sql.Date value. |
void |
ResultSet.updateTime(String columnName,
Time x)
Updates the designated column with a java.sql.Time value. |
void |
ResultSet.updateTimestamp(String columnName,
Timestamp x)
Updates the designated column with a java.sql.Timestamp
value. |
void |
ResultSet.updateAsciiStream(String columnName,
InputStream x,
int length)
Updates the designated column with an ascii stream value. |
void |
ResultSet.updateBinaryStream(String columnName,
InputStream x,
int length)
Updates the designated column with a binary stream value. |
void |
ResultSet.updateCharacterStream(String columnName,
Reader reader,
int length)
Updates the designated column with a character stream value. |
void |
ResultSet.updateObject(String columnName,
Object x,
int scale)
Updates the designated column with an Object value. |
void |
ResultSet.updateObject(String columnName,
Object x)
Updates the designated column with an Object value. |
void |
ResultSet.insertRow()
Inserts the contents of the insert row into this ResultSet object and into the database. |
void |
ResultSet.updateRow()
Updates the underlying database with the new contents of the current row of this ResultSet object. |
void |
ResultSet.deleteRow()
Deletes the current row from this ResultSet object
and from the underlying database. |
void |
ResultSet.refreshRow()
Refreshes the current row with its most recent value in the database. |
void |
ResultSet.cancelRowUpdates()
Cancels the updates made to the current row in this ResultSet object. |
void |
ResultSet.moveToInsertRow()
Moves the cursor to the insert row. |
void |
ResultSet.moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row. |
Statement |
ResultSet.getStatement()
Retrieves the Statement object that produced this
ResultSet object. |
Object |
ResultSet.getObject(int i,
Map map)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object
in the Java programming language. |
Ref |
ResultSet.getRef(int i)
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object
in the Java programming language. |
Blob |
ResultSet.getBlob(int i)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
Clob |
ResultSet.getClob(int i)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
Array |
ResultSet.getArray(int i)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
Object |
ResultSet.getObject(String colName,
Map map)
Retrieves the value of the designated column in the current row of this ResultSet object as an Object
in the Java programming language. |
Ref |
ResultSet.getRef(String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Ref object
in the Java programming language. |
Blob |
ResultSet.getBlob(String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object
in the Java programming language. |
Clob |
ResultSet.getClob(String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as a Clob object
in the Java programming language. |
Array |
ResultSet.getArray(String colName)
Retrieves the value of the designated column in the current row of this ResultSet object as an Array object
in the Java programming language. |
Date |
ResultSet.getDate(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
ResultSet.getDate(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object
in the Java programming language. |
Time |
ResultSet.getTime(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object
in the Java programming language. |
Time |
ResultSet.getTime(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object
in the Java programming language. |
Timestamp |
ResultSet.getTimestamp(int columnIndex,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
ResultSet.getTimestamp(String columnName,
Calendar cal)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
URL |
ResultSet.getURL(int columnIndex)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL
object in the Java programming language. |
URL |
ResultSet.getURL(String columnName)
Retrieves the value of the designated column in the current row of this ResultSet object as a java.net.URL
object in the Java programming language. |
void |
ResultSet.updateRef(int columnIndex,
Ref x)
Updates the designated column with a java.sql.Ref value. |
void |
ResultSet.updateRef(String columnName,
Ref x)
Updates the designated column with a java.sql.Ref value. |
void |
ResultSet.updateBlob(int columnIndex,
Blob x)
Updates the designated column with a java.sql.Blob value. |
void |
ResultSet.updateBlob(String columnName,
Blob x)
Updates the designated column with a java.sql.Blob value. |
void |
ResultSet.updateClob(int columnIndex,
Clob x)
Updates the designated column with a java.sql.Clob value. |
void |
ResultSet.updateClob(String columnName,
Clob x)
Updates the designated column with a java.sql.Clob value. |
void |
ResultSet.updateArray(int columnIndex,
Array x)
Updates the designated column with a java.sql.Array value. |
void |
ResultSet.updateArray(String columnName,
Array x)
Updates the designated column with a java.sql.Array value. |
String |
Array.getBaseTypeName()
Retrieves the SQL type name of the elements in the array designated by this Array object. |
int |
Array.getBaseType()
Retrieves the JDBC type of the elements in the array designated by this Array object. |
Object |
Array.getArray()
Retrieves the contents of the SQL ARRAY value designated
by this
Array object in the form of an array in the Java
programming language. |
Object |
Array.getArray(Map map)
Retrieves the contents of the SQL ARRAY value designated by this
Array object. |
Object |
Array.getArray(long index,
int count)
Retrieves a slice of the SQL ARRAY
value designated by this Array object, beginning with the
specified index and containing up to count
successive elements of the SQL array. |
Object |
Array.getArray(long index,
int count,
Map map)
Retreives a slice of the SQL ARRAY value
designated by this Array object, beginning with the specified
index and containing up to count
successive elements of the SQL array. |
ResultSet |
Array.getResultSet()
Retrieves a result set that contains the elements of the SQL ARRAY value
designated by this Array object. |
ResultSet |
Array.getResultSet(Map map)
Retrieves a result set that contains the elements of the SQL ARRAY value designated by this Array object. |
ResultSet |
Array.getResultSet(long index,
int count)
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to
count successive elements. |
ResultSet |
Array.getResultSet(long index,
int count,
Map map)
Retrieves a result set holding the elements of the subarray that starts at index index and contains up to
count successive elements. |
Uses of SQLException in javax.sql |
Methods in javax.sql that throw SQLException | |
XAConnection |
XADataSource.getXAConnection()
Attempts to establish a physical database connection that can be used in a distributed transaction. |
XAConnection |
XADataSource.getXAConnection(String user,
String password)
Attempts to establish a physical database connection, using the given user name and password. |
PrintWriter |
XADataSource.getLogWriter()
Retrieves the log writer for this XADataSource object. |
void |
XADataSource.setLogWriter(PrintWriter out)
Sets the log writer for this XADataSource object
to the given java.io.PrintWriter object. |
void |
XADataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a data source. |
int |
XADataSource.getLoginTimeout()
Retrieves the maximum time in seconds that this data source can wait while attempting to connect to a data source. |
XAResource |
XAConnection.getXAResource()
Retrieves an XAResource object that
the transaction manager will use
to manage this XAConnection object's participation in a
distributed transaction. |
boolean |
RowSetWriter.writeData(RowSetInternal caller)
Writes the changes in this RowSetWriter object's
rowset back to the data source from which it got its data. |
void |
RowSetReader.readData(RowSetInternal caller)
Reads the new contents of the calling RowSet object. |
void |
RowSetMetaData.setColumnCount(int columnCount)
Sets the number of columns in the RowSet object to
the given number. |
void |
RowSetMetaData.setAutoIncrement(int columnIndex,
boolean property)
Sets whether the designated column is automatically numbered, and thus read-only. |
void |
RowSetMetaData.setCaseSensitive(int columnIndex,
boolean property)
Sets whether the designated column is case sensitive. |
void |
RowSetMetaData.setSearchable(int columnIndex,
boolean property)
Sets whether the designated column can be used in a where clause. |
void |
RowSetMetaData.setCurrency(int columnIndex,
boolean property)
Sets whether the designated column is a cash value. |
void |
RowSetMetaData.setNullable(int columnIndex,
int property)
Sets whether the designated column's value can be set to NULL . |
void |
RowSetMetaData.setSigned(int columnIndex,
boolean property)
Sets whether the designated column is a signed number. |
void |
RowSetMetaData.setColumnDisplaySize(int columnIndex,
int size)
Sets the designated column's normal maximum width in chars to the given int . |
void |
RowSetMetaData.setColumnLabel(int columnIndex,
String label)
Sets the suggested column title for use in printouts and displays, if any, to the given String . |
void |
RowSetMetaData.setColumnName(int columnIndex,
String columnName)
Sets the name of the designated column to the given String . |
void |
RowSetMetaData.setSchemaName(int columnIndex,
String schemaName)
Sets the name of the designated column's table's schema, if any, to the given String . |
void |
RowSetMetaData.setPrecision(int columnIndex,
int precision)
Sets the designated column's number of decimal digits to the given int . |
void |
RowSetMetaData.setScale(int columnIndex,
int scale)
Sets the designated column's number of digits to the right of the decimal point to the given int . |
void |
RowSetMetaData.setTableName(int columnIndex,
String tableName)
Sets the designated column's table name, if any, to the given String . |
void |
RowSetMetaData.setCatalogName(int columnIndex,
String catalogName)
Sets the designated column's table's catalog name, if any, to the given String . |
void |
RowSetMetaData.setColumnType(int columnIndex,
int SQLType)
Sets the designated column's SQL type to the one given. |
void |
RowSetMetaData.setColumnTypeName(int columnIndex,
String typeName)
Sets the designated column's type name that is specific to the data source, if any, to the given String . |
Object[] |
RowSetInternal.getParams()
Retrieves the parameters that have been set for this RowSet object's command. |
Connection |
RowSetInternal.getConnection()
Retrieves the Connection object that was passed to this
RowSet object. |
void |
RowSetInternal.setMetaData(RowSetMetaData md)
Sets the given RowSetMetaData object as the
RowSetMetaData object for this RowSet
object. |
ResultSet |
RowSetInternal.getOriginal()
Retrieves a ResultSet object containing the original
value of this RowSet object. |
ResultSet |
RowSetInternal.getOriginalRow()
Retrieves a ResultSet object containing the original value
of the current row only. |
String |
RowSet.getUrl()
Retrieves the url property this RowSet object will use to
create a connection if it uses the DriverManager
instead of a DataSource object to establish the connection. |
void |
RowSet.setUrl(String url)
Sets the URL this RowSet object will use when it uses the
DriverManager to create a connection. |
void |
RowSet.setDataSourceName(String name)
Sets the data source name property for this RowSet object to the
given String . |
void |
RowSet.setUsername(String name)
Sets the username property for this RowSet object to the
given String . |
void |
RowSet.setPassword(String password)
Sets the database password for this RowSet object to
the given String . |
void |
RowSet.setTransactionIsolation(int level)
Sets the transaction isolation level for this RowSet obejct. |
Map |
RowSet.getTypeMap()
Retrieves the Map object associated with this
RowSet object, which specifies the custom mapping
of SQL user-defined types, if any. |
void |
RowSet.setTypeMap(Map map)
Installs the given java.util.Map object as the default
type map for this RowSet object. |
void |
RowSet.setCommand(String cmd)
Sets this RowSet object's command property to the given
SQL query. |
void |
RowSet.setReadOnly(boolean value)
Sets whether this RowSet object is read-only to the
given boolean . |
int |
RowSet.getMaxFieldSize()
Retrieves the maximum number of bytes that may be returned for certain column values. |
void |
RowSet.setMaxFieldSize(int max)
Sets the maximum number of bytes that can be returned for a column value to the given number of bytes. |
int |
RowSet.getMaxRows()
Retrieves the maximum number of rows that this RowSet
object can contain. |
void |
RowSet.setMaxRows(int max)
Sets the maximum number of rows that this RowSet
object can contain to the specified number. |
boolean |
RowSet.getEscapeProcessing()
Retrieves whether escape processing is enabled for this RowSet object. |
void |
RowSet.setEscapeProcessing(boolean enable)
Sets escape processing for this RowSet object on or
off. |
int |
RowSet.getQueryTimeout()
Retrieves the maximum number of seconds the driver will wait for a statement to execute. |
void |
RowSet.setQueryTimeout(int seconds)
Sets the maximum time the driver will wait for a statement to execute to the given number of seconds. |
void |
RowSet.setType(int type)
Sets the type of this RowSet object to the given type. |
void |
RowSet.setConcurrency(int concurrency)
Sets the concurrency of this RowSet object to the given
concurrency level. |
void |
RowSet.setNull(int parameterIndex,
int sqlType)
Sets the designated parameter in this RowSet object's SQL
command to SQL NULL . |
void |
RowSet.setNull(int paramIndex,
int sqlType,
String typeName)
Sets the designated parameter in this RowSet object's SQL
command to SQL NULL . |
void |
RowSet.setBoolean(int parameterIndex,
boolean x)
Sets the designated parameter in this RowSet object's command
to the given Java boolean value. |
void |
RowSet.setByte(int parameterIndex,
byte x)
Sets the designated parameter in this RowSet object's command
to the given Java byte value. |
void |
RowSet.setShort(int parameterIndex,
short x)
Sets the designated parameter in this RowSet object's command
to the given Java short value. |
void |
RowSet.setInt(int parameterIndex,
int x)
Sets the designated parameter in this RowSet object's command
to the given Java int value. |
void |
RowSet.setLong(int parameterIndex,
long x)
Sets the designated parameter in this RowSet object's command
to the given Java long value. |
void |
RowSet.setFloat(int parameterIndex,
float x)
Sets the designated parameter in this RowSet object's command
to the given Java float value. |
void |
RowSet.setDouble(int parameterIndex,
double x)
Sets the designated parameter in this RowSet object's command
to the given Java double value. |
void |
RowSet.setBigDecimal(int parameterIndex,
BigDecimal x)
Sets the designated parameter in this RowSet object's command
to the given java.math.BigDeciaml value. |
void |
RowSet.setString(int parameterIndex,
String x)
Sets the designated parameter in this RowSet object's command
to the given Java String value. |
void |
RowSet.setBytes(int parameterIndex,
byte[] x)
Sets the designated parameter in this RowSet object's command
to the given Java array of byte values. |
void |
RowSet.setDate(int parameterIndex,
Date x)
Sets the designated parameter in this RowSet object's command
to the given java.sql.Date value. |
void |
RowSet.setTime(int parameterIndex,
Time x)
Sets the designated parameter in this RowSet object's command
to the given java.sql.Time value. |
void |
RowSet.setTimestamp(int parameterIndex,
Timestamp x)
Sets the designated parameter in this RowSet object's command
to the given java.sql.Timestamp value. |
void |
RowSet.setAsciiStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter in this RowSet object's command
to the given java.io.InputStream value. |
void |
RowSet.setBinaryStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter in this RowSet object's command
to the given java.io.InputStream value. |
void |
RowSet.setCharacterStream(int parameterIndex,
Reader reader,
int length)
Sets the designated parameter in this RowSet object's command
to the given java.io.Reader value. |
void |
RowSet.setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
Sets the designated parameter in this RowSet object's command
with the given Java Object . |
void |
RowSet.setObject(int parameterIndex,
Object x,
int targetSqlType)
Sets the designated parameter in this RowSet object's command
with a Java Object . |
void |
RowSet.setObject(int parameterIndex,
Object x)
Sets the designated parameter in this RowSet object's command
with a Java Object . |
void |
RowSet.setRef(int i,
Ref x)
Sets the designated parameter in this RowSet object's command
with the given Ref value. |
void |
RowSet.setBlob(int i,
Blob x)
Sets the designated parameter in this RowSet object's command
with the given Blob value. |
void |
RowSet.setClob(int i,
Clob x)
Sets the designated parameter in this RowSet object's command
with the given Clob value. |
void |
RowSet.setArray(int i,
Array x)
Sets the designated parameter in this RowSet object's command
with the given Array value. |
void |
RowSet.setDate(int parameterIndex,
Date x,
Calendar cal)
Sets the designated parameter in this RowSet object's command
with the given java.sql.Date value. |
void |
RowSet.setTime(int parameterIndex,
Time x,
Calendar cal)
Sets the designated parameter in this RowSet object's command
with the given java.sql.Time value. |
void |
RowSet.setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
Sets the designated parameter in this RowSet object's command
with the given java.sql.Timestamp value. |
void |
RowSet.clearParameters()
Clears the parameters set for this RowSet object's command. |
void |
RowSet.execute()
Fills this RowSet object with data. |
Connection |
DataSource.getConnection()
Attempts to establish a connection with the data source that this DataSource object represents. |
Connection |
DataSource.getConnection(String username,
String password)
Attempts to establish a connection with the data source that this DataSource object represents. |
PrintWriter |
DataSource.getLogWriter()
Retrieves the log writer for this DataSource
object. |
void |
DataSource.setLogWriter(PrintWriter out)
Sets the log writer for this DataSource
object to the given java.io.PrintWriter object. |
void |
DataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database. |
int |
DataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database. |
PooledConnection |
ConnectionPoolDataSource.getPooledConnection()
Attempts to establish a physical database connection that can be used as a pooled connection. |
PooledConnection |
ConnectionPoolDataSource.getPooledConnection(String user,
String password)
Attempts to establish a physical database connection that can be used as a pooled connection. |
PrintWriter |
ConnectionPoolDataSource.getLogWriter()
Retrieves the log writer for this ConnectionPoolDataSource
object. |
void |
ConnectionPoolDataSource.setLogWriter(PrintWriter out)
Sets the log writer for this ConnectionPoolDataSource
object to the given java.io.PrintWriter object. |
void |
ConnectionPoolDataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this ConnectionPoolDataSource object will wait
while attempting to connect to a database. |
int |
ConnectionPoolDataSource.getLoginTimeout()
Retrieves the maximum time in seconds that this ConnectionPoolDataSource object will wait
while attempting to connect to a database. |
Connection |
PooledConnection.getConnection()
Creates an object handle for the physical connection that this PooledConnection object represents. |
void |
PooledConnection.close()
Closes the physical connection that this PooledConnection
object represents. |
|
JavaTM 2 Platform Std. Ed. v1.4.0 |
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Java, Java 2D, and JDBC are trademarks or registered trademarks of Sun Microsystems, Inc. in the US and other countries.
Copyright 1993-2002 Sun Microsystems, Inc. 901 San Antonio Road
Palo Alto, California, 94303, U.S.A. All Rights Reserved.