Frames | No Frames |
Constructors with parameter type java.sql.SQLException | |
Methods with return type java.sql.SQLException | |
SQLException |
Methods which throw type java.sql.SQLException | |
Map | |
void | |
void | |
void | |
Connection | |
Connection | |
Connection | |
Connection | |
boolean | |
PrintWriter | |
PrintWriter | |
PrintWriter | |
int | |
int | |
int | |
int | |
int | |
ResultSet | |
ResultSet | |
Object[] | |
PooledConnection | |
PooledConnection | |
int | |
String | |
XAConnection | |
XAConnection | |
XAResource | |
void | |
void | |
void | |
void | RowSetMetaData.setAutoIncrement(int columnIndex, boolean property) |
void | |
void | |
void | |
void | RowSet.setBoolean(int parameterIndex, boolean x) |
void | |
void | |
void | RowSetMetaData.setCaseSensitive(int columnIndex, boolean property) |
void | |
void | |
void | |
void | RowSetMetaData.setColumnCount(int columnCount) |
void | RowSetMetaData.setColumnDisplaySize(int columnIndex, int size) |
void | |
void | |
void | RowSetMetaData.setColumnType(int columnIndex, int SQLType) |
void | |
void | |
void | RowSet.setConcurrency(int concurrency) |
void | RowSetMetaData.setCurrency(int columnIndex, boolean property) |
void | |
void | |
void | |
void | |
void | RowSet.setEscapeProcessing(boolean enable) |
void | |
void | |
void | |
void | |
void | |
void | ConnectionPoolDataSource.setLoginTimeout(int seconds) |
void | DataSource.setLoginTimeout(int seconds) |
void | XADataSource.setLoginTimeout(int seconds) |
void | |
void | RowSet.setMaxFieldSize(int max) |
void | RowSet.setMaxRows(int max) |
void | |
void | |
void | |
void | RowSetMetaData.setNullable(int columnIndex, int property) |
void | |
void | |
void | |
void | |
void | RowSetMetaData.setPrecision(int columnIndex, int precision) |
void | RowSet.setQueryTimeout(int seconds) |
void | RowSet.setReadOnly(boolean value) |
void | |
void | RowSetMetaData.setScale(int columnIndex, int scale) |
void | |
void | RowSetMetaData.setSearchable(int columnIndex, boolean property) |
void | |
void | RowSetMetaData.setSigned(int columnIndex, boolean property) |
void | |
void | |
void | |
void | |
void | |
void | |
void | RowSet.setTransactionIsolation(int level) |
void | |
void | |
void | |
void | |
boolean |
Classes derived from java.sql.SQLException | |
class | This class extends SQLException to count the successful
updates in each statement in a batch that was successfully updated prior
to the error.
|
class | This exception is thrown when a piece of data is unexpectedly
truncated in JDBC.
|
class | This exception is thrown when a database warning occurs.
|
Methods with parameter type java.sql.SQLException | |
void | This method adds a new exception to the end of the chain of exceptions
that are chained to this object.
|
Methods with return type java.sql.SQLException | |
SQLException | This method returns the exception that is chained to this object.
|
Methods which throw type java.sql.SQLException | |
Map This method returns the mapping of SQL types to Java classes
currently in use by this connection. | |
boolean | This method positions the result set to the specified absolute row.
|
boolean | This method tests whether or not the driver believes it can connect to
the specified database. |
void | This method adds a set of parameters to the batch for JDBC 2.0.
|
void | This method adds a SQL statement to a SQL batch. |
void | This method repositions the cursor to after the last row in the result
set.
|
boolean | This method tests whether or not all the procedures returned by
the getProcedures method can be called by this user.
|
boolean | This method tests whether or not all the table returned by the
getTables method can be selected by this user.
|
void | This method repositions the cursor to before the first row in the
result set.
|
void | This method cancels an outstanding statement, if the database supports
that operation.
|
void | This method cancels any changes that have been made to a row. |
void | This method clears out any SQL statements that have been populated in
the current batch. |
void | This method clears all of the input parameter that have been
set on this statement.
|
void | This method clears all warnings that have occurred on this connection.
|
void | This method clears all warnings associated with this result set.
|
void | This method clears any SQL warnings that have been attached to this
statement.
|
void | This method immediately closes this database connection.
|
void | This method closes the result set and frees any associated resources.
|
void | This method closes the statement and frees any associated resources.
|
void | This method commits any SQL statements executed on this connection since
the last commit or rollback.
|
Connection | This method connects to the specified database using the connection
properties supplied. |
Statement | This method creates a new SQL statement. |
Statement | Connection.createStatement(int resultSetType, int resultSetConcurrency) This method creates a new SQL statement with the specified type and
concurrency. |
Statement | Connection.createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) This method creates a new SQL statement with the specified type,
concurrency and holdability, instead of using the defaults. |
boolean | This method tests whether or not a DDL statement will cause the
current transaction to be automatically committed.
|
boolean | This method tests whether or not DDL statements are ignored in
transactions.
|
void | This method deletes the current row in the database.
|
boolean | DatabaseMetaData.deletesAreDetected(int type) This method tests whether or not the specified result set type can detect
a visible delete by calling the rowUpdated method.
|
void | This method de-registers a driver from the manager.
|
boolean | This method tests whether or not the maximum row size includes BLOB's
|
boolean | This method executes a prepared SQL query.
|
boolean | This method executes an arbitrary SQL statement of any time. |
boolean | |
boolean | |
boolean | |
int[] | This method executes the SQL batch and returns an array of update
counts - one for each SQL statement in the batch - ordered in the same
order the statements were added to the batch. |
ResultSet | This method executes a prepared SQL query and returns its ResultSet.
|
ResultSet | This method executes the specified SQL SELECT statement and returns a
(possibly empty) ResultSet with the results of the query.
|
int | This method executes an SQL INSERT, UPDATE or DELETE statement. |
int | This method executes the specified SQL INSERT, UPDATE, or DELETE statement
and returns the number of rows affected, which may be 0.
|
int | |
int | |
int | |
int | This method returns the column index of the specified named column.
|
boolean | This method repositions the cursor on the first row in the
result set.
|
Object | Returns the contents of this array. |
Object | Returns the contents of this array. |
Array | CallableStatement.getArray(int index) This method returns the value of the specified parameter as a Java
Array .
|
Array | This method returns the specified column value as an Array .
|
Array | This method returns the value of the specified parameter as a Java
Array .
|
Array | This method returns the specified column value as an Array .
|
Object | Returns a portion of this array starting at start
into the array and continuing for count
elements. |
Object | This method returns a portion of this array starting at start
into the array and continuing for count
elements. |
InputStream | This method returns a byte stream that reads the contents of this
Clob as a series of ASCII bytes.
|
InputStream | ResultSet.getAsciiStream(int columnIndex) This method returns the value of the specified column as an ASCII
stream. |
InputStream | This method returns the value of the specified column as an ASCII
stream. |
Object[] | This method returns the attributes of this SQL structured type.
|
Object[] | This method returns the attributes of this SQL structured type.
|
ResultSet | DatabaseMetaData.getAttributes(String catalog, String schemaPattern, String typePattern, String attributePattern) |
boolean | This method tests whether or not auto commit mode is currently enabled.
|
int | Returns the JDBC type identifier of the elements in this
array. |
String | Returns the name of the SQL type of the elements in this
array. |
String | This method returns the fully qualified name of the SQL structured
type of the referenced item.
|
ResultSet | DatabaseMetaData.getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable) This method returns the best set of columns for uniquely identifying
a row. |
BigDecimal | CallableStatement.getBigDecimal(int index) This method returns the value of the specified parameter as a Java
BigDecimal .
|
BigDecimal | ResultSet.getBigDecimal(int columnIndex) This method returns the value of the specified column as a Java
BigDecimal .
|
BigDecimal | CallableStatement.getBigDecimal(int index, int scale) This method returns the value of the specified parameter as a Java
BigDecimal .
|
BigDecimal | ResultSet.getBigDecimal(int columnIndex, int scale) This method returns the value of the specified column as a Java
BigDecimal .
|
BigDecimal | This method returns the value of the specified parameter as a Java
BigDecimal .
|
BigDecimal | This method returns the value of the specified column as a Java
BigDecimal .
|
BigDecimal | This method returns the value of the specified column as a Java
BigDecimal .
|
InputStream | This method returns a stream that will read the bytes of this
Blob .
|
InputStream | ResultSet.getBinaryStream(int columnIndex) This method returns the value of the specified column as a raw byte
stream. |
InputStream | This method returns the value of the specified column as a raw byte
stream. |
Blob | CallableStatement.getBlob(int index) This method returns the value of the specified parameter as a Java
Blob .
|
Blob | This method returns the specified column value as a BLOB.
|
Blob | This method returns the value of the specified parameter as a Java
Blob .
|
Blob | This method returns the specified column value as a BLOB.
|
boolean | CallableStatement.getBoolean(int index) This method returns the value of the specified parameter as a Java
boolean .
|
boolean | ResultSet.getBoolean(int columnIndex) This method returns the value of the specified column as a Java
boolean .
|
boolean | This method returns the value of the specified parameter as a Java
boolean .
|
boolean | This method returns the value of the specified column as a Java
boolean .
|
byte | CallableStatement.getByte(int index) This method returns the value of the specified parameter as a Java
byte .
|
byte | This method returns the value of the specified column as a Java
byte .
|
byte | This method returns the value of the specified parameter as a Java
byte .
|
byte | This method returns the value of the specified column as a Java
byte .
|
byte[] | CallableStatement.getBytes(int index) This method returns the value of the specified parameter as a Java
byte array.
|
byte[] | This method returns the value of the specified column as a Java
byte array.
|
byte[] | This method returns the value of the specified parameter as a Java
byte array.
|
byte[] | This method returns the value of the specified column as a Java
byte array.
|
byte[] | This method returns up to the requested bytes of this Blob
as a byte array.
|
String | This method returns the name of the catalog in use by this connection,
if any.
|
String | ResultSetMetaData.getCatalogName(int columnIndex) This method returns the name of the catalog containing the specified
column.
|
String | This method returns the separator between the catalog name and the
table name.
|
String | This method returns the vendor's term for "catalog".
|
ResultSet | This method returns the list of database catalogs as a
ResultSet with one column - TABLE_CAT - that is the
name of the catalog.
|
Reader | This method returns a character stream that reads the contents of this
Clob .
|
Reader | ResultSet.getCharacterStream(int columnIndex) This method returns the value of the specified column as a character
stream. |
Reader | This method returns the value of the specified column as a character
stream. |
Clob | CallableStatement.getClob(int index) This method returns the value of the specified parameter as a Java
Clob .
|
Clob | This method returns the specified column value as a CLOB.
|
Clob | This method returns the value of the specified parameter as a Java
Clob .
|
Clob | This method returns the specified column value as a CLOB.
|
String | ResultSetMetaData.getColumnClassName(int columnIndex) This method returns the name of the Java class which will be used to
create objects representing the data in this column.
|
int | This method returns the number of columns in the result set.
|
int | ResultSetMetaData.getColumnDisplaySize(int columnIndex) This method returns the maximum number of characters that can be used
to display a value in this column.
|
String | ResultSetMetaData.getColumnLabel(int columnIndex) This method returns a string that should be used as a caption for this
column for user display purposes.
|
String | ResultSetMetaData.getColumnName(int columnIndex) This method returns the name of the specified column.
|
ResultSet | DatabaseMetaData.getColumnPrivileges(String catalog, String schema, String tableName, String columnPattern) This method returns the access rights that have been granted to the
requested columns. |
int | ResultSetMetaData.getColumnType(int columnIndex) This method returns the SQL type of the specified column. |
String | ResultSetMetaData.getColumnTypeName(int columnIndex) This method returns the name of the SQL type for this column.
|
ResultSet | DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tablePattern, String columnPattern) This method returns a list of the tables columns for
the requested tables. |
int | This method returns the concurrency type of this result set. |
Connection | This method returns the Connection object that was used
to generate the metadata in this object.
|
Connection | This method returns the Connection instance that was
used to create this object.
|
Connection | This method attempts to return a connection to the specified
JDBC URL string.
|
Connection | This method attempts to return a connection to the specified
JDBC URL string using the specified username and password.
|
Connection | This method attempts to return a connection to the specified
JDBC URL string using the specified connection properties.
|
ResultSet | DatabaseMetaData.getCrossReference(String primaryCatalog, String primarySchema, String primaryTableName, String foreignCatalog, String foreignSchema, String foreignTableName) This method returns a description of how one table imports another
table's primary key as a foreign key. |
String | This method returns the name of the database cursor used by this
result set.
|
int | This method returns the major version number of the database.
|
int | This method returns the minor version number of the database.
|
String | This method returns the name of the database product.
|
String | This method returns the version of the database product.
|
Date | CallableStatement.getDate(int index) This method returns the value of the specified parameter as a Java
java.sql.Date .
|
Date | This method returns the value of the specified column as a Java
java.sql.Date .
|
Date | This method returns the value of the specified parameter as a Java
java.sql.Date .
|
Date | This method returns the specified column value as a
java.sql.Date . |
Date | This method returns the value of the specified parameter as a Java
java.sql.Date .
|
Date | This method returns the value of the specified column as a Java
java.sql.Date .
|
Date | This method returns the value of the specified parameter as a Java
java.sql.Date .
|
Date | This method returns the specified column value as a
java.sql.Date . |
int | This method returns the default transaction isolation level of the
database.
|
double | CallableStatement.getDouble(int index) This method returns the value of the specified parameter as a Java
double .
|
double | This method returns the value of the specified column as a Java
double .
|
double | This method returns the value of the specified parameter as a Java
double .
|
double | This method returns the value of the specified column as a Java
double .
|
Driver | This method returns a driver that can connect to the specified
JDBC URL string. |
String | This method returns the name of the JDBC driver.
|
String | This method returns the version of the JDBC driver.
|
ResultSet | This method returns a list of the table's which use this table's
primary key as a foreign key. |
String | This methods returns non-standard characters that can appear in
unquoted identifiers.
|
int | This method returns the current fetch direction for this result set.
|
int | This method returns the current direction that the driver thinks the
result set will be accessed int.
|
int | This method returns the current number of rows that will be fetched
from the database at a time.
|
int | This method returns the number of rows the driver believes should be
fetched from the database at a time.
|
float | CallableStatement.getFloat(int index) This method returns the value of the specified parameter as a Java
float .
|
float | This method returns the value of the specified column as a Java
float .
|
float | This method returns the value of the specified parameter as a Java
float .
|
float | This method returns the value of the specified column as a Java
float .
|
ResultSet | |
int | Gets the default holdability of ResultSet S that are created
from Statement S using this Connection .
|
String | This metohd returns the quote string for SQL identifiers.
|
ResultSet | This method returns a list of the table's foreign keys. |
ResultSet | DatabaseMetaData.getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate) This method returns information about a tables indices and statistics.
|
int | CallableStatement.getInt(int index) This method returns the value of the specified parameter as a Java
int .
|
int | This method returns the value of the specified column as a Java
int .
|
int | This method returns the value of the specified parameter as a Java
int .
|
int | This method returns the value of the specified column as a Java
int .
|
int | This method returns the major version number of the JDBC driver.
|
int | This method returns the minor version number of the JDBC driver.
|
long | CallableStatement.getLong(int index) This method returns the value of the specified parameter as a Java
long .
|
long | This method returns the value of the specified column as a Java
long .
|
long | This method returns the value of the specified parameter as a Java
long .
|
long | This method returns the value of the specified column as a Java
long .
|
int | This method returns the number of hex characters allowed in an inline
binary literal.
|
int | This method returns the maximum length of a catalog name.
|
int | This method returns the maximum length of a character literal.
|
int | This method returns the maximum length of a column name.
|
int | This method returns the maximum number of columns in a GROUP BY statement.
|
int | This method returns the maximum number of columns in an index.
|
int | This method returns the maximum number of columns in an ORDER BY statement.
|
int | This method returns the maximum number of columns in a SELECT statement.
|
int | This method returns the maximum number of columns in a table.
|
int | This method returns the maximum number of connections this client
can have to the database.
|
int | This method returns the maximum length of a cursor name.
|
int | This method returns the maximum length of any column value in bytes.
|
int | This method returns the maximum length of an index.
|
int | This method returns the maximum length of a procedure name.
|
int | This method returns the maximum size of a row in bytes.
|
int | This method returns the maximum possible number of rows in a result set.
|
int | This method returns the maximum length of a schema name.
|
int | This method includes the maximum length of a SQL statement.
|
int | This method returns the maximum number of statements that can be
active at any time.
|
int | This method returns the maximum length of a table name.
|
int | This method returns the maximum number of tables that may be referenced
in a SELECT statement.
|
int | This method returns the maximum length of a user name.
|
DatabaseMetaData | This method returns the meta data for this database connection.
|
ResultSetMetaData | This method returns meta data for the result set from this statement.
|
ResultSetMetaData | This method returns data about the columns returned as part of the
result set as a ResultSetMetaData instance.
|
boolean | This method advances the result set pointer to the next result set,
which can then be retrieved using getResultSet
|
boolean | Statement.getMoreResults(int current) |
String | This method returns a comma separated list of math functions.
|
Object | |
Object | |
Object | CallableStatement.getObject(int index) This method returns the value of the specified parameter as a Java
Object .
|
Object | This method returns the value of the specified column as a Java
Object .
|
Object | This method returns the value of the specified parameter as a Java
Object .
|
Object | This method returns the value of the specified column as a Java
Object using the specified SQL type to Java type map.
|
Object | This method returns the value of the specified parameter as a Java
Object .
|
Object | This method returns the value of the specified column as a Java
Object .
|
Object | This method returns the value of the specified parameter as a Java
Object using the specified mapping for conversion from
SQL to Java types.
|
Object | This method returns the value of the specified column as a Java
Object using the specified SQL type to Java type map.
|
String | ParameterMetaData.getParameterClassName(int param) |
int | |
ParameterMetaData | Returns information about the parameters set on this
PreparedStatement (see ParameterMetaData for a
detailed description of the provided information).
|
int | ParameterMetaData.getParameterMode(int param) |
int | ParameterMetaData.getParameterType(int param) |
String | ParameterMetaData.getParameterTypeName(int param) |
int | ParameterMetaData.getPrecision(int param) |
int | ResultSetMetaData.getPrecision(int columnIndex) This method returns the precision of the specified column, which is the
number of decimal digits it contains.
|
ResultSet | This method returns a list of a table's primary key columns. |
ResultSet | DatabaseMetaData.getProcedureColumns(String catalog, String schemaPattern, String procedurePattern, String columnPattern) This method returns a list of the parameter and result columns for
the requested stored procedures. |
String | This method returns the vendor's term for "procedure".
|
ResultSet | This method returns a list of all the stored procedures matching the
specified pattern in the given schema and catalog. |
DriverPropertyInfo[] | This method returns an array of possible properties that could be
used to connect to the specified database.
|
int | The method returns the number of seconds a statement may be in process
before timing out. |
Ref | CallableStatement.getRef(int index) This method returns the value of the specified parameter as a Java
Ref .
|
Ref | This method returns a Ref for the specified column which
represents the structured type for the column.
|
Ref | This method returns the value of the specified parameter as a Java
Ref .
|
Ref | This method returns a Ref for the specified column which
represents the structured type for the column.
|
ResultSet | Returns the elements in the array as a ResultSet .
|
ResultSet | This method returns the result set of the SQL statement that was
executed. |
ResultSet | This method returns the elements in the array as a ResultSet .
|
ResultSet | Array.getResultSet(long start, int count) This method returns a portion of the array as a ResultSet .
|
ResultSet | This method returns a portion of the array as a ResultSet .
|
int | This method returns the concurrency type of the result set for this
statement. |
int | This method returns the default holdability type of ResultSet S
retrieved from this database. |
int | |
int | This method returns the result set type for this statement. |
int | This method returns the current row number in the cursor. |
String | This method returns a comma separated list of all the SQL keywords in
the database that are not in SQL92.
|
int | |
String | This method returns the user defined datatype name for this object.
|
String | This method returns the name of the SQL structured type for this
object.
|
int | |
String | |
int | ParameterMetaData.getScale(int param) |
int | ResultSetMetaData.getScale(int columnIndex) This method returns the scale of the specified column, which is the
number of digits to the right of the decimal point.
|
String | ResultSetMetaData.getSchemaName(int columnIndex) This method returns the name of the schema that contains the specified
column.
|
String | This method returns the vendor's term for "schema".
|
ResultSet | This method returns the list of database schemas as a
ResultSet , with one column - TABLE_SCHEM - that is the
name of the schema.
|
String | This method returns the string used to escape wildcards in search strings.
|
short | CallableStatement.getShort(int index) This method returns the value of the specified parameter as a Java
short .
|
short | This method returns the value of the specified column as a Java
short .
|
short | This method returns the value of the specified parameter as a Java
short .
|
short | This method returns the value of the specified column as a Java
short .
|
Statement | This method returns a the Statement that was used to
produce this result set.
|
String | CallableStatement.getString(int index) This method returns the value of the specified parameter as a Java
String .
|
String | This method returns the value of the specified column as a Java
String .
|
String | This method returns the value of the specified parameter as a Java
String .
|
String | This method returns the value of the specified column as a Java
String .
|
String | This method returns a comma separated list of string functions.
|
String | Clob.getSubString(long start, int count) This method returns the specified portion of this Clob as a
String .
|
ResultSet | |
ResultSet | |
String | This method returns a comma separated list of of system functions.
|
String | ResultSetMetaData.getTableName(int columnIndex) This method returns the name of the table containing the specified
column.
|
ResultSet | This method returns the access rights that have been granted to the
requested tables. |
ResultSet | This method returns the list of database table types as a
ResultSet with one column - TABLE_TYPE - that is the
name of the table type.
|
ResultSet | DatabaseMetaData.getTables(String catalog, String schemaPattern, String tablePattern, String[] types) This method returns a list of the requested table as a
ResultSet with the following columns:
|
Time | CallableStatement.getTime(int index) This method returns the value of the specified parameter as a Java
java.sql.Time .
|
Time | This method returns the value of the specified column as a Java
java.sql.Time .
|
Time | This method returns the value of the specified parameter as a Java
java.sql.Time .
|
Time | This method returns the specified column value as a
java.sql.Time . |
Time | This method returns the value of the specified parameter as a Java
java.sql.Time .
|
Time | This method returns the value of the specified column as a Java
java.sql.Time .
|
Time | This method returns the value of the specified parameter as a Java
java.sql.Time .
|
Time | This method returns the specified column value as a
java.sql.Time . |
String | This method returns comma separated list of time/date functions.
|
Timestamp | CallableStatement.getTimestamp(int index) This method returns the value of the specified parameter as a Java
java.sql.Timestamp .
|
Timestamp | ResultSet.getTimestamp(int columnIndex) This method returns the value of the specified column as a Java
java.sql.Timestamp .
|
Timestamp | This method returns the value of the specified parameter as a Java
java.sql.Timestamp .
|
Timestamp | This method returns the specified column value as a
java.sql.Timestamp . |
Timestamp | This method returns the value of the specified parameter as a Java
java.sql.Timestamp .
|
Timestamp | This method returns the value of the specified column as a Java
java.sql.Timestamp .
|
Timestamp | This method returns the value of the specified parameter as a Java
java.sql.Timestamp .
|
Timestamp | This method returns the specified column value as a
java.sql.Timestamp . |
int | This method returns the current transaction isolation mode. |
int | This method returns the result set type of this result set. |
ResultSet | This method returns a list of the SQL types supported by this
database. |
ResultSet | This method returns the list of user defined data types in use. |
String | This method returns the URL for this database.
|
URL | CallableStatement.getURL(int index) This method returns the value of the specified parameter as a Java
java.net.URL .
|
URL | This method returns the specified column value as a
java.net.URL .
|
URL | This method returns the value of the specified parameter as a Java
java.net.URL .
|
URL | This method returns the specified column value as a
java.net.URL .
|
InputStream | ResultSet.getUnicodeStream(int columnIndex) This method returns the value of the specified column as a Unicode UTF-8
stream. |
InputStream | This method returns the value of the specified column as a Unicode UTF-8
stream. |
int | This method returns the update count of the SQL statement that was
executed. |
String | This method returns the database username for this connection.
|
ResultSet | This method returns the set of columns that are automatically updated
when the row is update. |
SQLWarning | This method returns the first warning that occurred on this connection,
if any. |
SQLWarning | This method returns the first SQL warning associated with this result
set. |
SQLWarning | This method returns the first SQL warning attached to this statement.
|
void | This method inserts the current row into the database. |
boolean | DatabaseMetaData.insertsAreDetected(int type) This method tests whether or not the specified result set type can detect
a visible insert by calling the rowUpdated method.
|
boolean | This method tests whether or not the cursor is after the last row
in the result set.
|
boolean | ResultSetMetaData.isAutoIncrement(int columnIndex) This method test whether or not the column is an auto-increment column.
|
boolean | This method tests whether or not the cursor is before the first row
in the result set.
|
boolean | ResultSetMetaData.isCaseSensitive(int columnIndex) This method tests whether or not a column is case sensitive in its values.
|
boolean | This method tests whether a catalog name appears at the beginning of
a fully qualified table name.
|
boolean | This method tests whether or not this connection has been closed.
|
boolean | ResultSetMetaData.isCurrency(int columnIndex) This method tests whether or not the column stores a monetary value.
|
boolean | ResultSetMetaData.isDefinitelyWritable(int columnIndex) This method tests whether or not the column is writable. |
boolean | This method tests whether or not the cursor is positioned on the first
row in the result set.
|
boolean | This method tests whether or not the cursor is on the last row
in the result set.
|
int | ParameterMetaData.isNullable(int param) |
int | ResultSetMetaData.isNullable(int columnIndex) This method returns a value indicating whether or not the specified
column may contain a NULL value.
|
boolean | This method tests whether or not this connection is in read only mode.
|
boolean | This method tests whether or not the database is in read only mode.
|
boolean | ResultSetMetaData.isReadOnly(int columnIndex) This method tests whether or not the specified column is read only.
|
boolean | ResultSetMetaData.isSearchable(int columnIndex) This method tests whether not the specified column can be used in
a WHERE clause.
|
boolean | ParameterMetaData.isSigned(int param) |
boolean | ResultSetMetaData.isSigned(int columnIndex) This method tests whether or not the value of the specified column
is signed or unsigned.
|
boolean | ResultSetMetaData.isWritable(int columnIndex) This method tests whether or not the column may be writable. |
boolean | This method repositions the cursor on the last row in the result
set.
|
long | This method returns the number of bytes in this Blob .
|
long | This method returns the number of characters in this Clob .
|
boolean | |
void | This method moves the result set position from the insert row back to
the current row that was selected prior to moving to the insert row.
|
void | This method positions the result set to the "insert row", which allows
a new row to be inserted into the database from the result set.
|
String | This method converts the specified generic SQL statement into the
native grammer of the database this object is connected to.
|
boolean | This method advances to the next row in the result set. |
boolean | This method tests whether the concatenation of a NULL and non-NULL
value results in a NULL. |
boolean | This method test whether or not NULL's are sorted to the end
of the list regardless of ascending or descending sort order.
|
boolean | This method tests whether or not NULL's sort as high values.
|
boolean | This method tests whether or not NULL's sort as high values.
|
boolean | This method tests whether or not NULL's sort as low values.
|
boolean | DatabaseMetaData.othersDeletesAreVisible(int type) This method tests whether or not the specified result set type sees
deletes committed by others.
|
boolean | DatabaseMetaData.othersInsertsAreVisible(int type) This method tests whether or not the specified result set type sees
inserts committed by others.
|
boolean | DatabaseMetaData.othersUpdatesAreVisible(int type) This method tests whether or not the specified result set type sees
updates committed by others.
|
boolean | DatabaseMetaData.ownDeletesAreVisible(int type) This method tests whether or not the specified result set type sees its
own deletes.
|
boolean | DatabaseMetaData.ownInsertsAreVisible(int type) This method tests whether or not the specified result set type sees its
own inserts.
|
boolean | DatabaseMetaData.ownUpdatesAreVisible(int type) This method tests whether or not the specified result set type sees its
own updates.
|
long | This method returns the index into this Blob at which the
first instance of the specified bytes occur. |
long | This method returns the index into this Clob of the first
occurrence of the specified character pattern (supplied by the caller as a
String ). |
long | This method returns the index into this Blob at which the
first instance of the specified pattern occurs. |
long | This method returns the index into this Clob of the first
occurrence of the specified character pattern (supplied by the caller as a
Clob ). |
CallableStatement | This method creates a new CallableStatement for the
specified SQL string. |
CallableStatement | This method creates a new CallableStatement for the
specified SQL string. |
CallableStatement | Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) This method creates a new CallableStatement for the
specified SQL string. |
PreparedStatement | This method creates a new PreparedStatement for the specified
SQL string. |
PreparedStatement | |
PreparedStatement | This method creates a new PreparedStatement for the specified
SQL string. |
PreparedStatement | Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) This method creates a new PreparedStatement for the specified
SQL string. |
PreparedStatement | |
PreparedStatement | |
boolean | This method moves the current position to the previous row in the
result set.
|
Array | This method reads the next item from the stream a Java SQL
Array .
|
InputStream | This method reads the next item from the stream a ASCII text
InputStream .
|
BigDecimal | This method reads the next item from the stream a Java
BigDecimal .
|
InputStream | This method reads the next item from the stream a binary
InputStream .
|
Blob | This method reads the next item from the stream a Java SQL
Blob .
|
boolean | This method reads the next item from the stream a Java
boolean .
|
byte | This method reads the next item from the stream a Java
byte .
|
byte[] | This method reads the next item from the stream a Java
byte array
|
Reader | This method reads the next item from the stream a character
Reader .
|
Clob | This method reads the next item from the stream a Java SQL
Clob .
|
Date | This method reads the next item from the stream a Java
java.sql.Date .
|
double | This method reads the next item from the stream a Java
double .
|
float | This method reads the next item from the stream a Java
float .
|
int | This method reads the next item from the stream a Java
int .
|
long | This method reads the next item from the stream a Java
long .
|
Object | This method reads the next item from the stream a Java
Object .
|
Ref | This method reads the next item from the stream a Java SQL
Ref .
|
void | This method populates the data in the object from the specified stream.
|
short | This method reads the next item from the stream a Java
short .
|
String | This method reads the next item from the stream a Java
String .
|
Time | This method reads the next item from the stream a Java
java.sql.Time .
|
Timestamp | This method reads the next item from the stream a Java
java.sql.Timestamp .
|
URL | |
void | This method refreshes the contents of the current row from the database.
|
void | This method registers a new driver with the manager. |
void | CallableStatement.registerOutParameter(int index, int sqlType) This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void | CallableStatement.registerOutParameter(int index, int sqlType, int scale) This method registers the specified parameter as an output parameter
of the specified SQL type and scale.
|
void | This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void | This method registers the specified parameter as an output parameter
of the specified SQL type.
|
void | This method registers the specified parameter as an output parameter
of the specified SQL type. |
void | This method registers the specified parameter as an output parameter
of the specified SQL type. |
boolean | This method moves the result set position relative to the current row.
|
void | Removes the specified savepoint from this Connection .
|
void | This method rolls back any SQL statements executed on this connection
since the last commit or rollback.
|
void | Undoes all changes made after the specified savepoint was set.
|
boolean | This method tests whether or not the current row in the result set
has been deleted. |
boolean | This method tests whether or not the current row in the result set
has been inserted. |
boolean | This method tests whether or not the current row in the result set
has been updated. |
void | This method sets the specified parameter from the given Java
Array value. |
void | This method sets the specified parameter from the given Java
ASCII InputStream value.
|
void | This method sets the specified parameter from the given Java
ASCII InputStream value.
|
OutputStream | Clob.setAsciiStream(long start) Returns an ASCII text stream that writes into this Clob ,
starting at the specified index.
|
void | Connection.setAutoCommit(boolean autoCommit) This method turns auto commit mode on or off. |
void | This method sets the specified parameter from the given Java
java.math.BigDecimal value.
|
void | This method sets the specified parameter from the given Java
BigDecimal value.
|
void | This method sets the specified parameter from the given Java
binary InputStream value.
|
void | This method sets the specified parameter from the given Java
binary InputStream value.
|
OutputStream | Blob.setBinaryStream(long start) Returns a binary stream that writes into this Blob ,
starting at the specified index.
|
void | This method sets the specified parameter from the given Java
Blob value. |
void | PreparedStatement.setBoolean(int index, boolean value) This method sets the specified parameter from the given Java
boolean value.
|
void | This method sets the specified parameter from the given Java
boolean value.
|
void | PreparedStatement.setByte(int index, byte value) This method sets the specified parameter from the given Java
byte value.
|
void | This method sets the specified parameter from the given Java
byte value.
|
void | PreparedStatement.setBytes(int index, byte[] value) This method sets the specified parameter from the given Java
byte array value.
|
void | This method sets the specified parameter from the given Java
byte array value.
|
int | Writes the specified data into this Blob , starting at the
specified index.
|
int | Writes a portion of the specified data into this Blob ,
starting at the specified index.
|
void | This method sets the name of the catalog in use by this connection.
|
void | This method sets the specified parameter from the given Java
character Reader value.
|
void | This method sets the specified parameter from the given Java
character Reader value.
|
Writer | Clob.setCharacterStream(long start) Returns a character stream that writes into this Clob ,
starting at the specified index.
|
void | This method sets the specified parameter from the given Java
Clob value. |
void | This method sets the cursor name that will be used by the result set.
|
void | This method sets the specified parameter from the given Java
java.sql.Date value.
|
void | This method sets the specified parameter from the given Java
java.sql.Date value.
|
void | This method sets the specified parameter from the given Java
java.sql.Date value.
|
void | This method sets the specified parameter from the given Java
java.sql.Date value.
|
void | PreparedStatement.setDouble(int index, double value) This method sets the specified parameter from the given Java
double value.
|
void | This method sets the specified parameter from the given Java
double value.
|
void | Statement.setEscapeProcessing(boolean escape) This method sets the local escape processing mode on or off. |
void | ResultSet.setFetchDirection(int direction) This method provides a hint to the driver about which direction the
result set will be processed in.
|
void | Statement.setFetchDirection(int direction) This method informs the driver which direction the result set will
be accessed in.
|
void | ResultSet.setFetchSize(int rows) This method provides a hint to the driver about how many rows at a
time it should fetch from the database.
|
void | Statement.setFetchSize(int numRows) This method informs the driver how many rows it should fetch from the
database at a time.
|
void | PreparedStatement.setFloat(int index, float value) This method sets the specified parameter from the given Java
float value.
|
void | This method sets the specified parameter from the given Java
float value.
|
void | Connection.setHoldability(int holdability) Sets the default holdability of ResultSet S that are created
from Statement S using this Connection .
|
void | PreparedStatement.setInt(int index, int value) This method sets the specified parameter from the given Java
int value.
|
void | This method sets the specified parameter from the given Java
int value.
|
void | PreparedStatement.setLong(int index, long value) This method sets the specified parameter from the given Java
long value.
|
void | This method sets the specified parameter from the given Java
long value.
|
void | Statement.setMaxFieldSize(int maxSize) This method sets the limit for the maximum length of any column in bytes.
|
void | Statement.setMaxRows(int maxRows) This method sets the maximum number of rows that can be present in a
result set.
|
void | PreparedStatement.setNull(int index, int sqlType) This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void | This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void | This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void | This method populates the specified parameter with a SQL NULL value
for the specified type.
|
void | This method sets the specified parameter from the given Java
Object value. |
void | This method sets the specified parameter from the given Java
Object value. |
void | This method sets the specified parameter from the given Java
Object value. |
void | |
void | This method sets the specified parameter from the given Java
Object value. |
void | This method sets the specified parameter from the given Java
Object value. |
void | This method sets the specified parameter from the given Java
Object value. |
void | Statement.setQueryTimeout(int seconds) This method sets the number of seconds a statement may be in process
before timing out. |
void | Connection.setReadOnly(boolean readOnly) This method turns read only mode on or off. |
void | This method sets the specified parameter from the given Java
Ref value. |
Savepoint | Creates a new unnamed savepoint for this Connection
|
Savepoint | Creates a new savepoint with the specifiend name for this
Connection .
|
void | PreparedStatement.setShort(int index, short value) This method sets the specified parameter from the given Java
short value.
|
void | This method sets the specified parameter from the given Java
short value.
|
void | This method sets the specified parameter from the given Java
String value.
|
void | This method sets the specified parameter from the given Java
String value.
|
int | Writes the specified string into this Clob , starting at the
specified index.
|
int | Writes the specified portion of a string into this Clob ,
starting at the specified index.
|
void | This method sets the specified parameter from the given Java
java.sql.Time value.
|
void | This method sets the specified parameter from the given Java
java.sql.Time value.
|
void | This method sets the specified parameter from the given Java
java.sql.Time value.
|
void | This method sets the specified parameter from the given Java
java.sql.Time value.
|
void | This method sets the specified parameter from the given Java
java.sql.Timestamp value.
|
void | This method sets the specified parameter from the given Java
java.sql.Timestamp value.
|
void | This method sets the specified parameter from the given Java
java.sql.Timestamp value.
|
void | This method sets the specified parameter from the given Java
java.sql.Timestamp value.
|
void | Connection.setTransactionIsolation(int level) This method sets the current transaction isolation mode. |
void | This method sets the mapping table for SQL types to Java classes.
|
void | This method sets the specified parameter from the given Java
java.net.URL value.
|
void | This method sets the value of the specified parameter to the specified
java.net.URL
|
void | This method sets the specified parameter from the given Java
Unicode UTF-8 InputStream value.
|
boolean | This method tests whether or not the database treats mixed case
identifiers as all lower case.
|
boolean | This method tests whether or not the database treats mixed case
quoted identifiers as all lower case.
|
boolean | This method tests whether or not the database stores mixed case
identifers even if it treats them as case insensitive.
|
boolean | This method tests whether or not the database stores mixed case
quoted identifers even if it treats them as case insensitive.
|
boolean | This method tests whether or not the database treats mixed case
identifiers as all upper case.
|
boolean | This method tests whether or not the database treats mixed case
quoted identifiers as all upper case.
|
boolean | This method tests whether or not the ANSI92 entry level SQL
grammar is supported. |
boolean | This method tests whether or not the ANSI92 full SQL
grammar is supported.
|
boolean | This method tests whether or not the ANSI92 intermediate SQL
grammar is supported.
|
boolean | This method tests whether or not the database supports
"ALTER TABLE ADD COLUMN"
|
boolean | This method tests whether or not the database supports
"ALTER TABLE DROP COLUMN"
|
boolean | This method tests whether or not the database supports batch updates.
|
boolean | This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean | This method tests whether a catalog name can appear in an index definition.
|
boolean | This method tests whether a catalog name can appear in privilege definitions.
|
boolean | This method tests whether a catalog name can appear in a procedure
call
|
boolean | This method tests whether a catalog name can appear in a table definition.
|
boolean | This method tests whether or not column aliasing is supported.
|
boolean | Tests whether or not CONVERT is supported.
|
boolean | DatabaseMetaData.supportsConvert(int fromType, int toType) This method tests whether or not CONVERT can be performed between the
specified types. |
boolean | This method tests whether or not the core grammer for ODBC is supported.
|
boolean | This method test whether or not correlated subqueries are allowed. |
boolean | This method tests whether or not DDL and DML statements allowed within
the same transaction.
|
boolean | This method tests whether or not only DML statement are allowed
inside a transaction.
|
boolean | This method tests whether correlation names must be different from the
name of the table.
|
boolean | This method tests whether or not expressions are allowed in an
ORDER BY lists.
|
boolean | This method tests whether or not the extended grammer for ODBC is supported.
|
boolean | This method tests whether or not the database supports full outer joins.
|
boolean | |
boolean | This method tests whether or not GROUP BY is supported.
|
boolean | This method tests whether or not a GROUP BY can add columns not in the
select if it includes all the columns in the select.
|
boolean | This method tests whether GROUP BY on a non-selected column is
allowed.
|
boolean | This method tests whether or not the SQL integrity enhancement
facility is supported.
|
boolean | This method tests whether or not the escape character is supported in
LIKE expressions. |
boolean | This method tests whether or not the database supports limited outer joins.
|
boolean | This method tests whether or not the minimum grammer for ODBC is supported.
|
boolean | This method tests whether or not the database supports identifiers
with mixed case.
|
boolean | This method tests whether or not the database supports quoted identifiers
with mixed case.
|
boolean | This method tests whether the database supports returning multiple
ResultSet S from a CallableStatement at once.
|
boolean | This method tests whether multiple result sets for a single statement are
supported.
|
boolean | This method test whether or not multiple transactions may be open
at once, as long as they are on different connections.
|
boolean | This method tests whether the database supports named parameters.
|
boolean | This method tests whether or not columns can be defined as NOT NULL. |
boolean | This method tests whether or not the database supports cursors
remaining open across commits.
|
boolean | This method tests whether or not the database supports cursors
remaining open across rollbacks.
|
boolean | This method tests whether or not the database supports statements
remaining open across commits.
|
boolean | This method tests whether or not the database supports statements
remaining open across rollbacks.
|
boolean | This method tests whether or ORDER BY on a non-selected column is
allowed.
|
boolean | This method tests whether or not the database supports outer joins.
|
boolean | This method tests whether or not that database supports positioned
deletes.
|
boolean | This method tests whether or not that database supports positioned
updates.
|
boolean | DatabaseMetaData.supportsResultSetConcurrency(int type, int concurrency) This method tests whether the specified result set type and result set
concurrency type are supported by the database.
|
boolean | DatabaseMetaData.supportsResultSetHoldability(int holdability) This method tests if the database supports the specified holdability type.
|
boolean | DatabaseMetaData.supportsResultSetType(int type) This method tests whether or not the datbase supports the specified
result type.
|
boolean | This method tests whether the databse supports savepoints.
|
boolean | This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean | This method tests whether a catalog name can appear in an index definition.
|
boolean | This method tests whether a catalog name can appear in privilege definitions.
|
boolean | This method tests whether a catalog name can appear in a procedure
call
|
boolean | This method tests whether a catalog name can appear in a table definition.
|
boolean | This method tests whether or not SELECT FOR UPDATE is supported by the
database.
|
boolean | |
boolean | This method tests whether or not stored procedures are supported on
this database.
|
boolean | This method tests whether or not subqueries are allowed in comparisons.
|
boolean | This method tests whether or not subqueries are allowed in exists
expressions. |
boolean | This method tests whether subqueries are allowed in IN statements.
|
boolean | This method tests whether or not subqueries are allowed in quantified
expressions. |
boolean | This method tests whether or not table correlation names are
supported. |
boolean | This method tests whether or not the database supports the specified
transaction isolation level.
|
boolean | This method tests whether or not the database supports transactions.
|
boolean | This method tests whether or not the UNION statement is supported.
|
boolean | This method tests whether or not the UNION ALL statement is supported.
|
void | Truncates this Blob to be at most the specified number of
bytes long.
|
void | Truncates this Clob to be at most the specified number of
characters long.
|
void | This method updates the specified column to have a
java.sqlArray value.
|
void | This method updates the specified column to have a
java.sqlArray value.
|
void | This method updates the specified column from an ASCII text stream.
|
void | This method updates the specified column from an ASCII text stream.
|
void | This method updates the specified column to have a BigDecimal value. |
void | This method updates the specified column to have a BigDecimal value. |
void | This method updates the specified column from a binary stream.
|
void | This method updates the specified column from a binary stream.
|
void | This method updates the specified column to have a
java.sql.Blob value.
|
void | This method updates the specified column to have a
java.sql.Blob value.
|
void | ResultSet.updateBoolean(int columnIndex, boolean value) This method updates the specified column to have a boolean value. |
void | This method updates the specified column to have a boolean value. |
void | ResultSet.updateByte(int columnIndex, byte value) This method updates the specified column to have a byte value. |
void | This method updates the specified column to have a byte value. |
void | ResultSet.updateBytes(int columnIndex, byte[] value) This method updates the specified column to have a byte array value. |
void | This method updates the specified column to have a byte array value. |
void | This method updates the specified column from a character stream.
|
void | This method updates the specified column from a character stream.
|
void | This method updates the specified column to have a
java.sql.Clob value.
|
void | This method updates the specified column to have a
java.sql.Clob value.
|
void | This method updates the specified column to have a java.sql.Date value. |
void | This method updates the specified column to have a java.sql.Date value. |
void | ResultSet.updateDouble(int columnIndex, double value) This method updates the specified column to have a double value. |
void | This method updates the specified column to have a double value. |
void | ResultSet.updateFloat(int columnIndex, float value) This method updates the specified column to have a float value. |
void | This method updates the specified column to have a float value. |
void | This method updates the specified column to have an int value. |
void | This method updates the specified column to have an int value. |
void | ResultSet.updateLong(int columnIndex, long value) This method updates the specified column to have a long value. |
void | This method updates the specified column to have a long value. |
void | ResultSet.updateNull(int columnIndex) This method updates the specified column to have a NULL value. |
void | This method updates the specified column to have a NULL value. |
void | This method updates the specified column to have an Object value.
|
void | This method updates the specified column to have an Object value.
|
void | This method updates the specified column to have an Object value.
|
void | This method updates the specified column to have an Object value.
|
void | This method updates the specified column to have a
java.sql.Ref value.
|
void | This method updates the specified column to have a
java.sql.Ref value.
|
void | This method updates the current row in the database.
|
void | ResultSet.updateShort(int columnIndex, short value) This method updates the specified column to have a short value. |
void | This method updates the specified column to have a short value. |
void | This method updates the specified column to have a String value. |
void | This method updates the specified column to have a String value. |
void | This method updates the specified column to have a java.sql.Time value. |
void | This method updates the specified column to have a java.sql.Time value. |
void | This method updates the specified column to have a java.sql.Timestamp value.
|
void | This method updates the specified column to have a java.sql.Timestamp value.
|
boolean | DatabaseMetaData.updatesAreDetected(int type) This method tests whether or not the specified result set type can detect
a visible update by calling the rowUpdated method.
|
boolean | This method tests whether or not the database uses a separate file for
each table.
|
boolean | This method tests whether or not the database uses local files to
store tables.
|
boolean | This method tests whether the value of the last parameter that was fetched
was actually a SQL NULL value.
|
boolean | This method tests whether the value of the last column that was fetched
was actually a SQL NULL value.
|
boolean | This method tests whether or not the last value read was a SQL
NULL value.
|
void | This method writes the specified Java SQL Array object
to the SQL stream.
|
void | This method writes the specified ASCII text stream
to the SQL stream.
|
void | This method writes the specified Java BigDecimal
to the SQL stream.
|
void | This method writes the specified uninterpreted binary byte stream
to the SQL stream.
|
void | This method writes the specified Java SQL Blob object
to the SQL stream.
|
void | SQLOutput.writeBoolean(boolean value) This method writes the specified Java boolean
to the SQL stream.
|
void | This method writes the specified Java byte
to the SQL stream.
|
void | SQLOutput.writeBytes(byte[] value) This method writes the specified Java byte array
to the SQL stream.
|
void | This method writes the specified Java character stream
to the SQL stream.
|
void | This method writes the specified Java SQL Clob object
to the SQL stream.
|
void | This method writes the specified Java java.sql.Date
to the SQL stream.
|
void | SQLOutput.writeDouble(double value) This method writes the specified Java double
to the SQL stream.
|
void | SQLOutput.writeFloat(float value) This method writes the specified Java float
to the SQL stream.
|
void | This method writes the specified Java int
to the SQL stream.
|
void | This method writes the specified Java long
to the SQL stream.
|
void | This method writes the specified Java SQLData object
to the SQL stream.
|
void | This method writes the specified Java SQL Ref object
to the SQL stream.
|
void | This method writes the data in this object to the specified stream.
|
void | SQLOutput.writeShort(short value) This method writes the specified Java short
to the SQL stream.
|
void | This method writes the specified Java String
to the SQL stream.
|
void | This method writes the specified Java SQL Struct object
to the SQL stream.
|
void | This method writes the specified Java java.sql.Time
to the SQL stream.
|
void | This method writes the specified Java java.sql.Timestamp
to the SQL stream.
|
void | This method writes the specified java.net.URL object to the
SQL stream.
|