public class java.sql
SQLException


Hide details Login
Java SE 6
  
Extends: Throwable > Exception
Implements: Iterable
Extended by: BatchUpdateException, RowSetWarning, SerialException, SQLClientInfoException, SQLNonTransientException, SQLRecoverableException, SQLTransientException, SQLWarning, SyncFactoryException, SyncProviderException

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

Each SQLException provides several kinds of information:


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

reasona description of the exception
SQLStatean XOPEN or SQL:2003 code identifying the exception
vendorCodea 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 Throwable#initCause(java.lang.Throwable) method. The vendor code is initialized to 0.

reasona description of the exception
SQLStatean 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 Throwable#initCause(java.lang.Throwable) method.

reasona 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 Throwable#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.

causethe 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.
since1.6

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.

reasona description of the exception.
causethe 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.
since1.6

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.

reasona description of the exception.
sqlStatean XOPEN or SQL:2003 code identifying the exception
causethe 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.
since1.6

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

reasona description of the exception
sqlStatean XOPEN or SQL:2003 code identifying the exception
vendorCodea database vendor-specific exception code
causethe 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.
since1.6


Methods
public Iterator iterator()
Returns an iterator over the chained SQLExceptions. The iterator will be used to iterate over each SQLException and its underlying cause (if any).
returnan iterator over the chained SQLExceptions and causes in the proper order
since1.6

Properties
public int getErrorCode()
Retrieves the vendor-specific exception code for this SQLException object.
returnthe vendor's error code
public void setNextException(SQLException ex)
Adds an SQLException object to the end of the chain.
exthe new exception that will be added to the end of the SQLException chain
See also getNextException
public SQLException getNextException()
Retrieves the exception chained to this SQLException object by setNextException(SQLException ex).
returnthe next SQLException object in the chain; null if there are none
See also setNextException
public String getSQLState()
Retrieves the SQLState for this SQLException object.
returnthe SQLState value