Uses of Class java.sql.SQLException

Uses in package java.sql

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

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)
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
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
Statement.execute(String sql, int autoGeneratedKeys)
boolean
Statement.execute(String sql, int[] columnIndexes)
boolean
Statement.execute(String sql, String[] columnNames)
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
Statement.executeUpdate(String sql, int autoGeneratedKeys)
int
Statement.executeUpdate(String sql, int[] columnIndexes)
int
Statement.executeUpdate(String sql, String[] columnNames)
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.
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.
Array
Array
This method returns the specified column value as an Array.
Object
Returns the contents of this array.
Object
Array.getArray(long index, int count)
Returns a portion of this array starting at index into the array and continuing for count elements.
Object
Array.getArray(long index, int count, Map map)
This method returns a portion of this array starting at index into the array and continuing for count elements.
InputStream
This method returns a byte stream that reads the contents of the 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.
ResultSet
DatabaseMetaData.getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
Object[]
This method returns the attributes of this SQL structured type.
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 table, int scope, boolean nullable)
This method returns the best set of columns for uniquely identifying a row.
BigDecimal
CallableStatement.getBigDecimal(int parameterIndex)
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 parameterIndex, 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
BigDecimal
This method returns the value of the specified column as a Java BigDecimal.
BigDecimal
ResultSet.getBigDecimal(String columnName, int scale)
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 the 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
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
Blob
This method returns the specified column value as a BLOB.
boolean
CallableStatement.getBoolean(int parameterIndex)
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
boolean
This method returns the value of the specified column as a Java boolean.
byte
CallableStatement.getByte(int parameterIndex)
This method returns the value of the specified parameter as a Java byte.
byte
ResultSet.getByte(int columnIndex)
This method returns the value of the specified column as a Java byte.
byte
byte
ResultSet.getByte(String columnName)
This method returns the value of the specified column as a Java byte.
byte[]
CallableStatement.getBytes(int parameterIndex)
This method returns the value of the specified parameter as a Java byte array.
byte[]
ResultSet.getBytes(int columnIndex)
This method returns the value of the specified column as a Java byte array.
byte[]
byte[]
This method returns the value of the specified column as a Java byte array.
byte[]
Blob.getBytes(long pos, int length)
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
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 the 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
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
Clob
This method returns the specified column value as a CLOB.
String
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
This method returns the maximum number of characters that can be used to display a value in this column.
String
This method returns a string that should be used as a caption for this column for user display purposes.
String
This method returns the name of the specified column.
ResultSet
DatabaseMetaData.getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
This method returns the access rights that have been granted to the requested columns.
int
This method returns the SQL type of the specified column.
String
This method returns the name of the SQL type for this column.
ResultSet
DatabaseMetaData.getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
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 primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
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
int
String
This method returns the name of the database product.
String
This method returns the version of the database product.
Date
CallableStatement.getDate(int parameterIndex)
This method returns the value of the specified parameter as a Java java.sql.Date.
Date
ResultSet.getDate(int columnIndex)
This method returns the value of the specified column as a Java java.sql.Date.
Date
CallableStatement.getDate(int parameterIndex, Calendar cal)
This method returns the value of the specified parameter as a Java java.sql.Date.
Date
ResultSet.getDate(int columnIndex, Calendar cal)
This method returns the specified column value as a java.sql.Date.
Date
Date
ResultSet.getDate(String columnName)
This method returns the value of the specified column as a Java java.sql.Date.
Date
Date
ResultSet.getDate(String columnName, Calendar cal)
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 parameterIndex)
This method returns the value of the specified parameter as a Java double.
double
ResultSet.getDouble(int columnIndex)
This method returns the value of the specified column as a Java double.
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 parameterIndex)
This method returns the value of the specified parameter as a Java float.
float
ResultSet.getFloat(int columnIndex)
This method returns the value of the specified column as a Java float.
float
float
This method returns the value of the specified column as a Java float.
ResultSet
int
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 table, boolean unique, boolean approximate)
This method returns information about a tables indices and statistics.
int
CallableStatement.getInt(int parameterIndex)
This method returns the value of the specified parameter as a Java int.
int
ResultSet.getInt(int columnIndex)
This method returns the value of the specified column as a Java int.
int
int
ResultSet.getInt(String columnName)
This method returns the value of the specified column as a Java int.
int
int
long
CallableStatement.getLong(int parameterIndex)
This method returns the value of the specified parameter as a Java long.
long
ResultSet.getLong(int columnIndex)
This method returns the value of the specified column as a Java long.
long
long
ResultSet.getLong(String columnName)
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
String
This method returns a comma separated list of math functions.
Object
Object
CallableStatement.getObject(int parameterIndex)
This method returns the value of the specified parameter as a Java Object.
Object
ResultSet.getObject(int columnIndex)
This method returns the value of the specified column as a Java Object.
Object
CallableStatement.getObject(int index, Map map)
This method returns the value of the specified parameter as a Java Object.
Object
ResultSet.getObject(int i, Map map)
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Object
Object
This method returns the value of the specified column as a Java Object.
Object
CallableStatement.getObject(String parameterName, Map map)
Object
ResultSet.getObject(String colName, Map map)
This method returns the value of the specified column as a Java Object using the specified SQL type to Java type map.
Object
String
int
ParameterMetaData
int
int
String
int
int
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 procedureNamePattern, String columnNamePattern)
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
DatabaseMetaData.getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
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
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
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 index, int count)
This method returns a portion of the array as a ResultSet.
ResultSet
Array.getResultSet(long index, int count, Map map)
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
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
int
This method returns the scale of the specified column, which is the number of digits to the right of the decimal point.
String
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 parameterIndex)
This method returns the value of the specified parameter as a Java short.
short
ResultSet.getShort(int columnIndex)
This method returns the value of the specified column as a Java short.
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 parameterIndex)
This method returns the value of the specified parameter as a Java String.
String
ResultSet.getString(int columnIndex)
This method returns the value of the specified column as a Java String.
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 pos, int length)
This method returns the specified portion of the CLOB as a String.
ResultSet
DatabaseMetaData.getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
ResultSet
DatabaseMetaData.getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
String
This method returns a comma separated list of of system functions.
String
This method returns the name of the table containing the specified column.
ResultSet
DatabaseMetaData.getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
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 tableNamePattern, String[] types)
This method returns a list of the requested table as a ResultSet with the following columns:
  1. TABLE_CAT - The catalog the table is in, which may be null.
  2. TABLE_SCHEM - The schema the table is in, which may be null.
  3. TABLE_NAME - The name of the table.
  4. TABLE_TYPE - A string describing the table type.
