Uses of Class java.sql.SQLException

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

Map
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
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
RowSet.setTypeMap(Map> map)
void
void
boolean

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

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
Driver.connect(String url, Properties properties)
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
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.
Object
Array.getArray(Map> map)
Returns the contents of this array.
Array
This method returns the value of the specified parameter as a Java Array.
Array
ResultSet.getArray(int columnIndex)
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
Array.getArray(long start, int count)
Returns a portion of this array starting at start into the array and continuing for count elements.
Object
Array.getArray(long start, int count, Map> map)
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
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
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 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
This method returns the value of the specified parameter as a Java Blob.
Blob
ResultSet.getBlob(int columnIndex)
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
ResultSet.getBlob(String columnName)
This method returns the specified column value as a BLOB.
boolean
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
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
This method returns the value of the specified parameter as a Java byte.
byte
ResultSet.getByte(String columnName)
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 array.
byte[]
ResultSet.getBytes(int columnIndex)
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[]
Blob.getBytes(long start, int count)
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 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
This method returns the value of the specified parameter as a Java Clob.
Clob
ResultSet.getClob(int columnIndex)
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
ResultSet.getClob(String columnName)
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 tableName, String columnPattern)
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 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
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
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
This method returns the value of the specified parameter as a Java java.sql.Date.
Date
ResultSet.getDate(String columnName)
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
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
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
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
DatabaseMetaData.getExportedKeys(String catalog, String schema, String tableName)
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
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
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 ResultSetS that are created from StatementS using this Connection.
String
This metohd returns the quote string for SQL identifiers.
ResultSet
DatabaseMetaData.getImportedKeys(String catalog, String schema, String tableName)
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
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
This method returns the value of the specified parameter as a Java int.
int
ResultSet.getInt(String columnName)
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
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
This method returns the value of the specified parameter as a Java 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
Ref.getObject(Map> map)
Object
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 columnIndex, 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
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