| Package | Description |
|---|---|
| java.sql |
Provides the API for accessing and processing data stored in a data source (usually a relational database) using the Java
TM programming language.
|
| javax.sql |
Provides the API for server side data source access and processing from the Java
TM programming language.
|
| javax.sql.rowset |
Standard interfaces and base classes for JDBC
RowSet implementations.
|
| javax.sql.rowset.serial |
Provides utility classes to allow serializable mappings between SQL types and data types in the Java programming language.
|
| javax.sql.rowset.spi |
The standard classes and interfaces that a third party vendor has to use in its implementation of a synchronization provider.
|
| Modifier and Type | Class and Description |
|---|---|
class |
BatchUpdateException
The subclass of
SQLException thrown when an error occurs during a batch update operation.
|
class |
DataTruncation
An exception thrown as a
DataTruncation exception (on writes) or reported as a
DataTruncation warning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceeded
MaxFieldSize.
|
class |
SQLClientInfoException
The subclass of
SQLException is thrown when one or more client info properties could not be set on a
Connection.
|
class |
SQLDataException
The subclass of
SQLException thrown when the SQLState class value is '
22', or under vendor-specified conditions.
|
class |
SQLFeatureNotSupportedException
The subclass of
SQLException thrown when the SQLState class value is '
0A' ( the value is 'zero' A).
|
class |
SQLIntegrityConstraintViolationException
The subclass of
SQLException thrown when the SQLState class value is '
23', or under vendor-specified conditions.
|
class |
SQLInvalidAuthorizationSpecException
The subclass of
SQLException thrown when the SQLState class value is '
28', or under vendor-specified conditions.
|
class |
SQLNonTransientConnectionException
The subclass of
SQLException thrown for the SQLState class value '
08', or under vendor-specified conditions.
|
class |
SQLNonTransientException
The subclass of
SQLException thrown when an instance where a retry of the same operation would fail unless the cause of the
SQLException is corrected.
|
class |
SQLRecoverableException
The subclass of
SQLException thrown in situations where a previously failed operation might be able to succeed if the application performs some recovery steps and retries the entire transaction or in the case of a distributed transaction, the transaction branch.
|
class |
SQLSyntaxErrorException
The subclass of
SQLException thrown when the SQLState class value is '
42', or under vendor-specified conditions.
|
class |
SQLTimeoutException
The subclass of
SQLException thrown when the timeout specified by
Statement.setQueryTimeout,
DriverManager.setLoginTimeout,
DataSource.setLoginTimeout,
XADataSource.setLoginTimeout has expired.
|
class |
SQLTransactionRollbackException
The subclass of
SQLException thrown when the SQLState class value is '
40', or under vendor-specified conditions.
|
class |
SQLTransientConnectionException
The subclass of
SQLException for the SQLState class value '
08', or under vendor-specified conditions.
|
class |
SQLTransientException
The subclass of
SQLException is thrown in situations where a previously failed operation might be able to succeed when the operation is retried without any intervention by application-level functionality.
|
class |
SQLWarning
An exception that provides information on database access warnings.
|
| Modifier and Type | Method and Description |
|---|---|
SQLException |
SQLException.getNextException()
Retrieves the exception chained to this
SQLException object by setNextException(SQLException ex).
|
| Modifier and Type | Method and Description |
|---|---|
void |
SQLException.setNextException(SQLException
Adds an
SQLException object to the end of the chain.
|
| Modifier and Type | Method and Description |
|---|---|
void |
Connection.abort(Executor
Terminates an open connection.
|
boolean |
ResultSet.absolute(int row)
Moves the cursor to the given row number in this
ResultSet object.
|
boolean |
Driver.acceptsURL(String
Retrieves whether the driver thinks that it can open a connection to the given URL.
|
void |
PreparedStatement.addBatch()
Adds a set of parameters to this
PreparedStatement object's batch of commands.
|
void |
Statement.addBatch(String
Adds the given SQL command to the current list of commands for this
Statement object.
|
void |
ResultSet.afterLast()
Moves the cursor to the end of this
ResultSet object, just after the last row.
|
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.
|
boolean |
DatabaseMetaData.autoCommitFailureClosesAllResultSets()
Retrieves whether a
SQLException while autoCommit is
true indicates that all open ResultSets are closed, even ones that are holdable.
|
void |
ResultSet.beforeFirst()
Moves the cursor to the front of this
ResultSet object, just before the first row.
|
void |
Statement.cancel()
Cancels this
Statement object if both the DBMS and driver support aborting an SQL statement.
|
void |
ResultSet.cancelRowUpdates()
Cancels the updates made to the current row in this
ResultSet object.
|
void |
Statement.clearBatch()
Empties this
Statement object's current list of SQL commands.
|
void |
PreparedStatement.clearParameters()
Clears the current parameter values immediately.
|
void |
Connection.clearWarnings()
Clears all warnings reported for this
Connection object.
|
void |
ResultSet.clearWarnings()
Clears all warnings reported on this
ResultSet object.
|
void |
Statement.clearWarnings()
Clears all the warnings reported on this
Statement object.
|
void |
Connection.close()
Releases this
Connection object's database and JDBC resources immediately instead of waiting for them to be automatically released.
|
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.
|
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.
|
void |
Statement.closeOnCompletion()
Specifies that this
Statement will be closed when all its dependent result sets are closed.
|
void |
Connection.commit()
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this
Connection object.
|
Connection |
Driver.connect(String
Attempts to make a database connection to the given URL.
|
Array |
Connection.createArrayOf(String
Factory method for creating Array objects.
|
Blob |
Connection.createBlob()
Constructs an object that implements the
Blob interface.
|
Clob |
Connection.createClob()
Constructs an object that implements the
Clob interface.
|
NClob |
Connection.createNClob()
Constructs an object that implements the
NClob interface.
|
SQLXML |
Connection.createSQLXML()
Constructs an object that implements the
SQLXML interface.
|
Statement |
Connection.createStatement()
Creates a
Statement object for sending SQL statements to the database.
|
Statement |
Connection.createStatement(int resultSetType, int resultSetConcurrency)
Creates a
Statement object that will generate
ResultSet objects with the given type and concurrency.
|
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.
|
Struct |
Connection.createStruct(String
Factory method for creating Struct objects.
|
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.
|
void |
ResultSet.deleteRow()
Deletes the current row from this
ResultSet object and from the underlying database.
|
boolean |
DatabaseMetaData.deletesAreDetected(int type)
Retrieves whether or not a visible row delete can be detected by calling the method
ResultSet.rowDeleted.
|
static void |
DriverManager.deregisterDriver(Driver
Removes the specified driver from the
DriverManager's list of registered drivers.
|
boolean |
DatabaseMetaData.doesMaxRowSizeIncludeBlobs()
Retrieves whether the return value for the method
getMaxRowSize includes the SQL data types
LONGVARCHAR and
LONGVARBINARY.
|
boolean |
PreparedStatement.execute()
Executes the SQL statement in this
PreparedStatement object, which may be any kind of SQL statement.
|
boolean |
Statement.execute(String
Executes the given SQL statement, which may return multiple results.
|
boolean |
Statement.execute(String
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
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
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.executeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
|
default long[] |
Statement.executeLargeBatch()
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
|
default long |
PreparedStatement.executeLargeUpdate()
Executes the SQL statement in this
PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as
INSERT,
UPDATE or
DELETE; or an SQL statement that returns nothing, such as a DDL statement.
|
default long |
Statement.executeLargeUpdate(String
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.
|
default long |
Statement.executeLargeUpdate(String
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.
|
default long |
Statement.executeLargeUpdate(String
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.
|
default long |
Statement.executeLargeUpdate(String
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.
|
ResultSet |
PreparedStatement.executeQuery()
Executes the SQL query in this
PreparedStatement object and returns the
ResultSet object generated by the query.
|
ResultSet |
Statement.executeQuery(String
Executes the given SQL statement, which returns a single
ResultSet object.
|
int |
PreparedStatement.executeUpdate()
Executes the SQL statement in this
PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as
INSERT,
UPDATE or
DELETE; or an SQL statement that returns nothing, such as a DDL statement.
|
int |
Statement.executeUpdate(String
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.
|
int |
Statement.executeUpdate(String
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
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
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 |
ResultSet.findColumn(String
Maps the given
ResultSet column label to its
ResultSet column index.
|
boolean |
ResultSet.first()
Moves the cursor to the first row in this
ResultSet object.
|
void |
Clob.free()
This method frees the
Clob object and releases the resources the resources that it holds.
|
void |
SQLXML.free()
This method closes this object and releases the resources that it held.
|
void |
Blob.free()
This method frees the
Blob object and releases the resources that it holds.
|
void |
Array.free()
This method frees the
Array object and releases the resources that it holds.
|
boolean |
DatabaseMetaData.generatedKeyAlwaysReturned()
Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.
|
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.
|
Array |
ResultSet.getArray(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as an
Array object in the Java programming language.
|
Array |
CallableStatement.getArray(int parameterIndex)
Retrieves the value of the designated JDBC
ARRAY parameter as an
Array object in the Java programming language.
|
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
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.
|
Object |
Array.getArray(Map
Retrieves the contents of the SQL
ARRAY value designated by this
Array object.
|
Array |
ResultSet.getArray(String
Retrieves the value of the designated column in the current row of this
ResultSet object as an
Array object in the Java programming language.
|
Array |
CallableStatement.getArray(String
Retrieves the value of a JDBC
ARRAY parameter as an
Array object in the Java programming language.
|
InputStream |
Clob.getAsciiStream()
Retrieves the
CLOB value designated by this
Clob object as an ascii stream.
|
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.getAsciiStream(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of ASCII characters.
|
Object |
Struct.getAttributes()
Produces the ordered values of the attributes of the SQL structured type that this
Struct object represents.
|
Object |
Struct.getAttributes(Map
Produces the ordered values of the attributes of the SQL structured type that this
Struct object represents.
|
ResultSet |
DatabaseMetaData.getAttributes(String
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 |
Connection.getAutoCommit()
Retrieves the current auto-commit mode for this
Connection object.
|
int |
Array.getBaseType()
Retrieves the JDBC type of the elements in the array designated by this
Array object.
|
String |
Ref.getBaseTypeName()
Retrieves the fully-qualified SQL name of the SQL structured type that this
Ref object references.
|
String |
Array.getBaseTypeName()
Retrieves the SQL type name of the elements in the array designated by this
Array object.
|
ResultSet |
DatabaseMetaData.getBestRowIdentifier(String
Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
|
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 |
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.
|
BigDecimal |
ResultSet.getBigDecimal(int columnIndex, int scale)
Deprecated.
Use
getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)
|
BigDecimal |
CallableStatement.getBigDecimal(int parameterIndex, int scale)
Deprecated.
use
getBigDecimal(int parameterIndex) or getBigDecimal(String parameterName)
|
BigDecimal |
ResultSet.getBigDecimal(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.math.BigDecimal with full precision.
|
BigDecimal |
CallableStatement.getBigDecimal(String
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.
|
BigDecimal |
ResultSet.getBigDecimal(String
Deprecated.
Use
getBigDecimal(int columnIndex) or getBigDecimal(String columnLabel)
|
InputStream |
SQLXML.getBinaryStream()
Retrieves the XML value designated by this SQLXML instance as a stream.
|
InputStream |
Blob.getBinaryStream()
Retrieves the
BLOB value designated by this
Blob instance as a stream.
|
InputStream |
ResultSet.getBinaryStream(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of uninterpreted bytes.
|
InputStream |
Blob.getBinaryStream(long pos, long length)
Returns an
InputStream object that contains a partial
Blob value, starting with the byte specified by pos, which is length bytes in length.
|
InputStream |
ResultSet.getBinaryStream(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a stream of uninterpreted
bytes.
|
Blob |
ResultSet.getBlob(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Blob object in the Java programming language.
|
Blob |
CallableStatement.getBlob(int parameterIndex)
Retrieves the value of the designated JDBC
BLOB parameter as a
Blob object in the Java programming language.
|
Blob |
ResultSet.getBlob(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Blob object in the Java programming language.
|
Blob |
CallableStatement.getBlob(String
Retrieves the value of a JDBC
BLOB parameter as a
Blob object 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.
|
boolean |
CallableStatement.getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC
BIT or
BOOLEAN parameter as a
boolean in the Java programming language.
|
boolean |
ResultSet.getBoolean(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
boolean in the Java programming language.
|
boolean |
CallableStatement.getBoolean(String
Retrieves the value of a JDBC
BIT or
BOOLEAN parameter 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.
|
byte |
CallableStatement.getByte(int parameterIndex)
Retrieves the value of the designated JDBC
TINYINT parameter as a
byte in the Java programming language.
|
byte |
ResultSet.getByte(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
byte in the Java programming language.
|
byte |
CallableStatement.getByte(String
Retrieves the value of a JDBC
TINYINT parameter as a
byte in the Java programming language.
|
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.
|
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.
|
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.
|
byte[] |
ResultSet.getBytes(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
byte array in the Java programming language.
|
byte[] |
CallableStatement.getBytes(String
Retrieves the value of a JDBC
BINARY or
VARBINARY parameter as an array of
byte values in the Java programming language.
|
String |
Connection.getCatalog()
Retrieves this
Connection object's current catalog name.
|
String |
ResultSetMetaData.getCatalogName(int column)
Gets the designated column's table's catalog name.
|
ResultSet |
DatabaseMetaData.getCatalogs()
Retrieves the catalog names available in this database.
|
String |
DatabaseMetaData.getCatalogSeparator()
Retrieves the
String that this database uses as the separator between a catalog and table name.
|
String |
DatabaseMetaData.getCatalogTerm()
Retrieves the database vendor's preferred term for "catalog".
|
Reader |
Clob.getCharacterStream()
Retrieves the
CLOB value designated by this
Clob object as a
java.io.Reader object (or as a stream of characters).
|
Reader |
SQLXML.getCharacterStream()
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.
|
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 |
CallableStatement.getCharacterStream(int parameterIndex)
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
|
Reader |
Clob.getCharacterStream(long pos, long length)
Returns a
Reader object that contains a partial
Clob value, starting with the character specified by pos, which is length characters in length.
|
Reader |
ResultSet.getCharacterStream(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.io.Reader object.
|
Reader |
CallableStatement.getCharacterStream(String
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
|
Properties |
Connection.getClientInfo()
Returns a list containing the name and current value of each client info property supported by the driver.
|
String |
Connection.getClientInfo(String
Returns the value of the client info property specified by name.
|
ResultSet |
DatabaseMetaData.getClientInfoProperties()
Retrieves a list of the client info properties that the driver supports.
|
Clob |
ResultSet.getClob(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Clob object in the Java programming language.
|
Clob |
CallableStatement.getClob(int parameterIndex)
Retrieves the value of the designated JDBC
CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
Clob |
ResultSet.getClob(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Clob object in the Java programming language.
|
Clob |
CallableStatement.getClob(String
Retrieves the value of a JDBC
CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
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.
|
int |
ResultSetMetaData.getColumnCount()
Returns the number of columns in this
ResultSet object.
|
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.
|
ResultSet |
DatabaseMetaData.getColumnPrivileges(String
Retrieves a description of the access rights for a table's columns.
|
ResultSet |
DatabaseMetaData.getColumns(String
Retrieves a description of table columns available in the specified catalog.
|
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.
|
int |
ResultSet.getConcurrency()
Retrieves the concurrency mode of this
ResultSet object.
|
Connection |
DatabaseMetaData.getConnection()
Retrieves the connection that produced this metadata object.
|
Connection |
Statement.getConnection()
Retrieves the
Connection object that produced this
Statement object.
|
static Connection |
DriverManager.getConnection(String
Attempts to establish a connection to the given database URL.
|
static Connection |
DriverManager.getConnection(String
Attempts to establish a connection to the given database URL.
|
static Connection |
DriverManager.getConnection(String
Attempts to establish a connection to the given database URL.
|
ResultSet |
DatabaseMetaData.getCrossReference(String
Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
|
String |
ResultSet.getCursorName()
Retrieves the name of the SQL cursor used by 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.
|
String |
DatabaseMetaData.getDatabaseProductName()
Retrieves the name of this database product.
|
String |
DatabaseMetaData.getDatabaseProductVersion()
Retrieves the version number of this database product.
|
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.
|
Date |
CallableStatement.getDate(int parameterIndex)
Retrieves the value of the designated JDBC
DATE parameter as a
java.sql.Date object.
|
Date |
ResultSet.getDate(int columnIndex, Calendar
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 |
CallableStatement.getDate(int parameterIndex, Calendar
Retrieves the value of the designated JDBC
DATE parameter as a
java.sql.Date object, using the given
Calendar object to construct the date.
|
Date |
ResultSet.getDate(String
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 |
CallableStatement.getDate(String
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object.
|
Date |
ResultSet.getDate(String
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 |
CallableStatement.getDate(String
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object, using the given
Calendar object to construct the date.
|
int |
DatabaseMetaData.getDefaultTransactionIsolation()
Retrieves this database's default transaction isolation level.
|
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.
|
double |
CallableStatement.getDouble(int parameterIndex)
Retrieves the value of the designated JDBC
DOUBLE parameter as a
double in the Java programming language.
|
double |
ResultSet.getDouble(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
double in the Java programming language.
|
double |
CallableStatement.getDouble(String
Retrieves the value of a JDBC
DOUBLE parameter as a
double in the Java programming language.
|
static Driver |
DriverManager.getDriver(String
Attempts to locate a driver that understands the given URL.
|
String |
DatabaseMetaData.getDriverName()
Retrieves the name of this JDBC driver.
|
String |
DatabaseMetaData.getDriverVersion()
Retrieves the version number of this JDBC driver as a
String.
|
ResultSet |
DatabaseMetaData.getExportedKeys(String
Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
|
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 _).
|
int |
ResultSet.getFetchDirection()
Retrieves the fetch direction for this
ResultSet 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.
|
int |
ResultSet.getFetchSize()
Retrieves the fetch size for this
ResultSet object.
|
int |
Statement.getFetchSize()
Retrieves the number of result set rows that is the default fetch size for
ResultSet objects generated from this
Statement object.
|
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.
|
float |
CallableStatement.getFloat(int parameterIndex)
Retrieves the value of the designated JDBC
FLOAT parameter as a
float in the Java programming language.
|
float |
ResultSet.getFloat(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
float in the Java programming language.
|
float |
CallableStatement.getFloat(String
Retrieves the value of a JDBC
FLOAT parameter as a
float in the Java programming language.
|
ResultSet |
DatabaseMetaData.getFunctionColumns(String
Retrieves a description of the given catalog's system or user function parameters and return type.
|
ResultSet |
DatabaseMetaData.getFunctions(String
Retrieves a description of the system and user functions available in the given catalog.
|
ResultSet |
Statement.getGeneratedKeys()
Retrieves any auto-generated keys created as a result of executing this
Statement object.
|
int |
Connection.getHoldability()
Retrieves the current holdability of
ResultSet objects created using this
Connection object.
|
int |
ResultSet.getHoldability()
Retrieves the holdability of this
ResultSet object
|
String |
DatabaseMetaData.getIdentifierQuoteString()
Retrieves the string used to quote SQL identifiers.
|
ResultSet |
DatabaseMetaData.getImportedKeys(String
Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).
|
ResultSet |
DatabaseMetaData.getIndexInfo(String
Retrieves a description of the given table's indices and statistics.
|
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.
|
int |
CallableStatement.getInt(int parameterIndex)
Retrieves the value of the designated JDBC
INTEGER parameter as an
int in the Java programming language.
|
int |
ResultSet.getInt(String
Retrieves the value of the designated column in the current row of this
ResultSet object as an
int in the Java programming language.
|
int |
CallableStatement.getInt(String
Retrieves the value of a JDBC
INTEGER parameter as an
int in the Java programming language.
|
int |
DatabaseMetaData.getJDBCMajorVersion()
Retrieves the major JDBC version number for this driver.
|
int |
DatabaseMetaData.getJDBCMinorVersion()
Retrieves the minor JDBC version number for this driver.
|
default long |
Statement.getLargeMaxRows()
Retrieves the maximum number of rows that a
ResultSet object produced by this
Statement object can contain.
|
default long |
Statement.getLargeUpdateCount()
Retrieves the current result as an update count; if the result is a
ResultSet object or there are no more results, -1 is returned.
|
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.
|
long |
CallableStatement.getLong(int parameterIndex)
Retrieves the value of the designated JDBC
BIGINT parameter as a
long in the Java programming language.
|
long |
ResultSet.getLong(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
long in the Java programming language.
|
long |
CallableStatement.getLong(String
Retrieves the value of a JDBC
BIGINT parameter as a
long in the Java programming language.
|
int |
DatabaseMetaData.getMaxBinaryLiteralLength()
Retrieves the maximum number of hex characters this database allows in an inline binary literal.
|
int |
DatabaseMetaData.getMaxCatalogNameLength()
Retrieves the maximum number of characters that this database allows in a catalog name.
|
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 |
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.
|
int |
DatabaseMetaData.getMaxIndexLength()
Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
|
default long |
DatabaseMetaData.getMaxLogicalLobSize()
Retrieves the maximum number of bytes this database allows for the logical size for a
LOB.
|
int |
DatabaseMetaData.getMaxProcedureNameLength()
Retrieves the maximum number of characters that this database allows in a procedure name.
|
int |
Statement.getMaxRows()
Retrieves the maximum number of rows that a
ResultSet object produced by this
Statement object can contain.
|
int |
DatabaseMetaData.getMaxRowSize()
Retrieves the maximum number of bytes this database allows in a single row.
|
int |
DatabaseMetaData.getMaxSchemaNameLength()
Retrieves the maximum number of characters that this database allows in a schema name.
|
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.
|
DatabaseMetaData |
Connection.getMetaData()
Retrieves a
DatabaseMetaData object that contains metadata about the database to which this
Connection object represents a connection.
|
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.
|
ResultSetMetaData |
ResultSet.getMetaData()
Retrieves the number, types and properties of this
ResultSet object's columns.
|
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.
|
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.
|
Reader |
ResultSet.getNCharacterStream(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.io.Reader object.
|
Reader |
CallableStatement.getNCharacterStream(int parameterIndex)
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
|
Reader |
ResultSet.getNCharacterStream(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.io.Reader object.
|
Reader |
CallableStatement.getNCharacterStream(String
Retrieves the value of the designated parameter as a
java.io.Reader object in the Java programming language.
|
NClob |
ResultSet.getNClob(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
NClob object in the Java programming language.
|
NClob |
CallableStatement.getNClob(int parameterIndex)
Retrieves the value of the designated JDBC
NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
NClob |
ResultSet.getNClob(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
NClob object in the Java programming language.
|
NClob |
CallableStatement.getNClob(String
Retrieves the value of a JDBC
NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
int |
Connection.getNetworkTimeout()
Retrieves the number of milliseconds the driver will wait for a database request to complete.
|
String |
ResultSet.getNString(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.
|
String |
CallableStatement.getNString(int parameterIndex)
Retrieves the value of the designated
NCHAR,
NVARCHAR or
LONGNVARCHAR parameter as a
String in the Java programming language.
|
String |
ResultSet.getNString(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
String in the Java programming language.
|
String |
CallableStatement.getNString(String
Retrieves the value of the designated
NCHAR,
NVARCHAR or
LONGNVARCHAR parameter as a
String in the Java programming language.
|
String |
DatabaseMetaData.getNumericFunctions()
Retrieves a comma-separated list of math functions available with this database.
|
Object |
Ref.getObject()
Retrieves the SQL structured type instance referenced by this
Ref object.
|
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 |
CallableStatement.getObject(int parameterIndex)
Retrieves the value of the designated parameter as an
Object in the Java programming language.
|
<T> T |
ResultSet.getObject(int columnIndex, Class
Retrieves the value of the designated column in the current row of this
ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
|
<T> T |
CallableStatement.getObject(int parameterIndex, Class
Returns an object representing the value of OUT parameter
parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
|
Object |
ResultSet.getObject(int columnIndex, Map
Retrieves the value of the designated column in the current row of this
ResultSet object as an
Object in the Java programming language.
|
Object |
CallableStatement.getObject(int parameterIndex, Map
Returns an object representing the value of OUT parameter
parameterIndex and uses
map for the custom mapping of the parameter value.
|
Object |
Ref.getObject(Map
Retrieves the referenced object and maps it to a Java type using the given type map.
|
Object |
ResultSet.getObject(String
Gets the value of the designated column in the current row of this
ResultSet object as an
Object in the Java programming language.
|
Object |
CallableStatement.getObject(String
Retrieves the value of a parameter as an
Object in the Java programming language.
|
<T> T |
ResultSet.getObject(String
Retrieves the value of the designated column in the current row of this
ResultSet object and will convert from the SQL type of the column to the requested Java data type, if the conversion is supported.
|
<T> T |
CallableStatement.getObject(String
Returns an object representing the value of OUT parameter
parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
|
Object |
ResultSet.getObject(String
Retrieves the value of the designated column in the current row of this
ResultSet object as an
Object in the Java programming language.
|
Object |
CallableStatement.getObject(String
Returns an object representing the value of OUT parameter
parameterName and uses
map for the custom mapping of the parameter value.
|
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.getParameterCount()
Retrieves the number of parameters in the
PreparedStatement object for which this
ParameterMetaData object contains information.
|
ParameterMetaData |
PreparedStatement.getParameterMetaData()
Retrieves the number, types and properties of this
PreparedStatement object's parameters.
|
int |
ParameterMetaData.getParameterMode(int param)
Retrieves the designated parameter's mode.
|
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.
|
int |
ResultSetMetaData.getPrecision(int column)
Get the designated column's specified column size.
|
int |
ParameterMetaData.getPrecision(int param)
Retrieves the designated parameter's specified column size.
|
ResultSet |
DatabaseMetaData.getPrimaryKeys(String
Retrieves a description of the given table's primary key columns.
|
ResultSet |
DatabaseMetaData.getProcedureColumns(String
Retrieves a description of the given catalog's stored procedure parameter and result columns.
|
ResultSet |
DatabaseMetaData.getProcedures(String
Retrieves a description of the stored procedures available in the given catalog.
|
String |
DatabaseMetaData.getProcedureTerm()
Retrieves the database vendor's preferred term for "procedure".
|
DriverPropertyInfo |
Driver.getPropertyInfo(String
Gets information about the possible properties for this driver.
|
ResultSet |
DatabaseMetaData.getPseudoColumns(String
Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.
|
int |
Statement.getQueryTimeout()
Retrieves the number of seconds the driver will wait for a
Statement object to execute.
|
Ref |
ResultSet.getRef(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Ref object in the Java programming language.
|
Ref |
CallableStatement.getRef(int parameterIndex)
Retrieves the value of the designated JDBC
REF(<structured-type>) parameter as a
Ref object in the Java programming language.
|
Ref |
ResultSet.getRef(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
Ref object in the Java programming language.
|
Ref |
CallableStatement.getRef(String
Retrieves the value of a JDBC
REF(<structured-type>) parameter as a
Ref object in the Java programming language.
|
ResultSet |
Array.getResultSet()
Retrieves a result set that contains the elements of the SQL
ARRAY value designated by this
Array object.
|
ResultSet |
Statement.getResultSet()
Retrieves the current result as a
ResultSet 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
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(Map
Retrieves a result set that contains the elements of the SQL
ARRAY value designated by this
Array object.
|
int |
Statement.getResultSetConcurrency()
Retrieves the result set concurrency for
ResultSet objects generated by this
Statement object.
|
int |
DatabaseMetaData.getResultSetHoldability()
Retrieves this database's default holdability for
ResultSet objects.
|
int |
Statement.getResultSetHoldability()
Retrieves the result set holdability for
ResultSet objects generated by this
Statement object.
|
int |
Statement.getResultSetType()
Retrieves the result set type for
ResultSet objects generated by this
Statement object.
|
int |
ResultSet.getRow()
Retrieves the current row number.
|
RowId |
ResultSet.getRowId(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.sql.RowId object in the Java programming language.
|
RowId |
CallableStatement.getRowId(int parameterIndex)
Retrieves the value of the designated JDBC
ROWID parameter as a
java.sql.RowId object.
|
RowId |
ResultSet.getRowId(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
java.sql.RowId object in the Java programming language.
|
RowId |
CallableStatement.getRowId(String
Retrieves the value of the designated JDBC
ROWID parameter as a
java.sql.RowId object.
|
RowIdLifetime |
DatabaseMetaData.getRowIdLifetime()
Indicates whether or not this data source supports the SQL
ROWID type, and if so the lifetime for which a
RowId object remains valid.
|
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.
|
int |
ResultSetMetaData.getScale(int column)
Gets the designated column's number of digits to right of the decimal point.
|
int |
ParameterMetaData.getScale(int param)
Retrieves the designated parameter's number of digits to right of the decimal point.
|
String |
Connection.getSchema()
Retrieves this
Connection object's current schema name.
|
String |
ResultSetMetaData.getSchemaName(int column)
Get the designated column's table's schema.
|
ResultSet |
DatabaseMetaData.getSchemas()
Retrieves the schema names available in this database.
|
ResultSet |
DatabaseMetaData.getSchemas(String
Retrieves the schema names available in this database.
|
String |
DatabaseMetaData.getSchemaTerm()
Retrieves the database vendor's preferred term for "schema".
|
String |
DatabaseMetaData.getSearchStringEscape()
Retrieves the string that can be used to escape wildcard characters.
|
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.
|
short |
CallableStatement.getShort(int parameterIndex)
Retrieves the value of the designated JDBC
SMALLINT parameter as a
short in the Java programming language.
|
short |
ResultSet.getShort(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
short in the Java programming language.
|
short |
CallableStatement.getShort(String
Retrieves the value of a JDBC
SMALLINT parameter as a
short in the Java programming language.
|
<T extends Source |
SQLXML.getSource(Class
Returns a Source for reading the XML value designated by this SQLXML instance.
|
String |
DatabaseMetaData.getSQLKeywords()
Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.
|
int |
DatabaseMetaData.getSQLStateType()
Indicates whether the SQLSTATE returned by
SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.
|
String |
SQLData.getSQLTypeName()
Returns the fully-qualified name of the SQL user-defined type that this object represents.
|
String |
Struct.getSQLTypeName()
Retrieves the SQL type name of the SQL structured type that this
Struct object represents.
|
SQLXML |
ResultSet.getSQLXML(int columnIndex)
Retrieves the value of the designated column in the current row of this
ResultSet as a
java.sql.SQLXML object in the Java programming language.
|
SQLXML |
CallableStatement.getSQLXML(int parameterIndex)
Retrieves the value of the designated
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
SQLXML |
ResultSet.getSQLXML(String
Retrieves the value of the designated column in the current row of this
ResultSet as a
java.sql.SQLXML object in the Java programming language.
|
SQLXML |
CallableStatement.getSQLXML(String
Retrieves the value of the designated
SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
Statement |
ResultSet.getStatement()
Retrieves the
Statement object that produced this
ResultSet object.
|
String |
SQLXML.getString()
Returns a string representation of the XML value designated by this SQLXML instance.
|
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.
|
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.
|
String |
ResultSet.getString(String
Retrieves the value of the designated column in the current row of this
ResultSet object as a
String in the Java programming language.
|
String |
CallableStatement.getString(String
Retrieves the value of a JDBC
CHAR,
VARCHAR, or
LONGVARCHAR parameter as a
String in the Java programming language.
|
String |
DatabaseMetaData.getStringFunctions()
Retrieves a comma-separated list of string functions available with this database.
|
String |
Clob.getSubString(long pos, int length)
Retrieves a copy of the specified substring in the
CLOB value designated by this
Clob object.
|
ResultSet |
DatabaseMetaData.getSuperTables(String
Retrieves a description of the table hierarchies defined in a particular schema in this database.
|
ResultSet |
DatabaseMetaData.getSuperTypes(String
Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
|
String |
DatabaseMetaData.getSystemFunctions()
Retrieves a comma-separated list of system functions available with this database.
|
String |
ResultSetMetaData.getTableName(int column)
Gets the designated column's table name.
|
ResultSet |
DatabaseMetaData.getTablePrivileges(String
Retrieves a description of the access rights for each table available in a catalog.
|
ResultSet |
DatabaseMetaData.getTables(String
Retrieves a description of the tables available in the given catalog.
|
ResultSet |
DatabaseMetaData.getTableTypes()
Retrieves the table types available in this database.
|
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.
|
Time |
CallableStatement.getTime(int parameterIndex)
Retrieves the value of the designated JDBC
TIME parameter as a
java.sql.Time object.
|
Time |
ResultSet.getTime(int columnIndex, Calendar
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 |
CallableStatement.getTime(int parameterIndex, Calendar
Retrieves the value of the designated JDBC
TIME parameter as a
java.sql.Time object, using the given
Calendar object to construct the time.
|
Time |
ResultSet.getTime(String
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 |
CallableStatement.getTime(String
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object.
|
Time |
ResultSet.getTime(String
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 |
CallableStatement.getTime(String
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object, using the given
Calendar object to construct the time.
|
String |
DatabaseMetaData.getTimeDateFunctions()
Retrieves a comma-separated list of the time and date functions available with this database.
|
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.
|
Timestamp |
CallableStatement.getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object.
|
Timestamp |
ResultSet.getTimestamp(int columnIndex, Calendar
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 |
CallableStatement.getTimestamp(int parameterIndex, Calendar
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.
|
Timestamp |
ResultSet.getTimestamp(String
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 |
CallableStatement.getTimestamp(String
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object.
|
Timestamp |
ResultSet.getTimestamp(String
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 |
CallableStatement.getTimestamp(String
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object, using the given
Calendar object to construct the
Timestamp object.
|
int |
Connection.getTransactionIsolation()
Retrieves this
Connection object's current transaction isolation level.
|
int |
ResultSet.getType()
Retrieves the type of this
ResultSet object.
|
ResultSet |
DatabaseMetaData.getTypeInfo()
Retrieves a description of all the data types supported by this database.
|
Map |
Connection.getTypeMap()
Retrieves the
Map object associated with this
Connection object.
|
ResultSet |
DatabaseMetaData.getUDTs(String
Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
|
InputStream |
ResultSet.getUnicodeStream(int columnIndex)
Deprecated.
use
getCharacterStream in place of getUnicodeStream
|
InputStream |
ResultSet.getUnicodeStream(String
Deprecated.
use
getCharacterStream instead
|
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.
|
String |
DatabaseMetaData.getURL()
Retrieves the URL for this DBMS.
|
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 |
CallableStatement.getURL(int parameterIndex)
Retrieves the value of the designated JDBC
DATALINK parameter as a
java.net.URL object.
|
URL |
ResultSet.getURL(String
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 |
CallableStatement.getURL(String
Retrieves the value of a JDBC
DATALINK parameter as a
java.net.URL object.
|
String |
DatabaseMetaData.getUserName()
Retrieves the user name as known to this database.
|
ResultSet |
DatabaseMetaData.getVersionColumns(String
Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
|
SQLWarning |
Connection.getWarnings()
Retrieves the first warning reported by calls on this
Connection object.
|
SQLWarning |
ResultSet.getWarnings()
Retrieves the first warning reported by calls on this
ResultSet object.
|
SQLWarning |
Statement.getWarnings()
Retrieves the first warning reported by calls on this
Statement object.
|
void |
ResultSet.insertRow()
Inserts the contents of the insert row into this
ResultSet object and into the database.
|
boolean |
DatabaseMetaData.insertsAreDetected(int type)
Retrieves whether or not a visible row insert can be detected by calling the method
ResultSet.rowInserted.
|
boolean |
ResultSet.isAfterLast()
Retrieves whether the cursor is after the last row in this
ResultSet object.
|
boolean |
ResultSetMetaData.isAutoIncrement(int column)
Indicates whether the designated column is automatically numbered.
|
boolean |
ResultSet.isBeforeFirst()
Retrieves whether the cursor is before the first row in this
ResultSet object.
|
boolean |
ResultSetMetaData.isCaseSensitive(int column)
Indicates whether a column's case matters.
|
boolean |
DatabaseMetaData.isCatalogAtStart()
Retrieves whether a catalog appears at the start of a fully qualified table name.
|
boolean |
Connection.isClosed()
Retrieves whether this
Connection object has been closed.
|
boolean |
ResultSet.isClosed()
Retrieves whether this
ResultSet object has been closed.
|
boolean |
Statement.isClosed()
Retrieves whether this
Statement object has been closed.
|
boolean |
Statement.isCloseOnCompletion()
Returns a value indicating whether this
Statement will be closed when all its dependent result sets are closed.
|
boolean |
ResultSetMetaData.isCurrency(int column)
Indicates whether the designated column is a cash value.
|
boolean |
ResultSetMetaData.isDefinitelyWritable(int column)
Indicates whether a write on the designated column will definitely succeed.
|
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.
|
int |
ResultSetMetaData.isNullable(int column)
Indicates the nullability of values in the designated column.
|
int |
ParameterMetaData.isNullable(int param)
Retrieves whether null values are allowed in the designated parameter.
|
boolean |
Statement.isPoolable()
Returns a value indicating whether the
Statement is poolable or not.
|
boolean |
Connection.isReadOnly()
Retrieves whether this
Connection object is in read-only mode.
|
boolean |
DatabaseMetaData.isReadOnly()
Retrieves whether this database is in read-only mode.
|
boolean |
ResultSetMetaData.isReadOnly(int column)
Indicates whether the designated column is definitely not writable.
|
boolean |
ResultSetMetaData.isSearchable(int column)
Indicates whether the designated column can be used in a where clause.
|
boolean |
ResultSetMetaData.isSigned(int column)
Indicates whether values in the designated column are signed numbers.
|
boolean |
ParameterMetaData.isSigned(int param)
Retrieves whether values for the designated parameter can be signed numbers.
|
boolean |
Connection.isValid(int timeout)
Returns true if the connection has not been closed and is still valid.
|
boolean |
Wrapper.isWrapperFor(Class
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
|
boolean |
ResultSetMetaData.isWritable(int column)
Indicates whether it is possible for a write on the designated column to succeed.
|
boolean |
ResultSet.last()
Moves the cursor to the last row in this
ResultSet object.
|
long |
Clob.length()
Retrieves the number of characters in the
CLOB value designated by this
Clob object.
|
long |
Blob.length()
Returns the number of bytes in the
BLOB value designated by this
Blob object.
|
boolean |
DatabaseMetaData.locatorsUpdateCopy()
Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
|
void |
ResultSet.moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row.
|
void |
ResultSet.moveToInsertRow()
Moves the cursor to the insert row.
|
String |
Connection.nativeSQL(String
Converts the given SQL statement into the system's native SQL grammar.
|
boolean |
ResultSet.next()
Moves the cursor forward one row from its current position.
|
boolean |
DatabaseMetaData.nullPlusNonNullIsNull()
Retrieves whether this database supports concatenations between
NULL and non-
NULL values being
NULL.
|
boolean |
DatabaseMetaData.nullsAreSortedAtEnd()
Retrieves whether
NULL values are sorted at the end regardless of sort order.
|
boolean |
DatabaseMetaData.nullsAreSortedAtStart()
Retrieves whether
NULL values are sorted at the start regardless of sort order.
|
boolean |
DatabaseMetaData.nullsAreSortedHigh()
Retrieves whether
NULL values are sorted high.
|
boolean |
DatabaseMetaData.nullsAreSortedLow()
Retrieves whether
NULL values are sorted low.
|
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.othersUpdatesAreVisible(int type)
Retrieves whether updates made by others 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.ownUpdatesAreVisible(int type)
Retrieves whether for the given type of
ResultSet object, the result set's own updates are visible.
|
long |
Blob.position(Blob
Retrieves the byte position in the
BLOB value designated by this
Blob object at which
pattern begins.
|
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 |
Clob.position(Clob
Retrieves the character position at which the specified
Clob object
searchstr appears in this
Clob object.
|
long |
Clob.position(String
Retrieves the character position at which the specified substring
searchstr appears in the SQL
CLOB value represented by this
Clob object.
|
CallableStatement |
Connection.prepareCall(String
Creates a
CallableStatement object for calling database stored procedures.
|
CallableStatement |
Connection.prepareCall(String
Creates a
CallableStatement object that will generate
ResultSet objects with the given type and concurrency.
|
CallableStatement |
Connection.prepareCall(String
Creates a
CallableStatement object that will generate
ResultSet objects with the given type and concurrency.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a
PreparedStatement object for sending parameterized SQL statements to the database.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a default
PreparedStatement object that has the capability to retrieve auto-generated keys.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a default
PreparedStatement object capable of returning the auto-generated keys designated by the given array.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a
PreparedStatement object that will generate
ResultSet objects with the given type and concurrency.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a
PreparedStatement object that will generate
ResultSet objects with the given type, concurrency, and holdability.
|
PreparedStatement |
Connection.prepareStatement(String
Creates a default
PreparedStatement object capable of returning the auto-generated keys designated by the given array.
|
boolean |
ResultSet.previous()
Moves the cursor to the previous row in this
ResultSet object.
|
Array |
SQLInput.readArray()
Reads an SQL
ARRAY value from the stream and returns it as an
Array object in the Java programming language.
|
InputStream |
SQLInput.readAsciiStream()
Reads the next attribute in the stream and returns it as a stream of ASCII characters.
|
BigDecimal |
SQLInput.readBigDecimal()
Reads the next attribute in the stream and returns it as a
java.math.BigDecimal object in the Java programming language.
|
InputStream |
SQLInput.readBinaryStream()
Reads the next attribute in the stream and returns it as a stream of uninterpreted bytes.
|
Blob |
SQLInput.readBlob()
Reads an SQL
BLOB value from the stream and returns it as a
Blob object 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.
|
byte[] |
SQLInput.readBytes()
Reads the next attribute in the stream and returns it as an array of bytes in the Java programming language.
|
Reader |
SQLInput.readCharacterStream()
Reads the next attribute in the stream and returns it as a stream of Unicode characters.
|
Clob |
SQLInput.readClob()
Reads an SQL
CLOB value from the stream and returns it as a
Clob object in the Java programming language.
|
Date |
SQLInput.readDate()
Reads the next attribute in the stream and returns it as a
java.sql.Date object.
|
double |
SQLInput.readDouble()
Reads the next attribute in the stream and returns it as a
double 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.
|
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.
|
NClob |
SQLInput.readNClob()
Reads an SQL
NCLOB value from the stream and returns it as a
NClob object in the Java programming language.
|
String |
SQLInput.readNString()
Reads the next attribute in the stream and returns it as a
String in the Java programming language.
|
Object |
SQLInput.readObject()
Reads the datum at the head of the stream and returns it as an
Object in the Java programming language.
|
default <T> T |
SQLInput.readObject(Class
Reads the next attribute in 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.
|
RowId |
SQLInput.readRowId()
Reads an SQL
ROWID value from the stream and returns it as a
RowId object 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.
|
void |
SQLData.readSQL(SQLInput
Populates this object with data read from the database.
|
SQLXML |
SQLInput.readSQLXML()
Reads an SQL
XML value from the stream and returns it as a
SQLXML object in the Java programming language.
|
String |
SQLInput.readString()
Reads the next attribute in the stream and returns it as a
String in the Java programming language.
|
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.
|
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.
|
void |
ResultSet.refreshRow()
Refreshes the current row with its most recent value in the database.
|
static void |
DriverManager.registerDriver(Driver
Registers the given driver with the
DriverManager.
|
static void |
DriverManager.registerDriver(Driver
Registers the given driver with the
DriverManager.
|
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.
|
void |
CallableStatement.registerOutParameter(int parameterIndex, int sqlType, String
Registers the designated output parameter.
|
default void |
CallableStatement.registerOutParameter(int parameterIndex, SQLType
Registers the OUT parameter in ordinal position
parameterIndex to the JDBC type
sqlType.
|
default void |
CallableStatement.registerOutParameter(int parameterIndex, SQLType
Registers the parameter in ordinal position
parameterIndex to be of JDBC type
sqlType.
|
default void |
CallableStatement.registerOutParameter(int parameterIndex, SQLType
Registers the designated output parameter.
|
void |
CallableStatement.registerOutParameter(String
Registers the OUT parameter named
parameterName to the JDBC type
sqlType.
|
void |
CallableStatement.registerOutParameter(String
Registers the parameter named
parameterName to be of JDBC type
sqlType.
|
void |
CallableStatement.registerOutParameter(String
Registers the designated output parameter.
|
default void |
CallableStatement.registerOutParameter(String
Registers the OUT parameter named
parameterName to the JDBC type
sqlType.
|
default void |
CallableStatement.registerOutParameter(String
Registers the parameter named
parameterName to be of JDBC type
sqlType.
|
default void |
CallableStatement.registerOutParameter(String
Registers the designated output parameter.
|
boolean |
ResultSet.relative(int rows)
Moves the cursor a relative number of rows, either positive or negative.
|
void |
Connection.releaseSavepoint(Savepoint
Removes the specified
Savepoint and subsequent
Savepoint objects from the current transaction.
|
void |
Connection.rollback()
Undoes all changes made in the current transaction and releases any database locks currently held by this
Connection object.
|
void |
Connection.rollback(Savepoint
Undoes all changes made after the given
Savepoint object was set.
|
boolean |
ResultSet.rowDeleted()
Retrieves whether a row has been deleted.
|
boolean |
ResultSet.rowInserted()
Retrieves whether the current row has had an insertion.
|
boolean |
ResultSet.rowUpdated()
Retrieves whether the current row has been updated.
|
void |
PreparedStatement.setArray(int parameterIndex, Array
Sets the designated parameter to the given
java.sql.Array object.
|
void |
PreparedStatement.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream.
|
void |
PreparedStatement.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
PreparedStatement.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
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.
|
void |
CallableStatement.setAsciiStream(String
Sets the designated parameter to the given input stream.
|
void |
CallableStatement.setAsciiStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
CallableStatement.setAsciiStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
Connection.setAutoCommit(boolean autoCommit)
Sets this connection's auto-commit mode to the given state.
|
void |
PreparedStatement.setBigDecimal(int parameterIndex, BigDecimal
Sets the designated parameter to the given
java.math.BigDecimal value.
|
void |
CallableStatement.setBigDecimal(String
Sets the designated parameter to the given
java.math.BigDecimal value.
|
OutputStream |
SQLXML.setBinaryStream()
Retrieves a stream that can be used to write the XML value that this SQLXML instance represents.
|
void |
PreparedStatement.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream.
|
void |
PreparedStatement.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
PreparedStatement.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
OutputStream |
Blob.setBinaryStream(long pos)
Retrieves a stream that can be used to write to the
BLOB value that this
Blob object represents.
|
void |
CallableStatement.setBinaryStream(String
Sets the designated parameter to the given input stream.
|
void |
CallableStatement.setBinaryStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
CallableStatement.setBinaryStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
PreparedStatement.setBlob(int parameterIndex, Blob
Sets the designated parameter to the given
java.sql.Blob object.
|
void |
PreparedStatement.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
PreparedStatement.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
CallableStatement.setBlob(String
Sets the designated parameter to the given
java.sql.Blob object.
|
void |
CallableStatement.setBlob(String
Sets the designated parameter to a
InputStream object.
|
void |
CallableStatement.setBlob(String
Sets the designated parameter to a
InputStream object.
|
void |
PreparedStatement.setBoolean(int parameterIndex, boolean x)
Sets the designated parameter to the given Java
boolean value.
|
void |
CallableStatement.setBoolean(String
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 |
CallableStatement.setByte(String
Sets the designated parameter to the given Java
byte value.
|
void |
PreparedStatement.setBytes(int parameterIndex, byte[] x)
Sets the designated parameter to the given Java array of bytes.
|
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.
|
void |
CallableStatement.setBytes(String
Sets the designated parameter to the given Java array of bytes.
|
void |
Connection.setCatalog(String
Sets the given catalog name in order to select a subspace of this
Connection object's database in which to work.
|
Writer |
SQLXML.setCharacterStream()
Retrieves a stream to be used to write the XML value that this SQLXML instance represents.
|
void |
PreparedStatement.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter to the given
Reader object.
|
void |
PreparedStatement.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
void |
PreparedStatement.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
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 |
CallableStatement.setCharacterStream(String
Sets the designated parameter to the given
Reader object.
|
void |
CallableStatement.setCharacterStream(String
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
void |
CallableStatement.setCharacterStream(String
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
void |
PreparedStatement.setClob(int parameterIndex, Clob
Sets the designated parameter to the given
java.sql.Clob object.
|
void |
PreparedStatement.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
PreparedStatement.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setClob(String
Sets the designated parameter to the given
java.sql.Clob object.
|
void |
CallableStatement.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
Statement.setCursorName(String
Sets the SQL cursor name to the given
String, which will be used by subsequent
Statement object
execute methods.
|
void |
PreparedStatement.setDate(int parameterIndex, Date
Sets the designated parameter to the given
java.sql.Date value using the default time zone of the virtual machine that is running the application.
|
void |
PreparedStatement.setDate(int parameterIndex, Date
Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object.
|
void |
CallableStatement.setDate(String
Sets the designated parameter to the given
java.sql.Date value using the default time zone of the virtual machine that is running the application.
|
void |
CallableStatement.setDate(String
Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object.
|
void |
PreparedStatement.setDouble(int parameterIndex, double x)
Sets the designated parameter to the given Java
double value.
|
void |
CallableStatement.setDouble(String
Sets the designated parameter to the given Java
double value.
|
void |
Statement.setEscapeProcessing(boolean enable)
Sets escape processing on or off.
|
void |
ResultSet.setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in this
ResultSet object will be processed.
|
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.
|
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.
|
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 for
ResultSet objects generated by this
Statement.
|
void |
PreparedStatement.setFloat(int parameterIndex, float x)
Sets the designated parameter to the given Java
float value.
|
void |
CallableStatement.setFloat(String
Sets the designated parameter to the given Java
float value.
|
void |
Connection.setHoldability(int holdability)
Changes the default holdability of
ResultSet objects created using this
Connection object to the given holdability.
|
void |
PreparedStatement.setInt(int parameterIndex, int x)
Sets the designated parameter to the given Java
int value.
|
void |
CallableStatement.setInt(String
Sets the designated parameter to the given Java
int value.
|
default void |
Statement.setLargeMaxRows(long max)
Sets the limit for the maximum number of rows that any
ResultSet object generated by this
Statement object can contain to the given number.
|
void |
PreparedStatement.setLong(int parameterIndex, long x)
Sets the designated parameter to the given Java
long value.
|
void |
CallableStatement.setLong(String
Sets the designated parameter to the given Java
long value.
|
void |
Statement.setMaxFieldSize(int max)
Sets the limit for 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.setMaxRows(int max)
Sets the limit for the maximum number of rows that any
ResultSet object generated by this
Statement object can contain to the given number.
|
void |
PreparedStatement.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
PreparedStatement.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
PreparedStatement.setNClob(int parameterIndex, NClob
Sets the designated parameter to a
java.sql.NClob object.
|
void |
PreparedStatement.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
PreparedStatement.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setNClob(String
Sets the designated parameter to a
java.sql.NClob object.
|
void |
CallableStatement.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
CallableStatement.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
Connection.setNetworkTimeout(Executor
Sets the maximum period a
Connection or objects created from the
Connection will wait for the database to reply to any one request.
|
void |
PreparedStatement.setNString(int parameterIndex, String
Sets the designated parameter to the given
String object.
|
void |
CallableStatement.setNString(String
Sets the designated parameter to the given
String object.
|
void |
PreparedStatement.setNull(int parameterIndex, int sqlType)
Sets the designated parameter to SQL
NULL.
|
void |
PreparedStatement.setNull(int parameterIndex, int sqlType, String
Sets the designated parameter to SQL
NULL.
|
void |
CallableStatement.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
CallableStatement.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
PreparedStatement.setObject(int parameterIndex, Object
Sets the value of the designated parameter using the given object.
|
void |
PreparedStatement.setObject(int parameterIndex, Object
Sets the value of the designated parameter with the given object.
|
void |
PreparedStatement.setObject(int parameterIndex, Object
Sets the value of the designated parameter with the given object.
|
default void |
PreparedStatement.setObject(int parameterIndex, Object
Sets the value of the designated parameter with the given object.
|
default void |
PreparedStatement.setObject(int parameterIndex, Object
Sets the value of the designated parameter with the given object.
|
void |
Ref.setObject(Object
Sets the structured type value that this
Ref object references to the given instance of
Object.
|
void |
CallableStatement.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
CallableStatement.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
CallableStatement.setObject(String
Sets the value of the designated parameter with the given object.
|
default void |
CallableStatement.setObject(String
Sets the value of the designated parameter with the given object.
|
default void |
CallableStatement.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
Statement.setPoolable(boolean poolable)
Requests that a
Statement be pooled or not pooled.
|
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 |
Connection.setReadOnly(boolean readOnly)
Puts this connection in read-only mode as a hint to the driver to enable database optimizations.
|
void |
PreparedStatement.setRef(int parameterIndex, Ref
Sets the designated parameter to the given
REF(<structured-type>) value.
|
<T extends Result |
SQLXML.setResult(Class
Returns a Result for setting the XML value designated by this SQLXML instance.
|
void |
PreparedStatement.setRowId(int parameterIndex, RowId
Sets the designated parameter to the given
java.sql.RowId object.
|
void |
CallableStatement.setRowId(String
Sets the designated parameter to the given
java.sql.RowId 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
Creates a savepoint with the given name in the current transaction and returns the new
Savepoint object that represents it.
|
void |
Connection.setSchema(String
Sets the given schema name to access.
|
void |
PreparedStatement.setShort(int parameterIndex, short x)
Sets the designated parameter to the given Java
short value.
|
void |
CallableStatement.setShort(String
Sets the designated parameter to the given Java
short value.
|
void |
PreparedStatement.setSQLXML(int parameterIndex, SQLXML
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
CallableStatement.setSQLXML(String
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
PreparedStatement.setString(int parameterIndex, String
Sets the designated parameter to the given Java
String value.
|
int |
Clob.setString(long pos, String
Writes the given Java
String to the
CLOB value that this
Clob object designates at the position
pos.
|
int |
Clob.setString(long pos, String
Writes
len characters of
str, starting at character
offset, to the
CLOB value that this
Clob represents.
|
void |
SQLXML.setString(String
Sets the XML value designated by this SQLXML instance to the given String representation.
|
void |
CallableStatement.setString(String
Sets the designated parameter to the given Java
String value.
|
void |
PreparedStatement.setTime(int parameterIndex, Time
Sets the designated parameter to the given
java.sql.Time value.
|
void |
PreparedStatement.setTime(int parameterIndex, Time
Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object.
|
void |
CallableStatement.setTime(String
Sets the designated parameter to the given
java.sql.Time value.
|
void |
CallableStatement.setTime(String
Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object.
|
void |
PreparedStatement.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter to the given
java.sql.Timestamp value.
|
void |
PreparedStatement.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object.
|
void |
CallableStatement.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value.
|
void |
CallableStatement.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object.
|
void |
Connection.setTransactionIsolation(int level)
Attempts to change the transaction isolation level for this
Connection object to the one given.
|
void |
Connection.setTypeMap(Map
Installs the given
TypeMap object as the type map for this
Connection object.
|
void |
PreparedStatement.setUnicodeStream(int parameterIndex, InputStream
Deprecated.
Use
setCharacterStream
|
void |
PreparedStatement.setURL(int parameterIndex, URL
Sets the designated parameter to the given
java.net.URL value.
|
void |
CallableStatement.setURL(String
Sets the designated parameter to the given
java.net.URL object.
|
boolean |
DatabaseMetaData.storesLowerCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower 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.storesMixedCaseIdentifiers()
Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
|
boolean |
DatabaseMetaData.storesMixedCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and 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.storesUpperCaseQuotedIdentifiers()
Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
|
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.supportsANSI92EntryLevelSQL()
Retrieves whether this database supports the ANSI92 entry level SQL grammar.
|
boolean |
DatabaseMetaData.supportsANSI92FullSQL()
Retrieves whether this database supports the ANSI92 full SQL grammar supported.
|
boolean |
DatabaseMetaData.supportsANSI92IntermediateSQL()
Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
|
boolean |
DatabaseMetaData.supportsBatchUpdates()
Retrieves whether this database supports batch updates.
|
boolean |
DatabaseMetaData.supportsCatalogsInDataManipulation()
Retrieves whether a catalog name can be used in a data manipulation 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.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.supportsColumnAliasing()
Retrieves whether this database supports column aliasing.
|
boolean |
DatabaseMetaData.supportsConvert()
Retrieves whether this database supports the JDBC scalar function
CONVERT for the conversion of one JDBC type to another.
|
boolean |
DatabaseMetaData.supportsConvert(int fromType, int toType)
Retrieves whether this database supports the JDBC scalar function
CONVERT for conversions between the JDBC types
fromType and
toType.
|
boolean |
DatabaseMetaData.supportsCoreSQLGrammar()
Retrieves whether this database supports the ODBC Core SQL grammar.
|
boolean |
DatabaseMetaData.supportsCorrelatedSubqueries()
Retrieves whether this database supports correlated subqueries.
|
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.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.supportsExtendedSQLGrammar()
Retrieves whether this database supports the ODBC Extended SQL grammar.
|
boolean |
DatabaseMetaData.supportsFullOuterJoins()
Retrieves whether this database supports full nested outer joins.
|
boolean |
DatabaseMetaData.supportsGetGeneratedKeys()
Retrieves whether auto-generated keys can be retrieved after a statement has been executed
|
boolean |
DatabaseMetaData.supportsGroupBy()
Retrieves whether this database supports some form of
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.supportsGroupByUnrelated()
Retrieves whether this database supports using a column that is not in the
SELECT statement in a
GROUP BY clause.
|
boolean |
DatabaseMetaData.supportsIntegrityEnhancementFacility()
Retrieves whether this database supports the SQL Integrity Enhancement Facility.
|
boolean |
DatabaseMetaData.supportsLikeEscapeClause()
Retrieves whether this database supports specifying a
LIKE escape clause.
|
boolean |
DatabaseMetaData.supportsLimitedOuterJoins()
Retrieves whether this database provides limited support for outer joins.
|
boolean |
DatabaseMetaData.supportsMinimumSQLGrammar()
Retrieves whether this database supports the ODBC Minimum SQL grammar.
|
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.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.supportsMultipleOpenResults()
Retrieves whether it is possible to have multiple
ResultSet objects returned from a
CallableStatement object simultaneously.
|
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.supportsNamedParameters()
Retrieves whether this database supports named parameters to callable statements.
|
boolean |
DatabaseMetaData.supportsNonNullableColumns()
Retrieves whether columns in this database may be defined as non-nullable.
|
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.
|
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.supportsOuterJoins()
Retrieves whether this database supports some form of outer join.
|
boolean |
DatabaseMetaData.supportsPositionedDelete()
Retrieves whether this database supports positioned
DELETE statements.
|
boolean |
DatabaseMetaData.supportsPositionedUpdate()
Retrieves whether this database supports positioned
UPDATE statements.
|
default boolean |
DatabaseMetaData.supportsRefCursors()
Retrieves whether this database supports REF CURSOR.
|
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.supportsResultSetHoldability(int holdability)
Retrieves whether this database supports the given result set holdability.
|
boolean |
DatabaseMetaData.supportsResultSetType(int type)
Retrieves whether this database supports the given result set type.
|
boolean |
DatabaseMetaData.supportsSavepoints()
Retrieves whether this database supports savepoints.
|
boolean |
DatabaseMetaData.supportsSchemasInDataManipulation()
Retrieves whether a schema name can be used in a data manipulation 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.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.supportsSelectForUpdate()
Retrieves whether this database supports
SELECT FOR UPDATE statements.
|
boolean |
DatabaseMetaData.supportsStatementPooling()
Retrieves whether this database supports statement pooling.
|
boolean |
DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax()
Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
|
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 expressions.
|
boolean |
DatabaseMetaData.supportsSubqueriesInQuantifieds()
Retrieves whether this database supports subqueries in quantified expressions.
|
boolean |
DatabaseMetaData.supportsTableCorrelationNames()
Retrieves whether this database supports table correlation names.
|
boolean |
DatabaseMetaData.supportsTransactionIsolationLevel(int level)
Retrieves whether this database supports the given transaction isolation level.
|
boolean |
DatabaseMetaData.supportsTransactions()
Retrieves whether this database supports transactions.
|
boolean |
DatabaseMetaData.supportsUnion()
Retrieves whether this database supports SQL
UNION.
|
boolean |
DatabaseMetaData.supportsUnionAll()
Retrieves whether this database supports SQL
UNION ALL.
|
void |
Clob.truncate(long len)
Truncates the
CLOB value that this
Clob designates to have a length of
len characters.
|
void |
Blob.truncate(long len)
Truncates the
BLOB value that this
Blob object represents to be
len bytes in length.
|
<T> T |
Wrapper.unwrap(Class
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
|
void |
ResultSet.updateArray(int columnIndex, Array
Updates the designated column with a
java.sql.Array value.
|
void |
ResultSet.updateArray(String
Updates the designated column with a
java.sql.Array value.
|
void |
ResultSet.updateAsciiStream(int columnIndex, InputStream
Updates the designated column with an ascii stream value.
|
void |
ResultSet.updateAsciiStream(int columnIndex, InputStream
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(int columnIndex, InputStream
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(String
Updates the designated column with an ascii stream value.
|
void |
ResultSet.updateAsciiStream(String
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(String
Updates the designated column with an ascii stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateBigDecimal(int columnIndex, BigDecimal
Updates the designated column with a
java.math.BigDecimal value.
|
void |
ResultSet.updateBigDecimal(String
Updates the designated column with a
java.sql.BigDecimal value.
|
void |
ResultSet.updateBinaryStream(int columnIndex, InputStream
Updates the designated column with a binary stream value.
|
void |
ResultSet.updateBinaryStream(int columnIndex, InputStream
Updates the designated column with a binary stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(int columnIndex, InputStream
Updates the designated column with a binary stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(String
Updates the designated column with a binary stream value.
|
void |
ResultSet.updateBinaryStream(String
Updates the designated column with a binary stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(String
Updates the designated column with a binary stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateBlob(int columnIndex, Blob
Updates the designated column with a
java.sql.Blob value.
|
void |
ResultSet.updateBlob(int columnIndex, InputStream
Updates the designated column using the given input stream.
|
void |
ResultSet.updateBlob(int columnIndex, InputStream
Updates the designated column using the given input stream, which will have the specified number of bytes.
|
void |
ResultSet.updateBlob(String
Updates the designated column with a
java.sql.Blob value.
|
void |
ResultSet.updateBlob(String
Updates the designated column using the given input stream.
|
void |
ResultSet.updateBlob(String
Updates the designated column using the given input stream, which will have the specified number of bytes.
|
void |
ResultSet.updateBoolean(int columnIndex, boolean x)
Updates the designated column with a
boolean value.
|
void |
ResultSet.updateBoolean(String
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.updateByte(String
Updates the designated column with a
byte value.
|
void |
ResultSet.updateBytes(int columnIndex, byte[] x)
Updates the designated column with a
byte array value.
|
void |
ResultSet.updateBytes(String
Updates the designated column with a byte array value.
|
void |
ResultSet.updateCharacterStream(int columnIndex, Reader
Updates the designated column with a character stream value.
|
void |
ResultSet.updateCharacterStream(int columnIndex, Reader
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(int columnIndex, Reader
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(String
Updates the designated column with a character stream value.
|
void |
ResultSet.updateCharacterStream(String
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(String
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateClob(int columnIndex, Clob
Updates the designated column with a
java.sql.Clob value.
|
void |
ResultSet.updateClob(int columnIndex, Reader
Updates the designated column using the given
Reader object.
|
void |
ResultSet.updateClob(int columnIndex, Reader
Updates the designated column using the given
Reader object, which is the given number of characters long.
|
void |
ResultSet.updateClob(String
Updates the designated column with a
java.sql.Clob value.
|
void |
ResultSet.updateClob(String
Updates the designated column using the given
Reader object.
|
void |
ResultSet.updateClob(String
Updates the designated column using the given
Reader object, which is the given number of characters long.
|
void |
ResultSet.updateDate(int columnIndex, Date
Updates the designated column with a
java.sql.Date value.
|
void |
ResultSet.updateDate(String
Updates the designated column with a
java.sql.Date value.
|
void |
ResultSet.updateDouble(int columnIndex, double x)
Updates the designated column with a
double value.
|
void |
ResultSet.updateDouble(String
Updates the designated column with a
double value.
|
void |
ResultSet.updateFloat(int columnIndex, float x)
Updates the designated column with a
float value.
|
void |
ResultSet.updateFloat(String
Updates the designated column with a
float value.
|
void |
ResultSet.updateInt(int columnIndex, int x)
Updates the designated column with an
int value.
|
void |
ResultSet.updateInt(String
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.updateLong(String
Updates the designated column with a
long value.
|
void |
ResultSet.updateNCharacterStream(int columnIndex, Reader
Updates the designated column with a character stream value.
|
void |
ResultSet.updateNCharacterStream(int columnIndex, Reader
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateNCharacterStream(String
Updates the designated column with a character stream value.
|
void |
ResultSet.updateNCharacterStream(String
Updates the designated column with a character stream value, which will have the specified number of bytes.
|
void |
ResultSet.updateNClob(int columnIndex, NClob
Updates the designated column with a
java.sql.NClob value.
|
void |
ResultSet.updateNClob(int columnIndex, Reader
Updates the designated column using the given
Reader The data will be read from the stream as needed until end-of-stream is reached.
|
void |
ResultSet.updateNClob(int columnIndex, Reader
Updates the designated column using the given
Reader object, which is the given number of characters long.
|
void |
ResultSet.updateNClob(String
Updates the designated column with a
java.sql.NClob value.
|
void |
ResultSet.updateNClob(String
Updates the designated column using the given
Reader object.
|
void |
ResultSet.updateNClob(String
Updates the designated column using the given
Reader object, which is the given number of characters long.
|
void |
ResultSet.updateNString(int columnIndex, String
Updates the designated column with a
String value.
|
void |
ResultSet.updateNString(String
Updates the designated column with a
String value.
|
void |
ResultSet.updateNull(int columnIndex)
Updates the designated column with a
null value.
|
void |
ResultSet.updateNull(String
Updates the designated column with a
null value.
|
void |
ResultSet.updateObject(int columnIndex, Object
Updates the designated column with an
Object value.
|
void |
ResultSet.updateObject(int columnIndex, Object
Updates the designated column with an
Object value.
|
default void |
ResultSet.updateObject(int columnIndex, Object
Updates the designated column with an
Object value.
|
default void |
ResultSet.updateObject(int columnIndex, Object
Updates the designated column with an
Object value.
|
void |
ResultSet.updateObject(String
Updates the designated column with an
Object value.
|
void |
ResultSet.updateObject(String
Updates the designated column with an
Object value.
|
default void |
ResultSet.updateObject(String
Updates the designated column with an
Object value.
|
default void |
ResultSet.updateObject(String
Updates the designated column with an
Object value.
|
void |
ResultSet.updateRef(int columnIndex, Ref
Updates the designated column with a
java.sql.Ref value.
|
void |
ResultSet.updateRef(String
Updates the designated column with a
java.sql.Ref value.
|
void |
ResultSet.updateRow()
Updates the underlying database with the new contents of the current row of this
ResultSet object.
|
void |
ResultSet.updateRowId(int columnIndex, RowId
Updates the designated column with a
RowId value.
|
void |
ResultSet.updateRowId(String
Updates the designated column with a
RowId value.
|
boolean |
DatabaseMetaData.updatesAreDetected(int type)
Retrieves whether or not a visible row update can be detected by calling the method
ResultSet.rowUpdated.
|
void |
ResultSet.updateShort(int columnIndex, short x)
Updates the designated column with a
short value.
|
void |
ResultSet.updateShort(String
Updates the designated column with a
short value.
|
void |
ResultSet.updateSQLXML(int columnIndex, SQLXML
Updates the designated column with a
java.sql.SQLXML value.
|
void |
ResultSet.updateSQLXML(String
Updates the designated column with a
java.sql.SQLXML value.
|
void |
ResultSet.updateString(int columnIndex, String
Updates the designated column with a
String value.
|
void |
ResultSet.updateString(String
Updates the designated column with a
String value.
|
void |
ResultSet.updateTime(int columnIndex, Time
Updates the designated column with a
java.sql.Time value.
|
void |
ResultSet.updateTime(String
Updates the designated column with a
java.sql.Time value.
|
void |
ResultSet.updateTimestamp(int columnIndex, Timestamp
Updates the designated column with a
java.sql.Timestamp value.
|
void |
ResultSet.updateTimestamp(String
Updates the designated column with a
java.sql.Timestamp value.
|
boolean |
DatabaseMetaData.usesLocalFilePerTable()
Retrieves whether this database uses a file for each table.
|
boolean |
DatabaseMetaData.usesLocalFiles()
Retrieves whether this database stores tables in a local file.
|
boolean |
ResultSet.wasNull()
Reports whether the last column read had a value of SQL
NULL.
|
boolean |
SQLInput.wasNull()
Retrieves whether the last value read was SQL
NULL.
|
boolean |
CallableStatement.wasNull()
Retrieves whether the last OUT parameter read had the value of SQL
NULL.
|
void |
SQLOutput.writeArray(Array
Writes an SQL
ARRAY value to the stream.
|
void |
SQLOutput.writeAsciiStream(InputStream
Writes the next attribute to the stream as a stream of ASCII characters.
|
void |
SQLOutput.writeBigDecimal(BigDecimal
Writes the next attribute to the stream as a java.math.BigDecimal object.
|
void |
SQLOutput.writeBinaryStream(InputStream
Writes the next attribute to the stream as a stream of uninterpreted bytes.
|
void |
SQLOutput.writeBlob(Blob
Writes an SQL
BLOB value to the stream.
|
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.writeBytes(byte[] x)
Writes the next attribute to the stream as an array of bytes.
|
void |
SQLOutput.writeCharacterStream(Reader
Writes the next attribute to the stream as a stream of Unicode characters.
|
void |
SQLOutput.writeClob(Clob
Writes an SQL
CLOB value to the stream.
|
void |
SQLOutput.writeDate(Date
Writes the next attribute to the stream as a java.sql.Date object.
|
void |
SQLOutput.writeDouble(double x)
Writes the next attribute to the stream as a Java double.
|
void |
SQLOutput.writeFloat(float x)
Writes the next attribute to the stream as a Java float.
|
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.writeNClob(NClob
Writes an SQL
NCLOB value to the stream.
|
void |
SQLOutput.writeNString(String
Writes the next attribute to the stream as a
String in the Java programming language.
|
default void |
SQLOutput.writeObject(Object
Writes to the stream the data contained in the given object.
|
void |
SQLOutput.writeObject(SQLData
Writes to the stream the data contained in the given
SQLData object.
|
void |
SQLOutput.writeRef(Ref
Writes an SQL
REF value to the stream.
|
void |
SQLOutput.writeRowId(RowId
Writes an SQL
ROWID value to the stream.
|
void |
SQLOutput.writeShort(short x)
Writes the next attribute to the stream as a Java short.
|
void |
SQLData.writeSQL(SQLOutput
Writes this object to the given SQL data stream, converting it back to its SQL value in the data source.
|
void |
SQLOutput.writeSQLXML(SQLXML
Writes an SQL
XML value to the stream.
|
void |
SQLOutput.writeString(String
Writes the next attribute to the stream as a
String in the Java programming language.
|
void |
SQLOutput.writeStruct(Struct
Writes an SQL structured type value to the stream.
|
void |
SQLOutput.writeTime(Time
Writes the next attribute to the stream as a java.sql.Time object.
|
void |
SQLOutput.writeTimestamp(Timestamp
Writes the next attribute to the stream as a java.sql.Timestamp object.
|
void |
SQLOutput.writeURL(URL
Writes a SQL
DATALINK value to the stream.
|
| Modifier and Type | Method and Description |
|---|---|
SQLException |
StatementEvent.getSQLException()
Returns the
SQLException the driver is about to throw
|
SQLException |
ConnectionEvent.getSQLException()
Retrieves the
SQLException for this
ConnectionEvent object.
|
| Modifier and Type | Method and Description |
|---|---|
void |
RowSet.clearParameters()
Clears the parameters set for this
RowSet object's command.
|
void |
PooledConnection.close()
Closes the physical connection that this
PooledConnection object represents.
|
void |
RowSet.execute()
Fills this
RowSet object with data.
|
Connection |
RowSetInternal.getConnection()
Retrieves the
Connection object that was passed to this
RowSet object.
|
Connection |
DataSource.getConnection()
Attempts to establish a connection with the data source that this
DataSource object represents.
|
Connection |
PooledConnection.getConnection()
Creates and returns a
Connection object that is a handle for the physical connection that this
PooledConnection object represents.
|
Connection |
DataSource.getConnection(String
Attempts to establish a connection with the data source that this
DataSource object represents.
|
boolean |
RowSet.getEscapeProcessing()
Retrieves whether escape processing is enabled for this
RowSet object.
|
int |
CommonDataSource.getLoginTimeout()
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.
|
PrintWriter |
CommonDataSource.getLogWriter()
Retrieves the log writer for this
DataSource object.
|
int |
RowSet.getMaxFieldSize()
Retrieves the maximum number of bytes that may be returned for certain column values.
|
int |
RowSet.getMaxRows()
Retrieves the maximum number of rows that this
RowSet object can contain.
|
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.
|
Object |
RowSetInternal.getParams()
Retrieves the parameters that have been set for this
RowSet object's command.
|
PooledConnection |
ConnectionPoolDataSource.getPooledConnection()
Attempts to establish a physical database connection that can be used as a pooled connection.
|
PooledConnection |
ConnectionPoolDataSource.getPooledConnection(String
Attempts to establish a physical database connection that can be used as a pooled connection.
|
int |
RowSet.getQueryTimeout()
Retrieves the maximum number of seconds the driver will wait for a statement to execute.
|
Map |
RowSet.getTypeMap()
Retrieves the
Map object associated with this
RowSet object, which specifies the custom mapping of SQL user-defined types, if any.
|
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.
|
XAConnection |
XADataSource.getXAConnection()
Attempts to establish a physical database connection that can be used in a distributed transaction.
|
XAConnection |
XADataSource.getXAConnection(String
Attempts to establish a physical database connection, using the given user name and password.
|
XAResource |
XAConnection.getXAResource()
Retrieves an
XAResource object that the transaction manager will use to manage this
XAConnection object's participation in a distributed transaction.
|
void |
RowSetReader.readData(RowSetInternal
Reads the new contents of the calling
RowSet object.
|
void |
RowSet.setArray(int i, Array
Sets the designated parameter in this
RowSet object's command with the given
Array value.
|
void |
RowSet.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given input stream.
|
void |
RowSet.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given
java.io.InputStream value.
|
void |
RowSet.setAsciiStream(String
Sets the designated parameter to the given input stream.
|
void |
RowSet.setAsciiStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
RowSetMetaData.setAutoIncrement(int columnIndex, boolean property)
Sets whether the designated column is automatically numbered, The default is for a
RowSet object's columns not to be automatically numbered.
|
void |
RowSet.setBigDecimal(int parameterIndex, BigDecimal
Sets the designated parameter in this
RowSet object's command to the given
java.math.BigDeciaml value.
|
void |
RowSet.setBigDecimal(String
Sets the designated parameter to the given
java.math.BigDecimal value.
|
void |
RowSet.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given input stream.
|
void |
RowSet.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given
java.io.InputStream value.
|
void |
RowSet.setBinaryStream(String
Sets the designated parameter to the given input stream.
|
void |
RowSet.setBinaryStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
RowSet.setBlob(int i, Blob
Sets the designated parameter in this
RowSet object's command with the given
Blob value.
|
void |
RowSet.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
RowSet.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
RowSet.setBlob(String
Sets the designated parameter to the given
java.sql.Blob object.
|
void |
RowSet.setBlob(String
Sets the designated parameter to a
InputStream object.
|
void |
RowSet.setBlob(String
Sets the designated parameter to a
InputStream object.
|
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.setBoolean(String
Sets the designated parameter 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.setByte(String
Sets the designated parameter to the given Java
byte 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.setBytes(String
Sets the designated parameter to the given Java array of bytes.
|
void |
RowSetMetaData.setCaseSensitive(int columnIndex, boolean property)
Sets whether the designated column is case sensitive.
|
void |
RowSetMetaData.setCatalogName(int columnIndex, String
Sets the designated column's table's catalog name, if any, to the given
String.
|
void |
RowSet.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter in this
RowSet object's command to the given
Reader object.
|
void |
RowSet.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter in this
RowSet object's command to the given
java.io.Reader value.
|
void |
RowSet.setCharacterStream(String
Sets the designated parameter to the given
Reader object.
|
void |
RowSet.setCharacterStream(String
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
void |
RowSet.setClob(int i, Clob
Sets the designated parameter in this
RowSet object's command with the given
Clob value.
|
void |
RowSet.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setClob(String
Sets the designated parameter to the given
java.sql.Clob object.
|
void |
RowSet.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
RowSetMetaData.setColumnCount(int columnCount)
Sets the number of columns in the
RowSet object to the given 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
Sets the suggested column title for use in printouts and displays, if any, to the given
String.
|
void |
RowSetMetaData.setColumnName(int columnIndex, String
Sets the name of the designated column 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
Sets the designated column's type name that is specific to the data source, if any, to the given
String.
|
void |
RowSet.setCommand(String
Sets this
RowSet object's command property to the given SQL query.
|
void |
RowSet.setConcurrency(int concurrency)
Sets the concurrency of this
RowSet object to the given concurrency level.
|
void |
RowSetMetaData.setCurrency(int columnIndex, boolean property)
Sets whether the designated column is a cash value.
|
void |
RowSet.setDataSourceName(String
Sets the data source name property for this
RowSet object to the given
String.
|
void |
RowSet.setDate(int parameterIndex, Date
Sets the designated parameter in this
RowSet object's command to the given
java.sql.Date value.
|
void |
RowSet.setDate(int parameterIndex, Date
Sets the designated parameter in this
RowSet object's command with the given
java.sql.Date value.
|
void |
RowSet.setDate(String
Sets the designated parameter to the given
java.sql.Date value using the default time zone of the virtual machine that is running the application.
|
void |
RowSet.setDate(String
Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object.
|
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.setDouble(String
Sets the designated parameter to the given Java
double value.
|
void |
RowSet.setEscapeProcessing(boolean enable)
Sets escape processing for this
RowSet object on or off.
|
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.setFloat(String
Sets the designated parameter to the given Java
float 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.setInt(String
Sets the designated parameter to the given Java
int value.
|
void |
CommonDataSource.setLoginTimeout(int seconds)
Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.
|
void |
CommonDataSource.setLogWriter(PrintWriter
Sets the log writer for this
DataSource object to the given
java.io.PrintWriter object.
|
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.setLong(String
Sets the designated parameter to the given Java
long value.
|
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.
|
void |
RowSet.setMaxRows(int max)
Sets the maximum number of rows that this
RowSet object can contain to the specified number.
|
void |
RowSetInternal.setMetaData(RowSetMetaData
Sets the given
RowSetMetaData object as the
RowSetMetaData object for this
RowSet object.
|
void |
RowSet.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter in this
RowSet object's command to a
Reader object.
|
void |
RowSet.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNClob(int parameterIndex, NClob
Sets the designated parameter to a
java.sql.NClob object.
|
void |
RowSet.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNClob(String
Sets the designated parameter to a
java.sql.NClob object.
|
void |
RowSet.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
RowSet.setNString(int parameterIndex, String
Sets the designated parameter to the given
String object.
|
void |
RowSet.setNString(String
Sets the designated parameter to the given
String object.
|
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
Sets the designated parameter in this
RowSet object's SQL command to SQL
NULL.
|
void |
RowSet.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
RowSet.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
RowSetMetaData.setNullable(int columnIndex, int property)
Sets whether the designated column's value can be set to
NULL.
|
void |
RowSet.setObject(int parameterIndex, Object
Sets the designated parameter in this
RowSet object's command with a Java
Object.
|
void |
RowSet.setObject(int parameterIndex, Object
Sets the designated parameter in this
RowSet object's command with a Java
Object.
|
void |
RowSet.setObject(int parameterIndex, Object
Sets the designated parameter in this
RowSet object's command with the given Java
Object.
|
void |
RowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
RowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
RowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
RowSet.setPassword(String
Sets the database password for this
RowSet object 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 |
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.setReadOnly(boolean value)
Sets whether this
RowSet object is read-only to the given
boolean.
|
void |
RowSet.setRef(int i, Ref
Sets the designated parameter in this
RowSet object's command with the given
Ref value.
|
void |
RowSet.setRowId(int parameterIndex, RowId
Sets the designated parameter to the given
java.sql.RowId object.
|
void |
RowSet.setRowId(String
Sets the designated parameter to the given
java.sql.RowId object.
|
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.setSchemaName(int columnIndex, String
Sets the name of the designated column's table's schema, if any, to the given
String.
|
void |
RowSetMetaData.setSearchable(int columnIndex, boolean property)
Sets whether the designated column can be used in a where clause.
|
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.setShort(String
Sets the designated parameter to the given Java
short value.
|
void |
RowSetMetaData.setSigned(int columnIndex, boolean property)
Sets whether the designated column is a signed number.
|
void |
RowSet.setSQLXML(int parameterIndex, SQLXML
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
RowSet.setSQLXML(String
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
RowSet.setString(int parameterIndex, String
Sets the designated parameter in this
RowSet object's command to the given Java
String value.
|
void |
RowSet.setString(String
Sets the designated parameter to the given Java
String value.
|
void |
RowSetMetaData.setTableName(int columnIndex, String
Sets the designated column's table name, if any, to the given
String.
|
void |
RowSet.setTime(int parameterIndex, Time
Sets the designated parameter in this
RowSet object's command to the given
java.sql.Time value.
|
void |
RowSet.setTime(int parameterIndex, Time
Sets the designated parameter in this
RowSet object's command with the given
java.sql.Time value.
|
void |
RowSet.setTime(String
Sets the designated parameter to the given
java.sql.Time value.
|
void |
RowSet.setTime(String
Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object.
|
void |
RowSet.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter in this
RowSet object's command to the given
java.sql.Timestamp value.
|
void |
RowSet.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter in this
RowSet object's command with the given
java.sql.Timestamp value.
|
void |
RowSet.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value.
|
void |
RowSet.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object.
|
void |
RowSet.setTransactionIsolation(int level)
Sets the transaction isolation level for this
RowSet object.
|
void |
RowSet.setType(int type)
Sets the type of this
RowSet object to the given type.
|
void |
RowSet.setTypeMap(Map
Installs the given
java.util.Map object as the default type map for this
RowSet object.
|
void |
RowSet.setURL(int parameterIndex, URL
Sets the designated parameter to the given
java.net.URL value.
|
void |
RowSet.setUrl(String
Sets the URL this
RowSet object will use when it uses the
DriverManager to create a connection.
|
void |
RowSet.setUsername(String
Sets the username property for this
RowSet object to the given
String.
|
boolean |
RowSetWriter.writeData(RowSetInternal
Writes the changes in this
RowSetWriter object's rowset back to the data source from which it got its data.
|
| Constructor and Description | |
|---|---|
ConnectionEvent(PooledConnection
Constructs a
ConnectionEvent object initialized with the given
PooledConnection object and
SQLException object.
|
|
StatementEvent(PooledConnection
Constructs a
StatementEvent with the specified
PooledConnection,
PreparedStatement and
SQLException
|
| Modifier and Type | Class and Description |
|---|---|
class |
RowSetWarning
An extension of
SQLException that provides information about database warnings set on
RowSet objects.
|
| Modifier and Type | Method and Description |
|---|---|
void |
JoinRowSet.addRowSet(Joinable
Adds the given
RowSet object to this
JoinRowSet object.
|
void |
JoinRowSet.addRowSet(RowSet
Adds one or more
RowSet objects contained in the given array of
RowSet objects to this
JoinRowSet object and sets the match column for each of the
RowSet objects to the match columns in the given array of column indexes.
|
void |
JoinRowSet.addRowSet(RowSet
Adds one or more
RowSet objects contained in the given array of
RowSet objects to this
JoinRowSet object and sets the match column for each of the
RowSet objects to the match columns in the given array of column names.
|
void |
JoinRowSet.addRowSet(RowSet
Adds the given
RowSet object to this
JoinRowSet object and sets the designated column as the match column for the
RowSet object.
|
void |
JoinRowSet.addRowSet(RowSet
Adds
rowset to this
JoinRowSet object and sets the designated column as the match column.
|
void |
BaseRowSet.clearParameters()
Clears all of the current parameter values in this
RowSet object's internal representation of the parameters to be set in this
RowSet object's command when it is executed.
|
boolean |
CachedRowSet.columnUpdated(int idx)
Indicates whether the designated column in the current row of this
CachedRowSet object has been updated.
|
boolean |
CachedRowSet.columnUpdated(String
Indicates whether the designated column in the current row of this
CachedRowSet object has been updated.
|
void |
CachedRowSet.commit()
Each
CachedRowSet object's
SyncProvider contains a
Connection object from the
ResultSet or JDBC properties passed to it's constructors.
|
void |
JdbcRowSet.commit()
Each
JdbcRowSet contains a
Connection object from the
ResultSet or JDBC properties passed to it's constructors.
|
CachedRowSet |
RowSetFactory.createCachedRowSet()
Creates a new instance of a CachedRowSet.
|
CachedRowSet |
CachedRowSet.createCopy()
Creates a
RowSet object that is a deep copy of the data in this
CachedRowSet object.
|
CachedRowSet |
CachedRowSet.createCopyNoConstraints()
Creates a
CachedRowSet object that is a deep copy of this
CachedRowSet object's data but is independent of it.
|
CachedRowSet |
CachedRowSet.createCopySchema()
Creates a
CachedRowSet object that is an empty copy of this
CachedRowSet object.
|
FilteredRowSet |
RowSetFactory.createFilteredRowSet()
Creates a new instance of a FilteredRowSet.
|
JdbcRowSet |
RowSetFactory.createJdbcRowSet()
Creates a new instance of a JdbcRowSet.
|
JoinRowSet |
RowSetFactory.createJoinRowSet()
Creates a new instance of a JoinRowSet.
|
RowSet |
CachedRowSet.createShared()
Returns a new
RowSet object backed by the same data as that of this
CachedRowSet object.
|
WebRowSet |
RowSetFactory.createWebRowSet()
Creates a new instance of a WebRowSet.
|
boolean |
Predicate.evaluate(Object
This method is called by a
FilteredRowSet object to check whether the value lies between the filtering criterion (or criteria if multiple constraints exist) set using the
setFilter() method.
|
boolean |
Predicate.evaluate(Object
This method is called by the
FilteredRowSet object to check whether the value lies between the filtering criteria set using the setFilter method.
|
void |
CachedRowSet.execute(Connection
Populates this
CachedRowSet object with data, using the given connection to produce the result set from which the data will be read.
|
boolean |
JdbcRowSet.getAutoCommit()
Each
JdbcRowSet contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
String |
RowSetMetaDataImpl.getCatalogName(int columnIndex)
Retrieves the catalog name of the table from which the value in the designated column was derived.
|
String |
RowSetMetaDataImpl.getColumnClassName(int columnIndex)
Retrieves the fully-qualified name of the class in the Java programming language to which a value in the designated column will be mapped.
|
int |
RowSetMetaDataImpl.getColumnCount()
Retrieves the number of columns in the
RowSet object for which this
RowSetMetaDataImpl object was created.
|
int |
RowSetMetaDataImpl.getColumnDisplaySize(int columnIndex)
Retrieves the normal maximum width in chars of the designated column.
|
String |
RowSetMetaDataImpl.getColumnLabel(int columnIndex)
Retrieves the the suggested column title for the designated column for use in printouts and displays.
|
String |
RowSetMetaDataImpl.getColumnName(int columnIndex)
Retrieves the name of the designated column.
|
int |
RowSetMetaDataImpl.getColumnType(int columnIndex)
Retrieves the type code (one of the
java.sql.Types constants) for the SQL type of the value stored in the designated column.
|
String |
RowSetMetaDataImpl.getColumnTypeName(int columnIndex)
Retrieves the DBMS-specific type name for values stored in the designated column.
|
int |
BaseRowSet.getConcurrency()
Returns the concurrency for this
RowSet object.
|
boolean |
BaseRowSet.getEscapeProcessing()
Ascertains whether escape processing is enabled for this
RowSet object.
|
int |
BaseRowSet.getFetchDirection()
Retrieves this
RowSet object's current setting for the fetch direction.
|
int |
BaseRowSet.getFetchSize()
Returns the fetch size for this
RowSet object.
|
int |
JoinRowSet.getJoinType()
Returns a
int describing the set SQL
JOIN type governing this JoinRowSet instance.
|
int[] |
CachedRowSet.getKeyColumns()
Returns an array containing one or more column numbers indicating the columns that form a key that uniquely identifies a row in this
CachedRowSet object.
|
int[] |
Joinable.getMatchColumnIndexes()
Retrieves the indexes of the match columns that were set for this
RowSet object with the method
setMatchColumn(int[] columnIdxes).
|
String |
Joinable.getMatchColumnNames()
Retrieves the names of the match columns that were set for this
RowSet object with the method
setMatchColumn(String [] columnNames).
|
int |
BaseRowSet.getMaxFieldSize()
Retrieves the maximum number of bytes that can be used for a column value in this
RowSet object.
|
int |
BaseRowSet.getMaxRows()
Retrieves the maximum number of rows that this
RowSet object may contain.
|
ResultSet |
CachedRowSet.getOriginal()
Returns a
ResultSet object containing the original value of this
CachedRowSet object.
|
ResultSet |
CachedRowSet.getOriginalRow()
Returns a
ResultSet object containing the original value for the current row only of this
CachedRowSet object.
|
Object |
BaseRowSet.getParams()
Retrieves an array containing the parameter values (both Objects and primitives) that have been set for this
RowSet object's command and throws an
SQLException object if all parameters have not been set.
|
int |
RowSetMetaDataImpl.getPrecision(int columnIndex)
Retrieves the total number of digits for values stored in the designated column.
|
int |
BaseRowSet.getQueryTimeout()
Retrieves the maximum number of seconds the driver will wait for a query to execute.
|
String |
JoinRowSet.getRowSetNames()
Returns a
String array containing the names of the
RowSet objects added to this
JoinRowSet object.
|
Collection |
JoinRowSet.getRowSets()
Returns a
Collection object containing the
RowSet objects that have been added to this
JoinRowSet object.
|
RowSetWarning |
CachedRowSet.getRowSetWarnings()
Retrieves the first warning reported by calls on this
RowSet object.
|
RowSetWarning |
JdbcRowSet.getRowSetWarnings()
Retrieves the first warning reported by calls on this
JdbcRowSet object.
|
int |
RowSetMetaDataImpl.getScale(int columnIndex)
Retrieves the number of digits to the right of the decimal point for values stored in the designated column.
|
String |
RowSetMetaDataImpl.getSchemaName(int columnIndex)
Retrieves the schema name of the table from which the value in the designated column was derived.
|
boolean |
CachedRowSet.getShowDeleted()
Retrieves a
boolean indicating whether rows marked for deletion appear in the set of current rows.
|
boolean |
BaseRowSet.getShowDeleted()
Retrieves a
boolean indicating whether rows marked for deletion appear in the set of current rows.
|
boolean |
JdbcRowSet.getShowDeleted()
Retrieves a
boolean indicating whether rows marked for deletion appear in the set of current rows.
|
SyncProvider |
CachedRowSet.getSyncProvider()
Retrieves the
SyncProvider implementation for this
CachedRowSet object.
|
String |
CachedRowSet.getTableName()
Returns an identifier for the object (table) that was used to create this
CachedRowSet object.
|
String |
RowSetMetaDataImpl.getTableName(int columnIndex)
Retrieves the name of the table from which the value in the designated column was derived.
|
int |
BaseRowSet.getType()
Returns the type of this
RowSet object.
|
String |
BaseRowSet.getUrl()
Retrieves the JDBC URL that this
RowSet object's
javax.sql.Reader object uses to make a connection with a relational database using a JDBC technology-enabled driver.
|
String |
JoinRowSet.getWhereClause()
Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.
|
boolean |
RowSetMetaDataImpl.isAutoIncrement(int columnIndex)
Retrieves whether a value stored in the designated column is automatically numbered, and thus readonly.
|
boolean |
RowSetMetaDataImpl.isCaseSensitive(int columnIndex)
Indicates whether the case of the designated column's name matters.
|
boolean |
RowSetMetaDataImpl.isCurrency(int columnIndex)
Indicates whether a value stored in the designated column is a cash value.
|
boolean |
RowSetMetaDataImpl.isDefinitelyWritable(int columnIndex)
Indicates whether a write operation on the designated column will definitely succeed.
|
int |
RowSetMetaDataImpl.isNullable(int columnIndex)
Retrieves a constant indicating whether it is possible to store a
NULL value in the designated column.
|
boolean |
RowSetMetaDataImpl.isReadOnly(int columnIndex)
Indicates whether the designated column is definitely not writable, thus readonly.
|
boolean |
RowSetMetaDataImpl.isSearchable(int columnIndex)
Indicates whether a value stored in the designated column can be used in a
WHERE clause.
|
boolean |
RowSetMetaDataImpl.isSigned(int columnIndex)
Indicates whether a value stored in the designated column is a signed number.
|
boolean |
RowSetMetaDataImpl.isWrapperFor(Class
Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
|
boolean |
RowSetMetaDataImpl.isWritable(int columnIndex)
Indicates whether it is possible for a write operation on the designated column to succeed.
|
static RowSetFactory |
RowSetProvider.newFactory()
Creates a new instance of a
RowSetFactory implementation.
|
static RowSetFactory |
RowSetProvider.newFactory(String
Creates a new instance of a
RowSetFactory from the specified factory class name.
|
boolean |
CachedRowSet.nextPage()
Increments the current page of the
CachedRowSet.
|
protected void |
BaseRowSet.notifyCursorMoved()
Notifies all of the listeners registered with this
RowSet object that its cursor has moved.
|
protected void |
BaseRowSet.notifyRowChanged()
Notifies all of the listeners registered with this
RowSet object that one of its rows has changed.
|
protected void |
BaseRowSet.notifyRowSetChanged()
Notifies all of the listeners registered with this
RowSet object that its entire contents have changed.
|
void |
CachedRowSet.populate(ResultSet
Populates this
CachedRowSet object with data from the given
ResultSet object.
|
void |
CachedRowSet.populate(ResultSet
Populates this
CachedRowSet object with data from the given
ResultSet object.
|
boolean |
CachedRowSet.previousPage()
Decrements the current page of the
CachedRowSet.
|
void |
WebRowSet.readXml(InputStream
Reads a stream based XML input to populate this
WebRowSet object.
|
void |
WebRowSet.readXml(Reader
Reads a
WebRowSet object in its XML format from the given
Reader object.
|
void |
CachedRowSet.release()
Releases the current contents of this
CachedRowSet object and sends a
rowSetChanged event to all registered listeners.
|
void |
CachedRowSet.restoreOriginal()
Restores this
CachedRowSet object to its original value, that is, its value before the last set of changes.
|
void |
CachedRowSet.rollback()
Each
CachedRowSet object's
SyncProvider contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
void |
JdbcRowSet.rollback()
Each
JdbcRowSet contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
void |
CachedRowSet.rollback(Savepoint
Each
CachedRowSet object's
SyncProvider contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
void |
JdbcRowSet.rollback(Savepoint
Each
JdbcRowSet contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
void |
CachedRowSet.rowSetPopulated(RowSetEvent
Notifies registered listeners that a RowSet object in the given RowSetEvent object has populated a number of additional rows.
|
void |
BaseRowSet.setArray(int parameterIndex, Array
Sets the designated parameter to an
Array object in the Java programming language.
|
void |
BaseRowSet.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given input stream.
|
void |
BaseRowSet.setAsciiStream(int parameterIndex, InputStream
Sets the designated parameter to the given
java.io.InputStream object, which will have the specified number of bytes.
|
void |
BaseRowSet.setAsciiStream(String
Sets the designated parameter to the given input stream.
|
void |
BaseRowSet.setAsciiStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
JdbcRowSet.setAutoCommit(boolean autoCommit)
Each
JdbcRowSet contains a
Connection object from the original
ResultSet or JDBC properties passed to it.
|
void |
RowSetMetaDataImpl.setAutoIncrement(int columnIndex, boolean property)
Sets whether the designated column is automatically numbered, thus read-only, to the given
boolean value.
|
void |
BaseRowSet.setBigDecimal(int parameterIndex, BigDecimal
Sets the designated parameter to the given
java.lang.BigDecimal value.
|
void |
BaseRowSet.setBigDecimal(String
Sets the designated parameter to the given
java.math.BigDecimal value.
|
void |
BaseRowSet.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter in this
RowSet object's command to the given input stream.
|
void |
BaseRowSet.setBinaryStream(int parameterIndex, InputStream
Sets the designated parameter to the given
java.io.InputStream object, which will have the specified number of bytes.
|
void |
BaseRowSet.setBinaryStream(String
Sets the designated parameter to the given input stream.
|
void |
BaseRowSet.setBinaryStream(String
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
|
void |
BaseRowSet.setBlob(int parameterIndex, Blob
Sets the designated parameter to the given
Blob object in the Java programming language.
|
void |
BaseRowSet.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
BaseRowSet.setBlob(int parameterIndex, InputStream
Sets the designated parameter to a
InputStream object.
|
void |
BaseRowSet.setBlob(String
Sets the designated parameter to the given
java.sql.Blob object.
|
void |
BaseRowSet.setBlob(String
Sets the designated parameter to a
InputStream object.
|
void |
BaseRowSet.setBlob(String
Sets the designated parameter to a
InputStream object.
|
void |
BaseRowSet.setBoolean(int parameterIndex, boolean x)
Sets the designated parameter to the given
boolean in the Java programming language.
|
void |
BaseRowSet.setBoolean(String
Sets the designated parameter to the given Java
boolean value.
|
void |
BaseRowSet.setByte(int parameterIndex, byte x)
Sets the designated parameter to the given
byte in the Java programming language.
|
void |
BaseRowSet.setByte(String
Sets the designated parameter to the given Java
byte value.
|
void |
BaseRowSet.setBytes(int parameterIndex, byte[] x)
Sets the designated parameter to the given array of bytes.
|
void |
BaseRowSet.setBytes(String
Sets the designated parameter to the given Java array of bytes.
|
void |
RowSetMetaDataImpl.setCaseSensitive(int columnIndex, boolean property)
Sets whether the name of the designated column is case sensitive to the given
boolean.
|
void |
RowSetMetaDataImpl.setCatalogName(int columnIndex, String
Sets the catalog name of the table from which the designated column was derived to
catalogName.
|
void |
BaseRowSet.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter in this
RowSet object's command to the given
Reader object.
|
void |
BaseRowSet.setCharacterStream(int parameterIndex, Reader
Sets the designated parameter to the given
java.io.Reader object, which will have the specified number of characters.
|
void |
BaseRowSet.setCharacterStream(String
Sets the designated parameter to the given
Reader object.
|
void |
BaseRowSet.setCharacterStream(String
Sets the designated parameter to the given
Reader object, which is the given number of characters long.
|
void |
BaseRowSet.setClob(int parameterIndex, Clob
Sets the designated parameter to the given
Clob object in the Java programming language.
|
void |
BaseRowSet.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setClob(String
Sets the designated parameter to the given
java.sql.Clob object.
|
void |
BaseRowSet.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setClob(String
Sets the designated parameter to a
Reader object.
|
void |
RowSetMetaDataImpl.setColumnCount(int columnCount)
Sets to the given number the number of columns in the
RowSet object for which this
RowSetMetaDataImpl object was created.
|
void |
RowSetMetaDataImpl.setColumnDisplaySize(int columnIndex, int size)
Sets the normal maximum number of chars in the designated column to the given number.
|
void |
RowSetMetaDataImpl.setColumnLabel(int columnIndex, String
Sets the suggested column label for use in printouts and displays, if any, to
label.
|
void |
RowSetMetaDataImpl.setColumnName(int columnIndex, String
Sets the column name of the designated column to the given name.
|
void |
RowSetMetaDataImpl.setColumnType(int columnIndex, int SQLType)
Sets the SQL type code for values stored in the designated column to the given type code from the class
java.sql.Types.
|
void |
RowSetMetaDataImpl.setColumnTypeName(int columnIndex, String
Sets the type name used by the data source for values stored in the designated column to the given type name.
|
void |
BaseRowSet.setCommand(String
Sets this
RowSet object's
command property to the given
String object and clears the parameters, if any, that were set for the previous command.
|
void |
BaseRowSet.setConcurrency(int concurrency)
Sets the concurrency for this
RowSet object to the specified concurrency.
|
void |
RowSetMetaDataImpl.setCurrency(int columnIndex, boolean property)
Sets whether a value stored in the designated column is a cash value to the given
boolean.
|
void |
BaseRowSet.setDataSourceName(String
Sets the
DataSource name property for this
RowSet object to the given logical name and sets this
RowSet object's Url property to
null.
|
void |
BaseRowSet.setDate(int parameterIndex, Date
Sets the designated parameter to the given
java.sql.Date value.
|
void |
BaseRowSet.setDate(int parameterIndex, Date
Sets the designated parameter to the given
java.sql.Date object.
|
void |
BaseRowSet.setDate(String
Sets the designated parameter to the given
java.sql.Date value using the default time zone of the virtual machine that is running the application.
|
void |
BaseRowSet.setDate(String
Sets the designated parameter to the given
java.sql.Date value, using the given
Calendar object.
|
void |
BaseRowSet.setDouble(int parameterIndex, double x)
Sets the designated parameter to the given
double in the Java programming language.
|
void |
BaseRowSet.setDouble(String
Sets the designated parameter to the given Java
double value.
|
void |
BaseRowSet.setEscapeProcessing(boolean enable)
Sets to the given
boolean whether or not the driver will scan for escape syntax and do escape substitution before sending SQL statements to the database.
|
void |
BaseRowSet.setFetchDirection(int direction)
Gives the driver a performance hint as to the direction in which the rows in this
RowSet object will be processed.
|
void |
BaseRowSet.setFetchSize(int rows)
Sets the fetch size for this
RowSet object to the given number of rows.
|
void |
FilteredRowSet.setFilter(Predicate
Applies the given
Predicate object to this
FilteredRowSet object.
|
void |
BaseRowSet.setFloat(int parameterIndex, float x)
Sets the designated parameter to the given
float in the Java programming language.
|
void |
BaseRowSet.setFloat(String
Sets the designated parameter to the given Java
float value.
|
void |
BaseRowSet.setInt(int parameterIndex, int x)
Sets the designated parameter to an
int in the Java programming language.
|
void |
BaseRowSet.setInt(String
Sets the designated parameter to the given Java
int value.
|
void |
JoinRowSet.setJoinType(int joinType)
Allow the application to adjust the type of
JOIN imposed on tables contained within the JoinRowSet object instance.
|
void |
CachedRowSet.setKeyColumns(int[] keys)
Sets this
CachedRowSet object's
keyCols field with the given array of column numbers, which forms a key for uniquely identifying a row in this
CachedRowSet object.
|
void |
BaseRowSet.setLong(int parameterIndex, long x)
Sets the designated parameter to the given
long in the Java programming language.
|
void |
BaseRowSet.setLong(String
Sets the designated parameter to the given Java
long value.
|
void |
Joinable.setMatchColumn(int columnIdx)
Sets the designated column as the match column for this
RowSet object.
|
void |
Joinable.setMatchColumn(int[] columnIdxes)
Sets the designated columns as the match column for this
RowSet object.
|
void |
Joinable.setMatchColumn(String
Sets the designated column as the match column for this
RowSet object.
|
void |
Joinable.setMatchColumn(String
Sets the designated columns as the match column for this
RowSet object.
|
void |
BaseRowSet.setMaxFieldSize(int max)
Sets the maximum number of bytes that can be used for a column value in this
RowSet object to the given number.
|
void |
BaseRowSet.setMaxRows(int max)
Sets the maximum number of rows that this
RowSet object may contain to the given number.
|
void |
CachedRowSet.setMetaData(RowSetMetaData
Sets the metadata for this
CachedRowSet object with the given
RowSetMetaData object.
|
void |
BaseRowSet.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter in this
RowSet object's command to a
Reader object.
|
void |
BaseRowSet.setNCharacterStream(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNCharacterStream(String
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNClob(int parameterIndex, NClob
Sets the designated parameter to a
java.sql.NClob object.
|
void |
BaseRowSet.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNClob(int parameterIndex, Reader
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNClob(String
Sets the designated parameter to a
java.sql.NClob object.
|
void |
BaseRowSet.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNClob(String
Sets the designated parameter to a
Reader object.
|
void |
BaseRowSet.setNString(int parameterIndex, String
Sets the designated parameter to the given
String object.
|
void |
BaseRowSet.setNString(String
Sets the designated parameter to the given
String object.
|
void |
BaseRowSet.setNull(int parameterIndex, int sqlType)
Sets the designated parameter to SQL
NULL.
|
void |
BaseRowSet.setNull(int parameterIndex, int sqlType, String
Sets the designated parameter to SQL
NULL.
|
void |
BaseRowSet.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
BaseRowSet.setNull(String
Sets the designated parameter to SQL
NULL.
|
void |
RowSetMetaDataImpl.setNullable(int columnIndex, int property)
Sets whether a value stored in the designated column can be set to
NULL to the given constant from the interface
ResultSetMetaData.
|
void |
BaseRowSet.setObject(int parameterIndex, Object
Sets the designated parameter to an
Object in the Java programming language.
|
void |
BaseRowSet.setObject(int parameterIndex, Object
Sets the value of the designated parameter with the given
Object value.
|
void |
BaseRowSet.setObject(int parameterIndex, Object
Sets the designated parameter to an
Object in the Java programming language.
|
void |
BaseRowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
BaseRowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
BaseRowSet.setObject(String
Sets the value of the designated parameter with the given object.
|
void |
CachedRowSet.setOriginalRow()
Sets the current row in this
CachedRowSet object as the original row.
|
void |
CachedRowSet.setPageSize(int size)
Sets the
CachedRowSet object's page-size.
|
void |
RowSetMetaDataImpl.setPrecision(int columnIndex, int precision)
Sets the total number of decimal digits in a value stored in the designated column to the given number.
|
void |
BaseRowSet.setQueryTimeout(int seconds)
Sets to the given number the maximum number of seconds the driver will wait for a query to execute.
|
void |
BaseRowSet.setRef(int parameterIndex, Ref
Sets the designated parameter to the given
Ref object in the Java programming language.
|
void |
BaseRowSet.setRowId(int parameterIndex, RowId
Sets the designated parameter to the given
java.sql.RowId object.
|
void |
BaseRowSet.setRowId(String
Sets the designated parameter to the given
java.sql.RowId object.
|
void |
RowSetMetaDataImpl.setScale(int columnIndex, int scale)
Sets the number of digits to the right of the decimal point in a value stored in the designated column to the given number.
|
void |
RowSetMetaDataImpl.setSchemaName(int columnIndex, String
Sets the designated column's table's schema name, if any, to
schemaName.
|
void |
RowSetMetaDataImpl.setSearchable(int columnIndex, boolean property)
Sets whether a value stored in the designated column can be used in a
WHERE clause to the given
boolean value.
|
void |
BaseRowSet.setShort(int parameterIndex, short x)
Sets the designated parameter to the given
short in the Java programming language.
|
void |
BaseRowSet.setShort(String
Sets the designated parameter to the given Java
short value.
|
void |
CachedRowSet.setShowDeleted(boolean b)
Sets the property
showDeleted to the given
boolean value, which determines whether rows marked for deletion appear in the set of current rows.
|
void |
BaseRowSet.setShowDeleted(boolean value)
Sets the property
showDeleted to the given
boolean value, which determines whether rows marked for deletion appear in the set of current rows.
|
void |
JdbcRowSet.setShowDeleted(boolean b)
Sets the property
showDeleted to the given
boolean value.
|
void |
RowSetMetaDataImpl.setSigned(int columnIndex, boolean property)
Sets whether a value stored in the designated column is a signed number to the given
boolean.
|
void |
BaseRowSet.setSQLXML(int parameterIndex, SQLXML
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
BaseRowSet.setSQLXML(String
Sets the designated parameter to the given
java.sql.SQLXML object.
|
void |
BaseRowSet.setString(int parameterIndex, String
Sets the designated parameter to the given
String value.
|
void |
BaseRowSet.setString(String
Sets the designated parameter to the given Java
String value.
|
void |
CachedRowSet.setSyncProvider(String
Sets the
SyncProvider object for this
CachedRowSet object to the one specified.
|
void |
RowSetMetaDataImpl.setTableName(int columnIndex, String
Sets the name of the table from which the designated column was derived to the given table name.
|
void |
CachedRowSet.setTableName(String
Sets the identifier for the table from which this
CachedRowSet object was derived to the given table name.
|
void |
BaseRowSet.setTime(int parameterIndex, Time
Sets the designated parameter to the given
java.sql.Time value.
|
void |
BaseRowSet.setTime(int parameterIndex, Time
Sets the designated parameter to the given
java.sql.Time object.
|
void |
BaseRowSet.setTime(String
Sets the designated parameter to the given
java.sql.Time value.
|
void |
BaseRowSet.setTime(String
Sets the designated parameter to the given
java.sql.Time value, using the given
Calendar object.
|
void |
BaseRowSet.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter to the given
java.sql.Timestamp value.
|
void |
BaseRowSet.setTimestamp(int parameterIndex, Timestamp
Sets the designated parameter to the given
java.sql.Timestamp object.
|
void |
BaseRowSet.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value.
|
void |
BaseRowSet.setTimestamp(String
Sets the designated parameter to the given
java.sql.Timestamp value, using the given
Calendar object.
|
void |
BaseRowSet.setTransactionIsolation(int level)
Sets the transaction isolation property for this JDBC
RowSet object to the given constant.
|
void |
BaseRowSet.setType(int type)
Sets the type for this
RowSet object to the specified type.
|
void |
BaseRowSet.setUnicodeStream(int parameterIndex, InputStream
Deprecated.
getCharacterStream should be used in its place
|
void |
BaseRowSet.setURL(int parameterIndex, URL
Sets the designated parameter to the given
java.net.URL value.
|
void |
BaseRowSet.setUrl(String
Sets the Url property for this
RowSet object to the given
String object and sets the dataSource name property to
null.
|
CachedRowSet |
JoinRowSet.toCachedRowSet()
Creates a new
CachedRowSet object containing the data in this
JoinRowSet object, which can be saved to a data source using the
SyncProvider object for the
CachedRowSet object.
|
Collection |
CachedRowSet.toCollection()
Converts this
CachedRowSet object to a
Collection object that contains all of this
CachedRowSet object's data.
|
Collection |
CachedRowSet.toCollection(int column)
Converts the designated column in this
CachedRowSet object to a
Collection object.
|
Collection |
CachedRowSet.toCollection(String
Converts the designated column in this
CachedRowSet object to a
Collection object.
|
void |
CachedRowSet.undoDelete()
Cancels the deletion of the current row and notifies listeners that a row has changed.
|
void |
CachedRowSet.undoInsert()
Immediately removes the current row from this
CachedRowSet object if the row has been inserted, and also notifies listeners that a row has changed.
|
void |
CachedRowSet.undoUpdate()
Immediately reverses the last update operation if the row has been modified.
|
void |
Joinable.unsetMatchColumn(int columnIdx)
Unsets the designated column as the match column for this
RowSet object.
|
void |
Joinable.unsetMatchColumn(int[] columnIdxes)
Unsets the designated columns as the match column for this
RowSet object.
|
void |
Joinable.unsetMatchColumn(String
Unsets the designated column as the match column for this
RowSet object.
|
void |
Joinable.unsetMatchColumn(String
Unsets the designated columns as the match columns for this
RowSet object.
|
<T> T |
RowSetMetaDataImpl.unwrap(Class
Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
|
void |
WebRowSet.writeXml(OutputStream
Writes the data, properties, and metadata for this
WebRowSet object to the given
OutputStream object in XML format.
|
void |
WebRowSet.writeXml(ResultSet
Populates this
WebRowSet object with the contents of the given
ResultSet object and writes its data, properties, and metadata to the given
OutputStream object in XML format.
|
void |
WebRowSet.writeXml(ResultSet
Populates this
WebRowSet object with the contents of the given
ResultSet object and writes its data, properties, and metadata to the given
Writer object in XML format.
|
void |
WebRowSet.writeXml(Writer
Writes the data, properties, and metadata for this
WebRowSet object to the given
Writer object in XML format.
|
| Modifier and Type | Class and Description |
|---|---|
class |
SerialException
Indicates and an error with the serialization or de-serialization of SQL types such as
BLOB, CLOB, STRUCT or ARRAY in addition to SQL types such as
DATALINK and JAVAOBJECT
|
| Modifier and Type | Method and Description |
|---|---|
void |
SerialArray.free()
This method frees the
SeriableArray object and releases the resources that it holds.
|
void |
SerialClob.free()
This method frees the
SeriableClob object and releases the resources that it holds.
|
void |
SerialBlob.free()
This method frees the
SeriableBlob object and releases the resources that it holds.
|
InputStream |
SerialClob.getAsciiStream()
Retrieves the
CLOB value designated by this
SerialClob object as an ascii stream.
|
InputStream |
SerialBlob.getBinaryStream(long pos, long length)
Returns an
InputStream object that contains a partial
Blob value, starting with the byte specified by pos, which is length bytes in length.
|
Reader |
SerialClob.getCharacterStream(long pos, long length)
Returns a
Reader object that contains a partial
SerialClob value, starting with the character specified by pos, which is length characters in length.
|
long |
SerialBlob.position(Blob
Returns the position in this
SerialBlob object where the given
Blob object begins, starting the search at the specified position.
|
long |
SerialBlob.position(byte[] pattern, long start)
Returns the position in this
SerialBlob object where the given pattern of bytes begins, starting the search at the specified position.
|
long |
SerialClob.position(Clob
Returns the position in this
SerialClob object where the given
Clob signature begins, starting the search at the specified position.
|
long |
SerialClob.position(String
Returns the position in this
SerialClob object where the given
String object begins, starting the search at the specified position.
|
Array |
SQLInputImpl.readArray()
Reads an SQL
ARRAY value from the stream and returns it as an
Array object in the Java programming language.
|
InputStream |
SQLInputImpl.readAsciiStream()
Returns the next attribute in this
SQLInputImpl object as a stream of ASCII characters.
|
BigDecimal |
SQLInputImpl.readBigDecimal()
Retrieves the next attribute in this
SQLInputImpl object as a
java.math.BigDecimal.
|
InputStream |
SQLInputImpl.readBinaryStream()
Returns the next attribute in this
SQLInputImpl object as a stream of uninterpreted bytes.
|
Blob |
SQLInputImpl.readBlob()
Retrieves the
BLOB value at the head of this
SQLInputImpl object as a
Blob object in the Java programming language.
|
boolean |
SQLInputImpl.readBoolean()
Retrieves the next attribute in this
SQLInputImpl object as a
boolean in the Java programming language.
|
byte |
SQLInputImpl.readByte()
Retrieves the next attribute in this
SQLInputImpl object as a
byte in the Java programming language.
|
byte[] |
SQLInputImpl.readBytes()
Retrieves the next attribute in this
SQLInputImpl object as an array of bytes.
|
Reader |
SQLInputImpl.readCharacterStream()
Retrieves the next attribute in this
SQLInputImpl object as a stream of Unicode characters.
|
Clob |
SQLInputImpl.readClob()
Retrieves the
CLOB value at the head of this
SQLInputImpl object as a
Clob object in the Java programming language.
|
Date |
SQLInputImpl.readDate()
Retrieves the next attribute in this
SQLInputImpl as a
java.sql.Date object.
|
double |
SQLInputImpl.readDouble()
Retrieves the next attribute in this
SQLInputImpl object as a
double in the Java programming language.
|
float |
SQLInputImpl.readFloat()
Retrieves the next attribute in this
SQLInputImpl object as a
float in the Java programming language.
|
int |
SQLInputImpl.readInt()
Retrieves the next attribute in this
SQLInputImpl object as an
int in the Java programming language.
|
long |
SQLInputImpl.readLong()
Retrieves the next attribute in this
SQLInputImpl object as a
long in the Java programming language.
|
NClob |
SQLInputImpl.readNClob()
Reads an SQL
NCLOB value from the stream and returns it as a
Clob object in the Java programming language.
|
String |
SQLInputImpl.readNString()
Reads the next attribute in the stream and returns it as a
String in the Java programming language.
|
Object |
SQLInputImpl.readObject()
Retrieves the value at the head of this
SQLInputImpl object as an
Object in the Java programming language.
|
Ref |
SQLInputImpl.readRef()
Retrieves the value at the head of this
SQLInputImpl object as a
Ref object in the Java programming language.
|
RowId |
SQLInputImpl.readRowId()
Reads an SQL
ROWID value from the stream and returns it as a
RowId object in the Java programming language.
|
short |
SQLInputImpl.readShort()
Retrieves the next attribute in this
SQLInputImpl object as a
short in the Java programming language.
|
SQLXML |
SQLInputImpl.readSQLXML()
Reads an SQL
XML value from the stream and returns it as a
SQLXML object in the Java programming language.
|
String |
SQLInputImpl.readString()
Retrieves the next attribute in this
SQLInputImpl object as a
String in the Java programming language.
|
Time |
SQLInputImpl.readTime()
Retrieves the next attribute in this
SQLInputImpl object as a
java.sql.Time object.
|
Timestamp |
SQLInputImpl.readTimestamp()
Retrieves the next attribute in this
SQLInputImpl object as a
java.sql.Timestamp object.
|
URL |
SQLInputImpl.readURL()
Reads an SQL
DATALINK value from the stream and returns it as an
URL object in the Java programming language.
|
OutputStream |
SerialClob.setAsciiStream(long pos)
Retrieves a stream to be used to write Ascii characters to the
CLOB value that this
SerialClob object represents, starting at position
pos.
|
OutputStream |
SerialBlob.setBinaryStream(long pos)
Retrieves a stream that can be used to write to the
BLOB value that this
Blob object represents.
|
int |
SerialBlob.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 |
SerialBlob.setBytes(long pos, byte[] bytes, int offset, int length)
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.
|
Writer |
SerialClob.setCharacterStream(long pos)
Retrieves a stream to be used to write a stream of Unicode characters to the
CLOB value that this
SerialClob object represents, at position
pos.
|
boolean |
SQLInputImpl.wasNull()
Ascertains whether the last value read from this
SQLInputImpl object was
null.
|
void |
SQLOutputImpl.writeArray(Array
Writes an
Array object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeAsciiStream(InputStream
Writes a stream of ASCII characters to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeBigDecimal(BigDecimal
Writes a
java.math.BigDecimal object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeBinaryStream(InputStream
Writes a stream of uninterpreted bytes to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeBlob(Blob
Writes a
Blob object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeBoolean(boolean x)
Writes a
boolean in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeByte(byte x)
Writes a
byte in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeBytes(byte[] x)
Writes an array of
bytes in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeCharacterStream(Reader
Writes a stream of Unicode characters to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeClob(Clob
Writes a
Clob object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeDate(Date
Writes a
java.sql.Date object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeDouble(double x)
Writes a
double in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeFloat(float x)
Writes a
float in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeInt(int x)
Writes an
int in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeLong(long x)
Writes a
long in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeNClob(NClob
Writes an SQL
NCLOB value to the stream.
|
void |
SQLOutputImpl.writeNString(String
Writes the next attribute to the stream as a
String in the Java programming language.
|
void |
SQLOutputImpl.writeObject(SQLData
Writes to the stream the data contained in the given
SQLData object.
|
void |
SQLOutputImpl.writeRef(Ref
Writes a
Ref object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeRowId(RowId
Writes an SQL
ROWID value to the stream.
|
void |
SQLOutputImpl.writeShort(short x)
Writes a
short in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeSQLXML(SQLXML
Writes an SQL
XML value to the stream.
|
void |
SQLOutputImpl.writeString(String
Writes a
String in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeStruct(Struct
Writes a
Struct object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeTime(Time
Writes a
java.sql.Time object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeTimestamp(Timestamp
Writes a
java.sql.Timestamp object in the Java programming language to this
SQLOutputImpl object.
|
void |
SQLOutputImpl.writeURL(URL
Writes an
java.sql.Type.DATALINK object in the Java programming language to this
SQLOutputImpl object.
|
| Constructor and Description | |
|---|---|
SerialArray(Array
Constructs a new
SerialArray object from the given
Array object.
|
|
SerialArray(Array
Constructs a new
SerialArray object from the given
Array object, using the given type map for the custom mapping of each element when the elements are SQL UDTs.
|
|
SerialBlob(Blob
Constructs a
SerialBlob object that is a serialized version of the given
Blob object.
|
|
SerialBlob(byte[] b)
Constructs a
SerialBlob object that is a serialized version of the given
byte array.
|
|
SerialClob(char[] ch)
Constructs a
SerialClob object that is a serialized version of the given
char array.
|
|
SerialClob(Clob
Constructs a
SerialClob object that is a serialized version of the given
Clob object.
|
|
SerialRef(Ref
Constructs a
SerialRef object from the given
Ref object.
|
|
SQLInputImpl(Object
Creates an
SQLInputImpl object initialized with the given array of attributes and the given type map.
|
|
SQLOutputImpl(Vector
Creates a new
SQLOutputImpl object initialized with the given vector of attributes and type map.
|
| Modifier and Type | Class and Description |
|---|---|
class |
SyncFactoryException
Indicates an error with
SyncFactory mechanism.
|
class |
SyncProviderException
Indicates an error with the
SyncProvider mechanism.
|
| Modifier and Type | Method and Description |
|---|---|
void |
TransactionalWriter.commit()
Makes permanent all changes that have been performed by the
acceptChanges method since the last call to either the
commit or
rollback methods.
|
Object |
SyncResolver.getConflictValue(int index)
Retrieves the value in the designated column in the current row of this
SyncResolver object, which is the value in the data source that caused a conflict.
|
Object |
SyncResolver.getConflictValue(String
Retrieves the value in the designated column in the current row of this
SyncResolver object, which is the value in the data source that caused a conflict.
|
boolean |
SyncResolver.nextConflict()
Moves the cursor down from its current position to the next row that contains a conflict value.
|
boolean |
SyncResolver.previousConflict()
Moves the cursor up from its current position to the previous conflict row in this
SyncResolver object.
|
void |
XmlReader.readXML(WebRowSet
Reads and parses the given
WebRowSet object from the given input stream in XML format.
|
void |
TransactionalWriter.rollback()
Undoes all changes made in the current transaction.
|
void |
TransactionalWriter.rollback(Savepoint
Undoes all changes made in the current transaction made prior to the given
Savepoint object.
|
void |
SyncResolver.setResolvedValue(int index, Object
Sets
obj as the value in column
index in the current row of the
RowSet object that is being synchronized.
|
void |
SyncResolver.setResolvedValue(String
Sets
obj as the value in column
columnName in the current row of the
RowSet object that is being synchronized.
|
void |
XmlWriter.writeXML(WebRowSet
Writes the given
WebRowSet object to the specified
java.io.Writer output stream as an XML document.
|