Added in API level 1

SQLException

open class SQLException : Exception, MutableIterable<Throwable!>

kotlin.Any
↳	kotlin.Throwable
	↳	java.lang.Exception
		↳	java.sql.SQLException

Known Direct Subclasses BatchUpdateException, SQLClientInfoException, SQLNonTransientException, SQLRecoverableException, SQLTransientException, SQLWarning BatchUpdateException The subclass of SQLException thrown when an error occurs during a batch update operation. SQLClientInfoException The subclass of SQLException is thrown when one or more client info properties could not be set on a Connection. SQLNonTransientException The subclass of SQLException thrown when an instance where a retry of the same operation would fail unless the cause of the SQLException is corrected. SQLRecoverableException The subclass of SQLException thrown in situations where a previously failed operation might be able to succeed if the application performs some recovery steps and retries the entire transaction or in the case of a distributed transaction, the transaction branch. SQLTransientException The subclass of SQLException is thrown in situations where a previoulsy failed operation might be able to succeed when the operation is retried without any intervention by application-level functionality. SQLWarning An exception that provides information on database access warnings.

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', or under vendor-specified conditions. 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', or under vendor-specified conditions. SQLInvalidAuthorizationSpecException The subclass of SQLException thrown when the SQLState class value is '28', or under vendor-specified conditions. SQLNonTransientConnectionException The subclass of SQLException thrown for the SQLState class value '08', or under vendor-specified conditions. SQLSyntaxErrorException The subclass of SQLException thrown when the SQLState class value is '42', or under vendor-specified conditions. 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', or under vendor-specified conditions. SQLTransientConnectionException The subclass of SQLException for the SQLState class value '08', or under vendor-specified conditions.

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() Constructs a SQLException object.
SQLException(reason: String!) Constructs a SQLException object with a given reason.
SQLException(reason: String!, SQLState: String!) Constructs a SQLException object with a given reason and SQLState.
SQLException(reason: String!, SQLState: String!, vendorCode: Int) Constructs a SQLException object with a given reason, SQLState and vendorCode.
SQLException(reason: String!, sqlState: String!, vendorCode: Int, cause: Throwable!) Constructs a SQLException object with a given reason, SQLState, vendorCode and cause.
SQLException(reason: String!, sqlState: String!, cause: Throwable!) Constructs a SQLException object with a given reason, SQLState and cause.
SQLException(reason: String!, cause: Throwable!) Constructs a SQLException object with a given reason and cause.
SQLException(cause: Throwable!) Constructs a SQLException object with a given cause.

Public methods
open Int	getErrorCode() Retrieves the vendor-specific exception code for this SQLException object.
open SQLException!	getNextException() Retrieves the exception chained to this SQLException object by setNextException(SQLException ex).
open String!	getSQLState() Retrieves the SQLState for this SQLException object.
open MutableIterator<Throwable!>	iterator() Returns an iterator over the chained SQLExceptions.
open Unit	setNextException(ex: SQLException!) Adds an SQLException object to the end of the chain.

Public constructors

SQLException

Added in API level 1

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 Throwable.initCause(java.lang.Throwable) method.

SQLException

Added in API level 1

SQLException(reason: String!)

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 Throwable.initCause(java.lang.Throwable) method.

Parameters
reason	String!: a description of the exception

SQLException

Added in API level 1

SQLException(
    reason: String!, 
    SQLState: String!)

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 Throwable.initCause(java.lang.Throwable) method. The vendor code is initialized to 0.

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

SQLException

Added in API level 1

SQLException(
    reason: String!, 
    SQLState: String!, 
    vendorCode: Int)

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 Throwable.initCause(java.lang.Throwable) method.

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

SQLException

Added in API level 9

SQLException(
    reason: String!, 
    sqlState: String!, 
    vendorCode: Int, 
    cause: Throwable!)

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

Parameters
reason	String!: a description of the exception
sqlState	String!: an XOPEN or SQL:2003 code identifying the exception
vendorCode	Int: a database vendor-specific exception code
cause	Throwable!: 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.

SQLException

Added in API level 9

SQLException(
    reason: String!, 
    sqlState: String!, 
    cause: Throwable!)

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

Parameters
reason	String!: a description of the exception.
sqlState	String!: an XOPEN or SQL:2003 code identifying the exception
cause	Throwable!: 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.

SQLException

Added in API level 9

SQLException(
    reason: String!, 
    cause: Throwable!)

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	String!: a description of the exception.
cause	Throwable!: 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.

SQLException

Added in API level 9

SQLException(cause: Throwable!)

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	Throwable!: 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

getErrorCode

Added in API level 1

open fun getErrorCode(): Int

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

Return
Int	the vendor's error code

getNextException

Added in API level 1

open fun getNextException(): SQLException!

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

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

See Also

• #setNextException

getSQLState

Added in API level 1

open fun getSQLState(): String!

Retrieves the SQLState for this SQLException object.

Return
String!	the SQLState value

iterator

Added in API level 9

open fun iterator(): MutableIterator<Throwable!>

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

Return
MutableIterator<Throwable!>	an iterator over the chained SQLExceptions and causes in the proper order

setNextException

Added in API level 1

open fun setNextException(ex: SQLException!): Unit

Adds an SQLException object to the end of the chain.

Parameters
ex	SQLException!: the new exception that will be added to the end of the SQLException chain

See Also

• #getNextException