Summary: Ctors | Methods | Inherited Methods | [Expand All]

public class

SQLException

extends Exception
implements Iterable<T>

java.lang.Object
↳	java.lang.Throwable
	↳	java.lang.Exception
		↳	java.sql.SQLException

Known Direct Subclasses

BatchUpdateException, RowSetWarning, SQLClientInfoException, SQLNonTransientException, SQLRecoverableException, SQLTransientException, SQLWarning, SerialException, SyncFactoryException, SyncProviderException

Known Indirect Subclasses

DataTruncation, SQLDataException, SQLFeatureNotSupportedException, SQLIntegrityConstraintViolationException, SQLInvalidAuthorizationSpecException, SQLNonTransientConnectionException, SQLSyntaxErrorException, SQLTimeoutException, SQLTransactionRollbackException, SQLTransientConnectionException

DataTruncation	An exception thrown as a `DataTruncation` exception (on writes) or reported as a `DataTruncation` warning (on reads) when a data values is unexpectedly truncated for reasons other than its having execeeded `MaxFieldSize`.
SQLDataException	The subclass of `SQLException` thrown when the SQLState class value is '22'.
SQLFeatureNotSupportedException	The subclass of `SQLException` thrown when the SQLState class value is '0A' ( the value is 'zero' A).
SQLIntegrityConstraintViolationException	The subclass of `SQLException` thrown when the SQLState class value is '23'.
SQLInvalidAuthorizationSpecException	The subclass of `SQLException` thrown when the SQLState class value is '28'.
SQLNonTransientConnectionException	The subclass of `SQLException` thrown for the SQLState class value '08', representing that the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.
SQLSyntaxErrorException	The subclass of `SQLException` thrown when the SQLState class value is '42'.
SQLTimeoutException	The subclass of `SQLException` thrown when the timeout specified by `Statement` has expired.
SQLTransactionRollbackException	The subclass of `SQLException` thrown when the SQLState class value is '40'.
SQLTransientConnectionException	The subclass of `SQLException` for the SQLState class value '08', representing that the connection operation that failed might be able to succeed when the operation is retried without any application-level changes.

Class Overview

An exception that provides information on a database access error or other errors.

Each SQLException provides several kinds of information:

a string describing the error. This is used as the Java Exception message, available via the method getMesasge.
a "SQLstate" string, which follows either the XOPEN SQLstate conventions or the SQL:2003 conventions. The values of the SQLState string are described in the appropriate spec. The DatabaseMetaData method getSQLStateType can be used to discover whether the driver returns the XOPEN type or the SQL:2003 type.
an integer error code that is specific to each vendor. Normally this will be the actual error code returned by the underlying database.
a chain to a next Exception. This can be used to provide additional error information.
the causal relationship, if any for this SQLException.

Summary

Public Constructors
	SQLException(String reason, String SQLState, int vendorCode) Constructs a `SQLException` object with a given `reason`, `SQLState` and `vendorCode`.
	SQLException(String reason, String SQLState) Constructs a `SQLException` object with a given `reason` and `SQLState`.
	SQLException(String reason) Constructs a `SQLException` object with a given `reason`.
	SQLException() Constructs a `SQLException` object.
	SQLException(Throwable cause) Constructs a `SQLException` object with a given `cause`.
	SQLException(String reason, Throwable cause) Constructs a `SQLException` object with a given `reason` and `cause`.
	SQLException(String reason, String sqlState, Throwable cause) Constructs a `SQLException` object with a given `reason`, `SQLState` and `cause`.
	SQLException(String reason, String sqlState, int vendorCode, Throwable cause) Constructs a `SQLException` object with a given `reason`, `SQLState`, `vendorCode` and `cause`.

Public Methods
int	getErrorCode() Retrieves the vendor-specific exception code for this `SQLException` object.
SQLException	getNextException() Retrieves the exception chained to this `SQLException` object by setNextException(SQLException ex).
String	getSQLState() Retrieves the SQLState for this `SQLException` object.
Iterator<Throwable>	iterator() Returns an iterator over the chained SQLExceptions.
void	setNextException(SQLException ex) Adds an `SQLException` object to the end of the chain.

[Expand]

Inherited Methods

From class java.lang.Throwable

From class java.lang.Object

Object	clone() Creates and returns a copy of this object.
boolean	equals(Object obj) Indicates whether some other object is "equal to" this one.
void	finalize() Called by the garbage collector on an object when garbage collection determines that there are no more references to the object.
final Class<?>	getClass() Returns the runtime class of this `Object`.
int	hashCode() Returns a hash code value for the object.
final void	notify() Wakes up a single thread that is waiting on this object's monitor.
final void	notifyAll() Wakes up all threads that are waiting on this object's monitor.
String	toString() Returns a string representation of the object.
final void	wait() Causes the current thread to wait until another thread invokes the `notify()` method or the `notifyAll()` method for this object.
final void	wait(long timeout, int nanos) Causes the current thread to wait until another thread invokes the `notify()` method or the `notifyAll()` method for this object, or some other thread interrupts the current thread, or a certain amount of real time has elapsed.
final void	wait(long timeout) Causes the current thread to wait until either another thread invokes the `notify()` method or the `notifyAll()` method for this object, or a specified amount of time has elapsed.