Time
CallableStatement.getTime(int parameterIndex)
This method returns the value of the specified parameter as a Java java.sql.Time.
Time
ResultSet.getTime(int columnIndex)
This method returns the value of the specified column as a Java java.sql.Time.
Time
CallableStatement.getTime(int parameterIndex, Calendar cal)
This method returns the value of the specified parameter as a Java java.sql.Time.
Time
ResultSet.getTime(int columnIndex, Calendar cal)
This method returns the specified column value as a java.sql.Time.
Time
Time
ResultSet.getTime(String columnName)
This method returns the value of the specified column as a Java java.sql.Time.
Time
Time
ResultSet.getTime(String columnName, Calendar cal)
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 parameterIndex)
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
CallableStatement.getTimestamp(int parameterIndex, Calendar cal)
This method returns the value of the specified parameter as a Java java.sql.Timestamp.
Timestamp
ResultSet.getTimestamp(int columnIndex, Calendar cal)
This method returns the specified column value as a java.sql.Timestamp.
Timestamp
Timestamp
This method returns the value of the specified column as a Java java.sql.Timestamp.
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.
Map
This method returns the mapping of SQL types to Java classes currently in use by this connection.
ResultSet
DatabaseMetaData.getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
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 parameterIndex)
URL
ResultSet.getURL(int columnIndex)
URL
URL
ResultSet.getURL(String columnName)
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
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
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
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
This method tests whether or not the column stores a monetary value.
boolean
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
int
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
This method tests whether or not the specified column is read only.
boolean
This method tests whether not the specified column can be used in a WHERE clause.
boolean
boolean
This method tests whether or not the value of the specified column is signed or unsigned.
boolean
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 the BLOB.
long
This method returns the number of characters in the 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
This method tests whether or not the specified result set type sees deletes committed by others.
boolean
This method tests whether or not the specified result set type sees inserts committed by others.
boolean
This method tests whether or not the specified result set type sees updates committed by others.
boolean
This method tests whether or not the specified result set type sees its own deletes.
boolean
This method tests whether or not the specified result set type sees its own inserts.
boolean
This method tests whether or not the specified result set type sees its own updates.
long
Blob.position(byte[] pattern, long start)
This method returns the index into the BLOB at which the first instance of the specified bytes occur.
long
Clob.position(String searchstr, long start)
This method returns the index into the CLOB of the first occurrence of the specified character pattern (supplied by the caller as a String).
long
Blob.position(Blob pattern, long start)
This method returns the index into the BLOB at which the first instance of the specified pattern occurs.
long
Clob.position(Clob searchstr, long start)
This method returns the index into the 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
Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency)
This method creates a new CallableStatement for the specified SQL string.
CallableStatement
Connection.prepareCall(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
PreparedStatement
This method creates a new PreparedStatement for the specified SQL string.
PreparedStatement
Connection.prepareStatement(String sql, int autoGeneratedKeys)
PreparedStatement
Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
This method creates a new PreparedStatement for the specified SQL string.
PreparedStatement
Connection.prepareStatement(String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
PreparedStatement
Connection.prepareStatement(String sql, int[] columnIndexes)
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
SQLData.readSQL(SQLInput stream, String typeName)
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 parameterIndex, int sqlType)
This method registers the specified parameter as an output parameter of the specified SQL type.
void
CallableStatement.registerOutParameter(int parameterIndex, int sqlType, int scale)
This method registers the specified parameter as an output parameter of the specified SQL type and scale.
void
CallableStatement.registerOutParameter(int paramIndex, int sqlType, String typeName)
This method registers the specified parameter as an output parameter of the specified SQL type.
void
CallableStatement.registerOutParameter(String parameterName, int sqlType)
This method registers the specified parameter as an output parameter of the specified SQL type.
void
CallableStatement.registerOutParameter(String parameterName, int sqlType, int scale)
This method registers the specified parameter as an output parameter of the specified SQL type.
void
CallableStatement.registerOutParameter(String parameterName, int sqlType, String typeName)
This method registers the specified parameter as an output parameter of the specified SQL type.
boolean
ResultSet.relative(int rows)
This method moves the result set position relative to the current row.
void
void
This method rolls back any SQL statements executed on this connection since the last commit or rollback.
void
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
PreparedStatement.setAsciiStream(int parameterIndex, InputStream x, int length)
This method sets the specified parameter from the given Java ASCII InputStream value.
void
CallableStatement.setAsciiStream(String parameterName, InputStream x, int length)
OutputStream
Clob.setAsciiStream(long pos)
void
Connection.setAutoCommit(boolean autoCommit)
This method turns auto commit mode on or off.
void
PreparedStatement.setBigDecimal(int parameterIndex, BigDecimal x)
This method sets the specified parameter from the given Java java.math.BigDecimal value.
void
void
PreparedStatement.setBinaryStream(int parameterIndex, InputStream x, int length)
This method sets the specified parameter from the given Java binary InputStream value.
void
CallableStatement.setBinaryStream(String parameterName, InputStream x, int length)
OutputStream
void
This method sets the specified parameter from the given Java Blob value.
void
PreparedStatement.setBoolean(int parameterIndex, boolean x)
This method sets the specified parameter from the given Java boolean value.
void
CallableStatement.setBoolean(String parameterName, boolean x)
void
PreparedStatement.setByte(int parameterIndex, byte x)
This method sets the specified parameter from the given Java byte value.
void
CallableStatement.setByte(String parameterName, byte x)
void
PreparedStatement.setBytes(int parameterIndex, byte[] x)
This method sets the specified parameter from the given Java byte array value.
void
CallableStatement.setBytes(String parameterName, byte[] x)
int
Blob.setBytes(long pos, byte[] bytes)
int
Blob.setBytes(long pos, byte[] bytes, int offset, int len)
void
This method sets the name of the catalog in use by this connection.
void
PreparedStatement.setCharacterStream(int parameterIndex, Reader reader, int length)
This method sets the specified parameter from the given Java character Reader value.
void
CallableStatement.setCharacterStream(String parameterName, Reader reader, int length)
Writer
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
PreparedStatement.setDate(int parameterIndex, Date x)
This method sets the specified parameter from the given Java java.sql.Date value.
void
PreparedStatement.setDate(int parameterIndex, Date x, Calendar cal)
This method sets the specified parameter from the given Java java.sql.Date value.
void
CallableStatement.setDate(String parameterName, Date x)
void
CallableStatement.setDate(String parameterName, Date x, Calendar cal)
void
PreparedStatement.setDouble(int parameterIndex, double x)
This method sets the specified parameter from the given Java double value.
void
CallableStatement.setDouble(String parameterName, double x)
void
This method sets the local escape processing mode on or off.
void
This method provides a hint to the driver about which direction the result set will be processed in.
void
This method informs the driver which direction the result set will be accessed in.
void
This method provides a hint to the driver about how many rows at a time it should fetch from the database.
void
This method informs the driver how many rows it should fetch from the database at a time.
void
PreparedStatement.setFloat(int parameterIndex, float x)
This method sets the specified parameter from the given Java float value.
void
CallableStatement.setFloat(String parameterName, float x)
void
Connection.setHoldability(int holdability)
void
PreparedStatement.setInt(int parameterIndex, int x)
This method sets the specified parameter from the given Java int value.
void
CallableStatement.setInt(String parameterName, int x)
void
PreparedStatement.setLong(int parameterIndex, long x)
This method sets the specified parameter from the given Java long value.
void
CallableStatement.setLong(String parameterName, long x)
void
This method sets the limit for the maximum length of any column in bytes.
void
This method sets the maximum number of rows that can be present in a result set.
void
PreparedStatement.setNull(int parameterIndex, int sqlType)
This method populates the specified parameter with a SQL NULL value for the specified type.
void
PreparedStatement.setNull(int paramIndex, int sqlType, String typeName)
This method populates the specified parameter with a SQL NULL value for the specified type.
void
CallableStatement.setNull(String parameterName, int sqlType)
void
CallableStatement.setNull(String parameterName, int sqlType, String typeName)
void
PreparedStatement.setObject(int parameterIndex, Object x)
This method sets the specified parameter from the given Java Object value.
void
PreparedStatement.setObject(int parameterIndex, Object x, int targetSqlType)
This method sets the specified parameter from the given Java Object value.
void
PreparedStatement.setObject(int parameterIndex, Object x, int targetSqlType, int scale)
This method sets the specified parameter from the given Java Object value.
void
void
void
CallableStatement.setObject(String parameterName, Object x, int targetSqlType)
void
CallableStatement.setObject(String parameterName, Object x, int targetSqlType, int scale)
void
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
Savepoint
void
PreparedStatement.setShort(int parameterIndex, short x)
This method sets the specified parameter from the given Java short value.
void
CallableStatement.setShort(String parameterName, short x)
void
PreparedStatement.setString(int parameterIndex, String x)
This method sets the specified parameter from the given Java String value.
void
int
Clob.setString(long pos, String str)
int
Clob.setString(long pos, String str, int offset, int len)
void
PreparedStatement.setTime(int parameterIndex, Time x)
This method sets the specified parameter from the given Java java.sql.Time value.
void
PreparedStatement.setTime(int parameterIndex, Time x, Calendar cal)
This method sets the specified parameter from the given Java java.sql.Time value.
void
CallableStatement.setTime(String parameterName, Time x)
void
CallableStatement.setTime(String parameterName, Time x, Calendar cal)
void
PreparedStatement.setTimestamp(int parameterIndex, Timestamp x)
This method sets the specified parameter from the given Java java.sql.Timestamp value.
void
PreparedStatement.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
This method sets the specified parameter from the given Java java.sql.Timestamp value.
void
void
void
This method sets the current transaction isolation mode.
void
This method sets the mapping table for SQL types to Java classes.
void
PreparedStatement.setURL(int parameterIndex, URL x)
void
CallableStatement.setURL(String parameterName, URL val)
void
PreparedStatement.setUnicodeStream(int parameterIndex, InputStream x, int length)
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
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
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
boolean
This method tests whether or not the datbase supports the specified result type.
boolean
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
Blob.truncate(long len)
void
Clob.truncate(long len)
void
ResultSet.updateArray(int columnIndex, Array x)
void
void
ResultSet.updateAsciiStream(int columnIndex, InputStream x, int length)
This method updates the specified column from an ASCII text stream.
void
ResultSet.updateAsciiStream(String columnName, InputStream x, int length)
This method updates the specified column from an ASCII text stream.
void
ResultSet.updateBigDecimal(int columnIndex, BigDecimal x)
This method updates the specified column to have a BigDecimal value.
void
This method updates the specified column to have a BigDecimal value.
void
ResultSet.updateBinaryStream(int columnIndex, InputStream x, int length)
This method updates the specified column from a binary stream.
void
ResultSet.updateBinaryStream(String columnName, InputStream x, int length)
This method updates the specified column from a binary stream.
void
ResultSet.updateBlob(int columnIndex, Blob x)
void
ResultSet.updateBlob(String columnName, Blob x)
void
ResultSet.updateBoolean(int columnIndex, boolean x)
This method updates the specified column to have a boolean value.
void
ResultSet.updateBoolean(String columnName, boolean x)
This method updates the specified column to have a boolean value.
void
ResultSet.updateByte(int columnIndex, byte x)
This method updates the specified column to have a byte value.
void
ResultSet.updateByte(String columnName, byte x)
This method updates the specified column to have a byte value.
void
ResultSet.updateBytes(int columnIndex, byte[] x)
This method updates the specified column to have a byte array value.
void
ResultSet.updateBytes(String columnName, byte[] x)
This method updates the specified column to have a byte array value.
void
ResultSet.updateCharacterStream(int columnIndex, Reader x, int length)
This method updates the specified column from a character stream.
void
ResultSet.updateCharacterStream(String columnName, Reader reader, int length)
This method updates the specified column from a character stream.
void
ResultSet.updateClob(int columnIndex, Clob x)
void
ResultSet.updateClob(String columnName, Clob x)
void
ResultSet.updateDate(int columnIndex, Date x)
This method updates the specified column to have a java.sql.Date value.
void
ResultSet.updateDate(String columnName, Date x)
This method updates the specified column to have a java.sql.Date value.
void
ResultSet.updateDouble(int columnIndex, double x)
This method updates the specified column to have a double value.
void
ResultSet.updateDouble(String columnName, double x)
This method updates the specified column to have a double value.
void
ResultSet.updateFloat(int columnIndex, float x)
This method updates the specified column to have a float value.
void
ResultSet.updateFloat(String columnName, float x)
This method updates the specified column to have a float value.
void
ResultSet.updateInt(int columnIndex, int x)
This method updates the specified column to have an int value.
void
ResultSet.updateInt(String columnName, int x)
This method updates the specified column to have an int value.
void
ResultSet.updateLong(int columnIndex, long x)
This method updates the specified column to have a long value.
void
ResultSet.updateLong(String columnName, long x)
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
ResultSet.updateObject(int columnIndex, Object x)
This method updates the specified column to have an Object value.
void
ResultSet.updateObject(int columnIndex, Object x, int scale)
This method updates the specified column to have an Object value.
void
This method updates the specified column to have an Object value.
void
ResultSet.updateObject(String columnName, Object x, int scale)
This method updates the specified column to have an Object value.
void
ResultSet.updateRef(int columnIndex, Ref x)
void
ResultSet.updateRef(String columnName, Ref x)
void
This method updates the current row in the database.
void
ResultSet.updateShort(int columnIndex, short x)
This method updates the specified column to have a short value.
void
ResultSet.updateShort(String columnName, short x)
This method updates the specified column to have a short value.
void
ResultSet.updateString(int columnIndex, String x)
This method updates the specified column to have a String value.
void
This method updates the specified column to have a String value.
void
ResultSet.updateTime(int columnIndex, Time x)
This method updates the specified column to have a java.sql.Time value.
void
ResultSet.updateTime(String columnName, Time x)
This method updates the specified column to have a java.sql.Time value.
void
ResultSet.updateTimestamp(int columnIndex, Timestamp x)
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
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
This method writes the specified Java boolean to the SQL stream.
void
This method writes the specified Java byte to the SQL stream.
void
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
This method writes the specified Java double to the SQL stream.
void
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
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

Uses in package javax.sql

Constructors with parameter type java.sql.SQLException

Methods with return type java.sql.SQLException

SQLException

Methods which throw type java.sql.SQLException

void
void
void
Connection
Connection
Connection
Connection
DataSource.getConnection(String username, String password)
boolean
PrintWriter
PrintWriter
PrintWriter
int
int
int
int
int
ResultSet
ResultSet
Object[]
PooledConnection
PooledConnection
int
Map
String
XAConnection
XAConnection
XAResource
void
void
RowSet.setArray(int i, Array x)
void
RowSet.setAsciiStream(int parameterIndex, InputStream x, int length)
void
RowSetMetaData.setAutoIncrement(int columnIndex, boolean property)
void
RowSet.setBigDecimal(int parameterIndex, BigDecimal x)
void
RowSet.setBinaryStream(int parameterIndex, InputStream x, int length)
void
RowSet.setBlob(int i, Blob x)
void
RowSet.setBoolean(int parameterIndex, boolean x)
void
RowSet.setByte(int parameterIndex, byte x)
void
RowSet.setBytes(int parameterIndex, byte[] x)
void
RowSetMetaData.setCaseSensitive(int columnIndex, boolean property)
void
RowSetMetaData.setCatalogName(int columnIndex, String catalogName)
void
RowSet.setCharacterStream(int parameterIndex, Reader reader, int length)
void
RowSet.setClob(int i, Clob x)
void
RowSetMetaData.setColumnCount(int columnCount)
void
RowSetMetaData.setColumnDisplaySize(int columnIndex, int size)
void
RowSetMetaData.setColumnLabel(int columnIndex, String label)
void
RowSetMetaData.setColumnName(int columnIndex, String columnName)
void
RowSetMetaData.setColumnType(int columnIndex, int SQLType)
void
RowSetMetaData.setColumnTypeName(int columnIndex, String typeName)
void
void
RowSet.setConcurrency(int concurrency)
void
RowSetMetaData.setCurrency(int columnIndex, boolean property)
void
void
RowSet.setDate(int parameterIndex, Date x)
void
RowSet.setDate(int parameterIndex, Date x, Calendar cal)
void
RowSet.setDouble(int parameterIndex, double x)
void
RowSet.setEscapeProcessing(boolean enable)
void
RowSet.setFloat(int parameterIndex, float x)
void
RowSet.setInt(int parameterIndex, int x)
void
void
void
void
void
void
void
RowSet.setLong(int parameterIndex, long x)
void
void
RowSet.setMaxRows(int max)
void
void
RowSet.setNull(int parameterIndex, int sqlType)
void
RowSet.setNull(int paramIndex, int sqlType, String typeName)
void
RowSetMetaData.setNullable(int columnIndex, int property)
void
RowSet.setObject(int parameterIndex, Object x)
void
RowSet.setObject(int parameterIndex, Object x, int targetSqlType)
void
RowSet.setObject(int parameterIndex, Object x, int targetSqlType, int scale)
void
void
RowSetMetaData.setPrecision(int columnIndex, int precision)
void
RowSet.setQueryTimeout(int seconds)
void
RowSet.setReadOnly(boolean value)
void
RowSet.setRef(int i, Ref x)
void
RowSetMetaData.setScale(int columnIndex, int scale)
void
RowSetMetaData.setSchemaName(int columnIndex, String schemaName)
void
RowSetMetaData.setSearchable(int columnIndex, boolean property)
void
RowSet.setShort(int parameterIndex, short x)
void
RowSetMetaData.setSigned(int columnIndex, boolean property)
void
RowSet.setString(int parameterIndex, String x)
void
RowSetMetaData.setTableName(int columnIndex, String tableName)
void
RowSet.setTime(int parameterIndex, Time x)
void
RowSet.setTime(int parameterIndex, Time x, Calendar cal)
void
RowSet.setTimestamp(int parameterIndex, Timestamp x)
void
RowSet.setTimestamp(int parameterIndex, Timestamp x, Calendar cal)
void
void
RowSet.setType(int type)
void
void
void
boolean