Please note that the contents of this offline web site may be out of date. To access the most recent documentation visit the online version .
Note that links that point to online resources are green in color and will open in a new window.
We would love it if you could give us feedback about this material by filling this form (You have to be online to fill it)

Interfaces
- Array
- Blob
- CallableStatement
- Clob
- Connection
- DatabaseMetaData
- Driver
- NClob
- ParameterMetaData
- PreparedStatement
- Ref
- ResultSet
- ResultSetMetaData
- RowId
- Savepoint
- SQLData
- SQLInput
- SQLOutput
- SQLXML
- Statement
- Struct
- Wrapper
Classes
- Date
- DriverManager
- DriverPropertyInfo
- SQLPermission
- Time
- Timestamp
- Types
Enums
- ClientInfoStatus
- RowIdLifetime
Exceptions

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

Added in API level 1

public class

SQLException

extends Exception
implements Serializable Iterable <T>

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

Known Direct Subclasses

BatchUpdateException , SQLClientInfoException , SQLNonTransientException , SQLRecoverableException , SQLTransientException , SQLWarning

Known Indirect Subclasses

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

DataTruncation	An exception which is thrown when a JDBC driver unexpectedly truncates a data value either when reading (resulting in warning), or when writing data (resulting in an error).
SQLDataException	An exception, which is subclass of SQLException, is thrown when various data errors arise.
SQLFeatureNotSupportedException	An exception, which is subclass of SQLNonTransientException, is thrown when various the JDBC driver does not support an optional JDBC feature.
SQLIntegrityConstraintViolationException	An exception, which is subclass of SQLNonTransientException, is thrown when various the an integrity constraint (foreign key, primary key or unique key) has been violated.
SQLInvalidAuthorizationSpecException	An exception, which is subclass of SQLNonTransientException, is thrown when the authorization credentials presented during connection establishment are not valid.
SQLNonTransientConnectionException	An exception, which is subclass of SQLException, is thrown when the connection operation that failed will not succeed when the operation is retried without the cause of the failure being corrected.
SQLSyntaxErrorException
SQLTimeoutException
SQLTransactionRollbackException
SQLTransientConnectionException

Class Overview

An exception that indicates a failed JDBC operation. It provides the following information about problems encountered with database access:

A message string.
A SQLState error description string following either SQL 99 or X/OPEN SQLState conventions. getSQLStateType() exposes the specific convention in use.
A database-specific error code.
The next exception in the chain.

Summary

Public Constructors
	SQLException () Creates an `SQLException` object.
	SQLException ( String theReason) Creates an `SQLException` object.
	SQLException ( String theReason, String theSQLState) Creates an `SQLException` object.
	SQLException ( String theReason, String theSQLState, int theErrorCode) Creates an `SQLException` object.
	SQLException ( Throwable theCause) Creates an SQLException object.
	SQLException ( String theReason, Throwable theCause) Creates an SQLException object.
	SQLException ( String theReason, String theSQLState, Throwable theCause) Creates an SQLException object.
	SQLException ( String theReason, String theSQLState, int theErrorCode, Throwable theCause) Creates an SQLException object.

Public Methods
int	getErrorCode () Returns the integer error code for this `SQLException` .
SQLException	getNextException () Retrieves the `SQLException` chained to this `SQLException` , if any.
String	getSQLState () Retrieves the `SQLState` description string for this `SQLException` object.
Iterator < Throwable >	iterator () Obsolete.
void	setNextException ( SQLException ex) Obsolete.

[Expand]

Inherited Methods

From class java.lang.Throwable

final void	addSuppressed ( Throwable throwable) Adds `throwable` to the list of throwables suppressed by this.
Throwable	fillInStackTrace () Records the stack trace from the point where this method has been called to this `Throwable` .
Throwable	getCause () Returns the cause of this `Throwable` , or `null` if there is no cause.
String	getLocalizedMessage () Returns the detail message which was provided when this `Throwable` was created.
String	getMessage () Returns the detail message which was provided when this `Throwable` was created.
StackTraceElement[]	getStackTrace () Returns a clone of the array of stack trace elements of this `Throwable` .
final Throwable[]	getSuppressed () Returns the throwables suppressed by this.
Throwable	initCause ( Throwable throwable) Initializes the cause of this `Throwable` .
void	printStackTrace ( PrintStream err) Writes a printable representation of this `Throwable` 's stack trace to the given print stream.
void	printStackTrace ( PrintWriter err) Writes a printable representation of this `Throwable` 's stack trace to the specified print writer.
void	printStackTrace () Writes a printable representation of this `Throwable` 's stack trace to the `System.err` stream.
void	setStackTrace ( StackTraceElement[] trace) Sets the array of stack trace elements.
String	toString () Returns a string containing a concise, human-readable description of this object.

From class java.lang.Object