From interface java.lang.Iterable

Public Constructors

public SQLException (String reason, String SQLState, int vendorCode)

Constructs a SQLException object with a given reason, SQLState and vendorCode. The cause is not initialized, and may subsequently be initialized by a call to the initCause(java.lang.Throwable) method.

Parameters

reason	a description of the exception
SQLState	an XOPEN or SQL:2003 code identifying the exception
vendorCode	a database vendor-specific exception code

public SQLException (String reason, String SQLState)

Constructs a SQLException object with a given reason and SQLState. The cause is not initialized, and may subsequently be initialized by a call to the initCause(java.lang.Throwable) method. The vendor code is initialized to 0.

Parameters

reason	a description of the exception
SQLState	an XOPEN or SQL:2003 code identifying the exception

public SQLException (String reason)

Constructs a SQLException object with a given reason. The SQLState is initialized to null and the vender code is initialized to 0. The cause is not initialized, and may subsequently be initialized by a call to the initCause(java.lang.Throwable) method.

Parameters

reason	a description of the exception

public SQLException ()

Constructs a SQLException object. The reason, SQLState are initialized to null and the vendor code is initialized to 0. The cause is not initialized, and may subsequently be initialized by a call to the initCause(java.lang.Throwable) method.

public SQLException (Throwable cause)

Constructs a SQLException object with a given cause. The SQLState is initialized to null and the vendor code is initialized to 0. The reason is initialized to null if cause==null or to cause.toString() if cause!=null.

Parameters

cause	the underlying reason for this `SQLException` (which is saved for later retrieval by the `getCause()` method); may be null indicating the cause is non-existent or unknown.

public SQLException (String reason, Throwable cause)

Constructs a SQLException object with a given reason and cause. The SQLState is initialized to null and the vendor code is initialized to 0.

Parameters

reason	a description of the exception.
cause	the underlying reason for this `SQLException` (which is saved for later retrieval by the `getCause()` method); may be null indicating the cause is non-existent or unknown.

public SQLException (String reason, String sqlState, Throwable cause)

Constructs a SQLException object with a given reason, SQLState and cause. The vendor code is initialized to 0.

Parameters

reason	a description of the exception.
sqlState	an XOPEN or SQL:2003 code identifying the exception
cause	the underlying reason for this `SQLException` (which is saved for later retrieval by the `getCause()` method); may be null indicating the cause is non-existent or unknown.

public SQLException (String reason, String sqlState, int vendorCode, Throwable cause)

Constructs a SQLException object with a given reason, SQLState, vendorCode and cause.

Parameters

reason	a description of the exception
sqlState	an XOPEN or SQL:2003 code identifying the exception
vendorCode	a database vendor-specific exception code
cause	the underlying reason for this `SQLException` (which is saved for later retrieval by the `getCause()` method); may be null indicating the cause is non-existent or unknown.

Public Methods

public int getErrorCode ()

Retrieves the vendor-specific exception code for this SQLException object.

Returns

the vendor's error code

public SQLException getNextException ()

Retrieves the exception chained to this SQLException object by setNextException(SQLException ex).

Returns

the next SQLException object in the chain; null if there are none

public String getSQLState ()

Retrieves the SQLState for this SQLException object.

Returns

the SQLState value

public Iterator<Throwable> iterator ()

Returns an iterator over the chained SQLExceptions. The iterator will be used to iterate over each SQLException and its underlying cause (if any).

Returns

an iterator over the chained SQLExceptions and causes in the proper order

public void setNextException (SQLException ex)

Adds an SQLException object to the end of the chain.

Parameters

ex	the new exception that will be added to the end of the `SQLException` chain

Interfaces

Classes

Enums

Exceptions

SQLException

Class Overview

Summary

Public Constructors

public SQLException (String reason, String SQLState, int vendorCode)

Parameters

public SQLException (String reason, String SQLState)

Parameters

public SQLException (String reason)

Parameters

public SQLException ()

public SQLException (Throwable cause)

Parameters

public SQLException (String reason, Throwable cause)

Parameters

public SQLException (String reason, String sqlState, Throwable cause)

Parameters

public SQLException (String reason, String sqlState, int vendorCode, Throwable cause)

Parameters

Public Methods

public int getErrorCode ()

Returns

public SQLException getNextException ()

Returns

See Also

public String getSQLState ()

Returns

public Iterator<Throwable> iterator ()

Returns

public void setNextException (SQLException ex)

Parameters

See Also