| Package | Description |
|---|---|
| java.sql |
Provides the API for accessing and processing data stored in a
data source (usually a relational database) using the
JavaTM programming language.
|
| javax.sql |
Provides the API for server side data source access and processing from
the JavaTM programming language.
|
| 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 ex)
Adds an
SQLException object to the end of the chain. |
| Modifier and Type | Method and Description |
|---|---|
void |
Connection.abort(Executor 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 url)
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 sql)
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 |
ResultSet.clearWarnings()
Clears all warnings reported on this
ResultSet object. |
void |
Connection.clearWarnings()
Clears all warnings reported for this
Connection object. |
void |
Statement.clearWarnings()
Clears all the warnings reported on this
Statement
object. |
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 |
Connection.close()
Releases this
Connection object's database and JDBC resources
immediately instead of waiting for them to be automatically released. |
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 url,
Properties info)
Attempts to make a database connection to the given URL.
|
Array |
Connection.createArrayOf(String typeName,
Object[] elements)
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 typeName,
Object[] attributes)
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 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 sql)
Executes the given SQL statement, which may return multiple results.
|
boolean |
Statement.execute(String sql,
int autoGeneratedKeys)
Executes the given SQL statement, which may return multiple results,
and signals the driver that any
auto-generated keys should be made available
for retrieval.
|
boolean |
Statement.execute(String sql,
int[] columnIndexes)
Executes the given SQL statement, which may return multiple results,
and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
boolean |
Statement.execute(String sql,
String[] columnNames)
Executes the given SQL statement, which may return multiple results,
and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
int[] |
Statement.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 sql)
Executes the given SQL statement, which may be an
INSERT ,
UPDATE , or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement. |
default long |
Statement.executeLargeUpdate(String sql,
int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the
given flag about whether the
auto-generated keys produced by this
Statement object
should be made available for retrieval. |
default long |
Statement.executeLargeUpdate(String sql,
int[] columnIndexes)
Executes the given SQL statement and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
default long |
Statement.executeLargeUpdate(String sql,
String[] columnNames)
Executes the given SQL statement and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
ResultSet |
PreparedStatement.executeQuery()
Executes the SQL query in this
PreparedStatement object
and returns the ResultSet object generated by the query. |
ResultSet |
Statement.executeQuery(String sql)
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 sql)
Executes the given SQL statement, which may be an
INSERT ,
UPDATE , or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement. |
int |
Statement.executeUpdate(String sql,
int autoGeneratedKeys)
Executes the given SQL statement and signals the driver with the
given flag about whether the
auto-generated keys produced by this
Statement object
should be made available for retrieval. |
int |
Statement.executeUpdate(String sql,
int[] columnIndexes)
Executes the given SQL statement and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
int |
Statement.executeUpdate(String sql,
String[] columnNames)
Executes the given SQL statement and signals the driver that the
auto-generated keys indicated in the given array should be made available
for retrieval.
|
int |
ResultSet.findColumn(String columnLabel)
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 |
Array.free()
This method frees the
Array object and releases the resources that
it holds. |
void |
SQLXML.free()
This method closes this object and releases the resources that it held.
|
void |
Clob.free()
This method frees the
Clob object and releases the resources the resources
that it holds. |
void |
Blob.free()
This method frees the
Blob 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<String,Class<?>> 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<String,Class<?>> map)
Retrieves the contents of the SQL
ARRAY value designated by this
Array object. |
Array |
ResultSet.getArray(String columnLabel)
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 parameterName)
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 columnLabel)
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<String,Class<?>> map)
Produces the ordered values of the attributes of the SQL
structured type that this
Struct object represents. |
ResultSet |
DatabaseMetaData.getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
Retrieves a description of the given attribute of the given type
for a user-defined type (UDT) that is available in the given schema
and catalog.
|
boolean |
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 |
Array.getBaseTypeName()
Retrieves the SQL type name 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. |
ResultSet |
DatabaseMetaData.getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable)
Retrieves a description of a table's optimal set of columns that
uniquely identifies a row.
|
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 columnLabel)
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 parameterName)
Retrieves the value of a JDBC
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
BigDecimal |
ResultSet.getBigDecimal(String columnLabel,
int scale)
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 columnLabel)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a stream of uninterpreted
byte s. |
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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 |
SQLXML.getCharacterStream()
Retrieves the XML value designated by this SQLXML instance as a java.io.Reader object.
|
Reader |
Clob.getCharacterStream()
Retrieves the
CLOB value designated by this Clob
object as a java.io.Reader object (or as a stream of
characters). |
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 columnLabel)
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 parameterName)
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 name)
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 columnLabel)
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 parameterName)
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 catalog,
String schema,
String table,
String columnNamePattern)
Retrieves a description of the access rights for a table's columns.
|
ResultSet |
DatabaseMetaData.getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
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 url)
Attempts to establish a connection to the given database URL.
|
static Connection |
DriverManager.getConnection(String url,
Properties info)
Attempts to establish a connection to the given database URL.
|
static Connection |
DriverManager.getConnection(String url,
String user,
String password)
Attempts to establish a connection to the given database URL.
|
ResultSet |
DatabaseMetaData.getCrossReference(String parentCatalog,
String parentSchema,
String parentTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Retrieves a description of the foreign key columns in the given foreign key
table that reference the primary key 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 cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
CallableStatement.getDate(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
Date |
ResultSet.getDate(String columnLabel)
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 parameterName)
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object. |
Date |
ResultSet.getDate(String columnLabel,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Date object
in the Java programming language. |
Date |
CallableStatement.getDate(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
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 columnLabel)
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 parameterName)
Retrieves the value of a JDBC
DOUBLE parameter as a double
in the Java programming language. |
static Driver |
DriverManager.getDriver(String url)
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 catalog,
String schema,
String table)
Retrieves a description of the foreign key columns that reference the
given table's primary key columns (the foreign keys exported by a
table).
|
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 columnLabel)
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 parameterName)
Retrieves the value of a JDBC
FLOAT parameter as a float
in the Java programming language. |
ResultSet |
DatabaseMetaData.getFunctionColumns(String catalog,
String schemaPattern,
String functionNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's system or user
function parameters and return type.
|
ResultSet |
DatabaseMetaData.getFunctions(String catalog,
String schemaPattern,
String functionNamePattern)
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 |
ResultSet.getHoldability()
Retrieves the holdability of this
ResultSet object |
int |
Connection.getHoldability()
Retrieves the current holdability of
ResultSet objects
created using this Connection object. |
String |
DatabaseMetaData.getIdentifierQuoteString()
Retrieves the string used to quote SQL identifiers.
|
ResultSet |
DatabaseMetaData.getImportedKeys(String catalog,
String schema,
String table)
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 catalog,
String schema,
String table,
boolean unique,
boolean approximate)
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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.
|
ResultSetMetaData |
ResultSet.getMetaData()
Retrieves the number, types and properties of
this
ResultSet object's columns. |
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. |
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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<T> type)
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<T> type)
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<String,Class<?>> 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<String,Class<?>> 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<String,Class<?>> map)
Retrieves the referenced object and maps it to a Java type
using the given type map.
|
Object |
ResultSet.getObject(String columnLabel)
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 parameterName)
Retrieves the value of a parameter as an
Object in the Java
programming language. |
<T> T |
ResultSet.getObject(String columnLabel,
Class<T> type)
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 parameterName,
Class<T> type)
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 columnLabel,
Map<String,Class<?>> 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(String parameterName,
Map<String,Class<?>> map)
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 catalog,
String schema,
String table)
Retrieves a description of the given table's primary key columns.
|
ResultSet |
DatabaseMetaData.getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern)
Retrieves a description of the given catalog's stored procedure parameter
and result columns.
|
ResultSet |
DatabaseMetaData.getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern)
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 url,
Properties info)
Gets information about the possible properties for this driver.
|
ResultSet |
DatabaseMetaData.getPseudoColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern)
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 columnLabel)
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 parameterName)
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<String,Class<?>> 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<String,Class<?>> 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 columnLabel)
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 parameterName)
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 catalog,
String schemaPattern)
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 columnLabel)
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 parameterName)
Retrieves the value of a JDBC
SMALLINT parameter as a short
in the Java programming language. |
<T extends Source> |
SQLXML.getSource(Class<T> sourceClass)
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 |
Struct.getSQLTypeName()
Retrieves the SQL type name of the SQL structured type
that this
Struct object represents. |
String |
SQLData.getSQLTypeName()
Returns the fully-qualified
name of the SQL user-defined type that this 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 columnLabel)
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 parameterName)
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 columnLabel)
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 parameterName)
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 catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the table hierarchies defined in a particular
schema in this database.
|
ResultSet |
DatabaseMetaData.getSuperTypes(String catalog,
String schemaPattern,
String typeNamePattern)
Retrieves a description of the user-defined type (UDT) hierarchies defined in a
particular schema in this database.
|
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 catalog,
String schemaPattern,
String tableNamePattern)
Retrieves a description of the access rights for each table available
in a catalog.
|
ResultSet |
DatabaseMetaData.getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
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 cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Time object
in the Java programming language. |
Time |
CallableStatement.getTime(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
Time |
ResultSet.getTime(String columnLabel)
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 parameterName)
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object. |
Time |
ResultSet.getTime(String columnLabel,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Time object
in the Java programming language. |
Time |
CallableStatement.getTime(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
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 cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
CallableStatement.getTimestamp(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
Timestamp |
ResultSet.getTimestamp(String columnLabel)
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 parameterName)
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object. |
Timestamp |
ResultSet.getTimestamp(String columnLabel,
Calendar cal)
Retrieves the value of the designated column in the current row
of this
ResultSet object as a java.sql.Timestamp object
in the Java programming language. |
Timestamp |
CallableStatement.getTimestamp(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
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<String,Class<?>> |
Connection.getTypeMap()
Retrieves the
Map object associated with this
Connection object. |
ResultSet |
DatabaseMetaData.getUDTs(String catalog,
String schemaPattern,
String typeNamePattern,
int[] types)
Retrieves a description of the user-defined types (UDTs) defined
in a particular schema.
|
InputStream |
ResultSet.getUnicodeStream(int columnIndex)
Deprecated.
use
getCharacterStream in place of
getUnicodeStream |
InputStream |
ResultSet.getUnicodeStream(String columnLabel)
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 columnLabel)
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 parameterName)
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 catalog,
String schema,
String table)
Retrieves a description of a table's columns that are automatically
updated when any value in a row is updated.
|
SQLWarning |
ResultSet.getWarnings()
Retrieves the first warning reported by calls on this
ResultSet object. |
SQLWarning |
Connection.getWarnings()
Retrieves the first warning reported by calls on this
Connection 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 |
ResultSet.isClosed()
Retrieves whether this
ResultSet object has been closed. |
boolean |
Connection.isClosed()
Retrieves whether this
Connection 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<?> iface)
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 sql)
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 pattern,
long start)
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 searchstr,
long start)
Retrieves the character position at which the specified
Clob object searchstr appears in this
Clob object. |
long |
Clob.position(String searchstr,
long start)
Retrieves the character position at which the specified substring
searchstr appears in the SQL CLOB value
represented by this Clob object. |
CallableStatement |
Connection.prepareCall(String sql)
Creates a
CallableStatement object for calling
database stored procedures. |
CallableStatement |
Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency)
Creates a
CallableStatement object that will generate
ResultSet objects with the given type and concurrency. |
CallableStatement |
Connection.prepareCall(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a
CallableStatement object that will generate
ResultSet objects with the given type and concurrency. |
PreparedStatement |
Connection.prepareStatement(String sql)
Creates a
PreparedStatement object for sending
parameterized SQL statements to the database. |
PreparedStatement |
Connection.prepareStatement(String sql,
int autoGeneratedKeys)
Creates a default
PreparedStatement object that has
the capability to retrieve auto-generated keys. |
PreparedStatement |
Connection.prepareStatement(String sql,
int[] columnIndexes)
Creates a default
PreparedStatement object capable
of returning the auto-generated keys designated by the given array. |
PreparedStatement |
Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
Creates a
PreparedStatement object that will generate
ResultSet objects with the given type and concurrency. |
PreparedStatement |
Connection.prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a
PreparedStatement object that will generate
ResultSet objects with the given type, concurrency,
and holdability. |
PreparedStatement |
Connection.prepareStatement(String sql,
String[] columnNames)
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<T> type)
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 stream,
String typeName)
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 driver)
Registers the given driver with the
DriverManager . |
static void |
DriverManager.registerDriver(Driver driver,
DriverAction da)
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 typeName)
Registers the designated output parameter.
|
default void |
CallableStatement.registerOutParameter(int parameterIndex,
SQLType sqlType)
Registers the OUT parameter in ordinal position
parameterIndex to the JDBC type
sqlType . |
default void |
CallableStatement.registerOutParameter(int parameterIndex,
SQLType sqlType,
int scale)
Registers the parameter in ordinal position
parameterIndex to be of JDBC type
sqlType . |
default void |
CallableStatement.registerOutParameter(int parameterIndex,
SQLType sqlType,
String typeName)
Registers the designated output parameter.
|
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType)
Registers the OUT parameter named
parameterName to the JDBC type
sqlType . |
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the parameter named
parameterName to be of JDBC type
sqlType . |
void |
CallableStatement.registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the designated output parameter.
|
default void |
CallableStatement.registerOutParameter(String parameterName,
SQLType sqlType)
Registers the OUT parameter named
parameterName to the JDBC type
sqlType . |
default void |
CallableStatement.registerOutParameter(String parameterName,
SQLType sqlType,
int scale)
Registers the parameter named
parameterName to be of JDBC type
sqlType . |
default void |
CallableStatement.registerOutParameter(String parameterName,
SQLType sqlType,
String typeName)
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 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 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 x)
Sets the designated parameter to the given
java.sql.Array object. |
void |
PreparedStatement.setAsciiStream(int parameterIndex,
InputStream x)
Sets the designated parameter to the given input stream.
|
void |
PreparedStatement.setAsciiStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
PreparedStatement.setAsciiStream(int parameterIndex,
InputStream x,
long length)
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 parameterName,
InputStream x)
Sets the designated parameter to the given input stream.
|
void |
CallableStatement.setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
CallableStatement.setAsciiStream(String parameterName,
InputStream x,
long length)
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 x)
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
CallableStatement.setBigDecimal(String parameterName,
BigDecimal x)
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 x)
Sets the designated parameter to the given input stream.
|
void |
PreparedStatement.setBinaryStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
PreparedStatement.setBinaryStream(int parameterIndex,
InputStream x,
long length)
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 parameterName,
InputStream x)
Sets the designated parameter to the given input stream.
|
void |
CallableStatement.setBinaryStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
CallableStatement.setBinaryStream(String parameterName,
InputStream x,
long length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
PreparedStatement.setBlob(int parameterIndex,
Blob x)
Sets the designated parameter to the given
java.sql.Blob object. |
void |
PreparedStatement.setBlob(int parameterIndex,
InputStream inputStream)
Sets the designated parameter to a
InputStream object. |
void |
PreparedStatement.setBlob(int parameterIndex,
InputStream inputStream,
long length)
Sets the designated parameter to a
InputStream object. |
void |
CallableStatement.setBlob(String parameterName,
Blob x)
Sets the designated parameter to the given
java.sql.Blob object. |
void |
CallableStatement.setBlob(String parameterName,
InputStream inputStream)
Sets the designated parameter to a
InputStream object. |
void |
CallableStatement.setBlob(String parameterName,
InputStream inputStream,
long length)
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 parameterName,
boolean x)
Sets the designated parameter to the given Java
boolean value. |
void |
PreparedStatement.setByte(int parameterIndex,
byte x)
Sets the designated parameter to the given Java
byte value. |
void |
CallableStatement.setByte(String parameterName,
byte x)
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 parameterName,
byte[] x)
Sets the designated parameter to the given Java array of bytes.
|
void |
Connection.setCatalog(String catalog)
Sets the given catalog name in order to select
a subspace of this
Connection object's database
in which to work. |
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 reader)
Sets the designated parameter to the given
Reader
object. |
void |
PreparedStatement.setCharacterStream(int parameterIndex,
Reader reader,
int length)
Sets the designated parameter to the given
Reader
object, which is the given number of characters long. |
void |
PreparedStatement.setCharacterStream(int parameterIndex,
Reader reader,
long length)
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 parameterName,
Reader reader)
Sets the designated parameter to the given
Reader
object. |
void |
CallableStatement.setCharacterStream(String parameterName,
Reader reader,
int length)
Sets the designated parameter to the given
Reader
object, which is the given number of characters long. |
void |
CallableStatement.setCharacterStream(String parameterName,
Reader reader,
long length)
Sets the designated parameter to the given
Reader
object, which is the given number of characters long. |
void |
PreparedStatement.setClob(int parameterIndex,
Clob x)
Sets the designated parameter to the given
java.sql.Clob object. |
void |
PreparedStatement.setClob(int parameterIndex,
Reader reader)
Sets the designated parameter to a
Reader object. |
void |
PreparedStatement.setClob(int parameterIndex,
Reader reader,
long length)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setClob(String parameterName,
Clob x)
Sets the designated parameter to the given
java.sql.Clob object. |
void |
CallableStatement.setClob(String parameterName,
Reader reader)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setClob(String parameterName,
Reader reader,
long length)
Sets the designated parameter to a
Reader object. |
void |
Statement.setCursorName(String name)
Sets the SQL cursor name to the given
String , which
will be used by subsequent Statement object
execute methods. |
void |
PreparedStatement.setDate(int parameterIndex,
Date x)
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 x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Date value,
using the given Calendar object. |
void |
CallableStatement.setDate(String parameterName,
Date x)
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 parameterName,
Date x,
Calendar cal)
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 parameterName,
double x)
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 parameterName,
float x)
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 parameterName,
int x)
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 parameterName,
long x)
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 value)
Sets the designated parameter to a
Reader object. |
void |
PreparedStatement.setNCharacterStream(int parameterIndex,
Reader value,
long length)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setNCharacterStream(String parameterName,
Reader value)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setNCharacterStream(String parameterName,
Reader value,
long length)
Sets the designated parameter to a
Reader object. |
void |
PreparedStatement.setNClob(int parameterIndex,
NClob value)
Sets the designated parameter to a
java.sql.NClob object. |
void |
PreparedStatement.setNClob(int parameterIndex,
Reader reader)
Sets the designated parameter to a
Reader object. |
void |
PreparedStatement.setNClob(int parameterIndex,
Reader reader,
long length)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setNClob(String parameterName,
NClob value)
Sets the designated parameter to a
java.sql.NClob object. |
void |
CallableStatement.setNClob(String parameterName,
Reader reader)
Sets the designated parameter to a
Reader object. |
void |
CallableStatement.setNClob(String parameterName,
Reader reader,
long length)
Sets the designated parameter to a
Reader object. |
void |
Connection.setNetworkTimeout(Executor executor,
int milliseconds)
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 value)
Sets the designated parameter to the given
String object. |
void |
CallableStatement.setNString(String parameterName,
String value)
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 typeName)
Sets the designated parameter to SQL
NULL . |
void |
CallableStatement.setNull(String parameterName,
int sqlType)
Sets the designated parameter to SQL
NULL . |
void |
CallableStatement.setNull(String parameterName,
int sqlType,
String typeName)
Sets the designated parameter to SQL
NULL . |
void |
PreparedStatement.setObject(int parameterIndex,
Object x)
Sets the value of the designated parameter using the given object.
|
void |
PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object.
|
void |
PreparedStatement.setObject(int parameterIndex,
Object x,
int targetSqlType,
int scaleOrLength)
Sets the value of the designated parameter with the given object.
|
default void |
PreparedStatement.setObject(int parameterIndex,
Object x,
SQLType targetSqlType)
Sets the value of the designated parameter with the given object.
|
default void |
PreparedStatement.setObject(int parameterIndex,
Object x,
SQLType targetSqlType,
int scaleOrLength)
Sets the value of the designated parameter with the given object.
|
void |
Ref.setObject(Object value)
Sets the structured type value that this
Ref
object references to the given instance of Object . |
void |
CallableStatement.setObject(String parameterName,
Object x)
Sets the value of the designated parameter with the given object.
|
void |
CallableStatement.setObject(String parameterName,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object.
|
void |
CallableStatement.setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object.
|
default void |
CallableStatement.setObject(String parameterName,
Object x,
SQLType targetSqlType)
Sets the value of the designated parameter with the given object.
|
default void |
CallableStatement.setObject(String parameterName,
Object x,
SQLType targetSqlType,
int scaleOrLength)
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 x)
Sets the designated parameter to the given
REF(<structured-type>) value. |
<T extends Result> |
SQLXML.setResult(Class<T> resultClass)
Returns a Result for setting the XML value designated by this SQLXML instance.
|
void |
PreparedStatement.setRowId(int parameterIndex,
RowId x)
Sets the designated parameter to the given
java.sql.RowId object. |
void |
CallableStatement.setRowId(String parameterName,
RowId x)
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 name)
Creates a savepoint with the given name in the current transaction
and returns the new
Savepoint object that represents it. |
void |
Connection.setSchema(String schema)
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 parameterName,
short x)
Sets the designated parameter to the given Java
short value. |
void |
PreparedStatement.setSQLXML(int parameterIndex,
SQLXML xmlObject)
Sets the designated parameter to the given
java.sql.SQLXML object. |
void |
CallableStatement.setSQLXML(String parameterName,
SQLXML xmlObject)
Sets the designated parameter to the given
java.sql.SQLXML object. |
void |
PreparedStatement.setString(int parameterIndex,
String x)
Sets the designated parameter to the given Java
String value. |
int |
Clob.setString(long pos,
String str)
Writes the given Java
String to the CLOB
value that this Clob object designates at the position
pos . |
int |
Clob.setString(long pos,
String str,
int offset,
int len)
Writes
len characters of str , starting
at character offset , to the CLOB value
that this Clob represents. |
void |
SQLXML.setString(String value)
Sets the XML value designated by this SQLXML instance to the given String representation.
|
void |
CallableStatement.setString(String parameterName,
String x)
Sets the designated parameter to the given Java
String value. |
void |
PreparedStatement.setTime(int parameterIndex,
Time x)
Sets the designated parameter to the given
java.sql.Time value. |
void |
PreparedStatement.setTime(int parameterIndex,
Time x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object. |
void |
CallableStatement.setTime(String parameterName,
Time x)
Sets the designated parameter to the given
java.sql.Time value. |
void |
CallableStatement.setTime(String parameterName,
Time x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object. |
void |
PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x)
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
PreparedStatement.setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object. |
void |
CallableStatement.setTimestamp(String parameterName,
Timestamp x)
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
CallableStatement.setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object. |
void |
Connection.setTransactionIsolation(int level)
Attempts to change the transaction isolation level for this
Connection object to the one given. |
void |
Connection.setTypeMap(Map<String,Class<?>> map)
Installs the given
TypeMap object as the type map for
this Connection object. |
void |
PreparedStatement.setUnicodeStream(int parameterIndex,
InputStream x,
int length)
Deprecated.
Use
setCharacterStream |
void |
PreparedStatement.setURL(int parameterIndex,
URL x)
Sets the designated parameter to the given
java.net.URL value. |
void |
CallableStatement.setURL(String parameterName,
URL val)
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<T> iface)
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 x)
Updates the designated column with a
java.sql.Array value. |
void |
ResultSet.updateArray(String columnLabel,
Array x)
Updates the designated column with a
java.sql.Array value. |
void |
ResultSet.updateAsciiStream(int columnIndex,
InputStream x)
Updates the designated column with an ascii stream value.
|
void |
ResultSet.updateAsciiStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(int columnIndex,
InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(String columnLabel,
InputStream x)
Updates the designated column with an ascii stream value.
|
void |
ResultSet.updateAsciiStream(String columnLabel,
InputStream x,
int length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateAsciiStream(String columnLabel,
InputStream x,
long length)
Updates the designated column with an ascii stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateBigDecimal(int columnIndex,
BigDecimal x)
Updates the designated column with a
java.math.BigDecimal
value. |
void |
ResultSet.updateBigDecimal(String columnLabel,
BigDecimal x)
Updates the designated column with a
java.sql.BigDecimal
value. |
void |
ResultSet.updateBinaryStream(int columnIndex,
InputStream x)
Updates the designated column with a binary stream value.
|
void |
ResultSet.updateBinaryStream(int columnIndex,
InputStream x,
int length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(int columnIndex,
InputStream x,
long length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(String columnLabel,
InputStream x)
Updates the designated column with a binary stream value.
|
void |
ResultSet.updateBinaryStream(String columnLabel,
InputStream x,
int length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateBinaryStream(String columnLabel,
InputStream x,
long length)
Updates the designated column with a binary stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateBlob(int columnIndex,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
ResultSet.updateBlob(int columnIndex,
InputStream inputStream)
Updates the designated column using the given input stream.
|
void |
ResultSet.updateBlob(int columnIndex,
InputStream inputStream,
long length)
Updates the designated column using the given input stream, which
will have the specified number of bytes.
|
void |
ResultSet.updateBlob(String columnLabel,
Blob x)
Updates the designated column with a
java.sql.Blob value. |
void |
ResultSet.updateBlob(String columnLabel,
InputStream inputStream)
Updates the designated column using the given input stream.
|
void |
ResultSet.updateBlob(String columnLabel,
InputStream inputStream,
long length)
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 columnLabel,
boolean x)
Updates the designated column with a
boolean value. |
void |
ResultSet.updateByte(int columnIndex,
byte x)
Updates the designated column with a
byte value. |
void |
ResultSet.updateByte(String columnLabel,
byte x)
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 columnLabel,
byte[] x)
Updates the designated column with a byte array value.
|
void |
ResultSet.updateCharacterStream(int columnIndex,
Reader x)
Updates the designated column with a character stream value.
|
void |
ResultSet.updateCharacterStream(int columnIndex,
Reader x,
int length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(int columnIndex,
Reader x,
long length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(String columnLabel,
Reader reader)
Updates the designated column with a character stream value.
|
void |
ResultSet.updateCharacterStream(String columnLabel,
Reader reader,
int length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateCharacterStream(String columnLabel,
Reader reader,
long length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateClob(int columnIndex,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
ResultSet.updateClob(int columnIndex,
Reader reader)
Updates the designated column using the given
Reader
object. |
void |
ResultSet.updateClob(int columnIndex,
Reader reader,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
ResultSet.updateClob(String columnLabel,
Clob x)
Updates the designated column with a
java.sql.Clob value. |
void |
ResultSet.updateClob(String columnLabel,
Reader reader)
Updates the designated column using the given
Reader
object. |
void |
ResultSet.updateClob(String columnLabel,
Reader reader,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
ResultSet.updateDate(int columnIndex,
Date x)
Updates the designated column with a
java.sql.Date value. |
void |
ResultSet.updateDate(String columnLabel,
Date x)
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 columnLabel,
double x)
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 columnLabel,
float x)
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 columnLabel,
int x)
Updates the designated column with an
int value. |
void |
ResultSet.updateLong(int columnIndex,
long x)
Updates the designated column with a
long value. |
void |
ResultSet.updateLong(String columnLabel,
long x)
Updates the designated column with a
long value. |
void |
ResultSet.updateNCharacterStream(int columnIndex,
Reader x)
Updates the designated column with a character stream value.
|
void |
ResultSet.updateNCharacterStream(int columnIndex,
Reader x,
long length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateNCharacterStream(String columnLabel,
Reader reader)
Updates the designated column with a character stream value.
|
void |
ResultSet.updateNCharacterStream(String columnLabel,
Reader reader,
long length)
Updates the designated column with a character stream value, which will have
the specified number of bytes.
|
void |
ResultSet.updateNClob(int columnIndex,
NClob nClob)
Updates the designated column with a
java.sql.NClob value. |
void |
ResultSet.updateNClob(int columnIndex,
Reader 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 reader,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
ResultSet.updateNClob(String columnLabel,
NClob nClob)
Updates the designated column with a
java.sql.NClob value. |
void |
ResultSet.updateNClob(String columnLabel,
Reader reader)
Updates the designated column using the given
Reader
object. |
void |
ResultSet.updateNClob(String columnLabel,
Reader reader,
long length)
Updates the designated column using the given
Reader
object, which is the given number of characters long. |
void |
ResultSet.updateNString(int columnIndex,
String nString)
Updates the designated column with a
String value. |
void |
ResultSet.updateNString(String columnLabel,
String nString)
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 columnLabel)
Updates the designated column with a
null value. |
void |
ResultSet.updateObject(int columnIndex,
Object x)
Updates the designated column with an
Object value. |
void |
ResultSet.updateObject(int columnIndex,
Object x,
int scaleOrLength)
Updates the designated column with an
Object value. |
default void |
ResultSet.updateObject(int columnIndex,
Object x,
SQLType targetSqlType)
Updates the designated column with an
Object value. |
default void |
ResultSet.updateObject(int columnIndex,
Object x,
SQLType targetSqlType,
int scaleOrLength)
Updates the designated column with an
Object value. |
void |
ResultSet.updateObject(String columnLabel,
Object x)
Updates the designated column with an
Object value. |
void |
ResultSet.updateObject(String columnLabel,
Object x,
int scaleOrLength)
Updates the designated column with an
Object value. |
default void |
ResultSet.updateObject(String columnLabel,
Object x,
SQLType targetSqlType)
Updates the designated column with an
Object value. |
default void |
ResultSet.updateObject(String columnLabel,
Object x,
SQLType targetSqlType,
int scaleOrLength)
Updates the designated column with an
Object value. |
void |
ResultSet.updateRef(int columnIndex,
Ref x)
Updates the designated column with a
java.sql.Ref value. |
void |
ResultSet.updateRef(String columnLabel,
Ref x)
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 x)
Updates the designated column with a
RowId value. |
void |
ResultSet.updateRowId(String columnLabel,
RowId x)
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 columnLabel,
short x)
Updates the designated column with a
short value. |
void |
ResultSet.updateSQLXML(int columnIndex,
SQLXML xmlObject)
Updates the designated column with a
java.sql.SQLXML value. |
void |
ResultSet.updateSQLXML(String columnLabel,
SQLXML xmlObject)
Updates the designated column with a
java.sql.SQLXML value. |
void |
ResultSet.updateString(int columnIndex,
String x)
Updates the designated column with a
String value. |
void |
ResultSet.updateString(String columnLabel,
String x)
Updates the designated column with a
String value. |
void |
ResultSet.updateTime(int columnIndex,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
ResultSet.updateTime(String columnLabel,
Time x)
Updates the designated column with a
java.sql.Time value. |
void |
ResultSet.updateTimestamp(int columnIndex,
Timestamp x)
Updates the designated column with a
java.sql.Timestamp
value. |
void |
ResultSet.updateTimestamp(String columnLabel,
Timestamp x)
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 |
CallableStatement.wasNull()
Retrieves whether the last OUT parameter read had the value of
SQL
NULL . |
boolean |
SQLInput.wasNull()
Retrieves whether the last value read was SQL
NULL . |
void |
SQLOutput.writeArray(Array x)
Writes an SQL
ARRAY value to the stream. |
void |
SQLOutput.writeAsciiStream(InputStream x)
Writes the next attribute to the stream as a stream of ASCII characters.
|
void |
SQLOutput.writeBigDecimal(BigDecimal x)
Writes the next attribute to the stream as a java.math.BigDecimal object.
|
void |
SQLOutput.writeBinaryStream(InputStream x)
Writes the next attribute to the stream as a stream of uninterpreted
bytes.
|
void |
SQLOutput.writeBlob(Blob x)
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 x)
Writes the next attribute to the stream as a stream of Unicode characters.
|
void |
SQLOutput.writeClob(Clob x)
Writes an SQL
CLOB value to the stream. |
void |
SQLOutput.writeDate(Date x)
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 x)
Writes an SQL
NCLOB value to the stream. |
void |
SQLOutput.writeNString(String x)
Writes the next attribute to the stream as a
String
in the Java programming language. |
default void |
SQLOutput.writeObject(Object x,
SQLType targetSqlType)
Writes to the stream the data contained in the given object.
|
void |
SQLOutput.writeObject(SQLData x)
Writes to the stream the data contained in the given
SQLData object. |
void |
SQLOutput.writeRef(Ref x)
Writes an SQL
REF value to the stream. |
void |
SQLOutput.writeRowId(RowId x)
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 stream)
Writes this object to the given SQL data stream, converting it back to
its SQL value in the data source.
|
void |
SQLOutput.writeSQLXML(SQLXML x)
Writes an SQL
XML value to the stream. |
void |
SQLOutput.writeString(String x)
Writes the next attribute to the stream as a
String
in the Java programming language. |
void |
SQLOutput.writeStruct(Struct x)
Writes an SQL structured type value to the stream.
|
void |
SQLOutput.writeTime(Time x)
Writes the next attribute to the stream as a java.sql.Time object.
|
void |
SQLOutput.writeTimestamp(Timestamp x)
Writes the next attribute to the stream as a java.sql.Timestamp object.
|
void |
SQLOutput.writeURL(URL x)
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 username,
String password)
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 user,
String password)
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<String,Class<?>> |
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 user,
String password)
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 caller)
Reads the new contents of the calling
RowSet object. |
void |
RowSet.setArray(int i,
Array x)
Sets the designated parameter in this
RowSet object's command
with the given Array value. |
void |
RowSet.setAsciiStream(int parameterIndex,
InputStream x)
Sets the designated parameter in this
RowSet object's command
to the given input stream. |
void |
RowSet.setAsciiStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter in this
RowSet object's command
to the given java.io.InputStream value. |
void |
RowSet.setAsciiStream(String parameterName,
InputStream x)
Sets the designated parameter to the given input stream.
|
void |
RowSet.setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
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 x)
Sets the designated parameter in this
RowSet object's command
to the given java.math.BigDeciaml value. |
void |
RowSet.setBigDecimal(String parameterName,
BigDecimal x)
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
RowSet.setBinaryStream(int parameterIndex,
InputStream x)
Sets the designated parameter in this
RowSet object's command
to the given input stream. |
void |
RowSet.setBinaryStream(int parameterIndex,
InputStream x,
int length)
Sets the designated parameter in this
RowSet object's command
to the given java.io.InputStream value. |
void |
RowSet.setBinaryStream(String parameterName,