Object	clone () Creates and returns a copy of this `Object` .
boolean	equals ( Object o) Compares this instance with the specified object and indicates if they are equal.
void	finalize () Invoked when the garbage collector has detected that this instance is no longer reachable.
final Class <?>	getClass () Returns the unique instance of `Class` that represents this object's class.
int	hashCode () Returns an integer hash code for this object.
final void	notify () Causes a thread which is waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up.
final void	notifyAll () Causes all threads which are waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up.
String	toString () Returns a string containing a concise, human-readable description of this object.
final void	wait () Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object.
final void	wait (long millis, int nanos) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires.
final void	wait (long millis) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires.

From interface java.lang.Iterable

Public Constructors

public SQLException ()

Added in API level 1

Creates an SQLException object. The reason string is set to null , the SQLState string is set to null and the error code is set to 0.

public SQLException ( String theReason)

Added in API level 1

Creates an SQLException object. The reason string is set to the given reason string, the SQLState string is set to null and the error code is set to 0.

Parameters

theReason	the string to use as the Reason string

public SQLException ( String theReason, String theSQLState)

Added in API level 1

Creates an SQLException object. The reason string is set to the given reason string, the SQLState string is set to the given SQLState string and the error code is set to 0.

Parameters

theReason	the string to use as the reason string.
theSQLState	the string to use as the `SQLState` string.

public SQLException ( String theReason, String theSQLState, int theErrorCode)

Added in API level 1

Creates an SQLException object. The reason string is set to the given reason string, the SQLState string is set to the given SQLState string and the error code is set to the given error code value.

Parameters

theReason	the string to use as the reason string.
theSQLState	the string to use as the `SQLState` string.
theErrorCode	the integer value for the error code.

public SQLException ( Throwable theCause)

Added in API level 9

Creates an SQLException object. The Reason string is set to the null if cause == null or cause.toString() if cause!=null,and the cause Throwable object is set to the given cause Throwable object.

Parameters

theCause	the Throwable object for the underlying reason this SQLException

public SQLException ( String theReason, Throwable theCause)

Added in API level 9

Creates an SQLException object. The Reason string is set to the given and the cause Throwable object is set to the given cause Throwable object.

Parameters

theReason	the string to use as the Reason string
theCause	the Throwable object for the underlying reason this SQLException

public SQLException ( String theReason, String theSQLState, Throwable theCause)

Added in API level 9

Creates an SQLException object. The Reason string is set to the given reason string, the SQLState string is set to the given SQLState string and the cause Throwable object is set to the given cause Throwable object.

Parameters

theReason	the string to use as the Reason string
theSQLState	the string to use as the SQLState string
theCause	the Throwable object for the underlying reason this SQLException

public SQLException ( String theReason, String theSQLState, int theErrorCode, Throwable theCause)

Added in API level 9

Creates an SQLException object. The Reason string is set to the given reason string, the SQLState string is set to the given SQLState string , the Error Code is set to the given error code value, and the cause Throwable object is set to the given cause Throwable object.

Parameters

theReason	the string to use as the Reason string
theSQLState	the string to use as the SQLState string
theErrorCode	the integer value for the error code
theCause	the Throwable object for the underlying reason this SQLException

Public Methods

public int getErrorCode ()

Added in API level 1

Returns the integer error code for this SQLException .

Returns

The integer error code for this SQLException . The meaning of the code is specific to the vendor of the database.

public SQLException getNextException ()

Added in API level 1

Retrieves the SQLException chained to this SQLException , if any.

Returns

The SQLException chained to this SQLException . null if there is no SQLException chained to this SQLException .

public String getSQLState ()

Added in API level 1

Retrieves the SQLState description string for this SQLException object.

Returns

The SQLState string for this SQLException object. This is an error description string which follows either the SQL 99 conventions or the X/OPEN SQLstate conventions. The potential values of the SQLState string are described in each of the specifications. Which of the conventions is being used by the SQLState string can be discovered by using the getSQLStateType method of the DatabaseMetaData interface.

public Iterator < Throwable > iterator ()

Added in API level 9

Obsolete. getCause() should be used instead of this iterator. Returns an iterator over the exceptions added with setNextException(SQLException) .

Returns

An Iterator instance.

public void setNextException ( SQLException ex)

Added in API level 1

Obsolete. Appends ex to the end of this chain.

Results

Interfaces

Classes

Enums

Exceptions

SQLException

Class Overview

See Also

Summary

Public Constructors

public SQLException ()

public SQLException ( String theReason)

Parameters

public SQLException ( String theReason, String theSQLState)

Parameters

public SQLException ( String theReason, String theSQLState, int theErrorCode)

Parameters

public SQLException ( Throwable theCause)

Parameters

public SQLException ( String theReason, Throwable theCause)

Parameters

public SQLException ( String theReason, String theSQLState, Throwable theCause)

Parameters

public SQLException ( String theReason, String theSQLState, int theErrorCode, Throwable theCause)

Parameters

Public Methods

public int getErrorCode ()

Returns

public SQLException getNextException ()

Returns

public String getSQLState ()

Returns

public Iterator < Throwable > iterator ()

Returns

public void setNextException ( SQLException ex)