All Implemented Interfaces:

Serializable, Iterable<Throwable>

Direct Known Subclasses:

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

public class SQLException
extends Exception
implements Iterable<Throwable>

Since:

1.1

See Also:

Serialized Form

• Constructor Summary

  Constructors 

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

• Method Summary

  Modifier and Type	Method	Description
  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.

  Methods declared in class java.lang.Throwable

  addSuppressed, fillInStackTrace, getCause, getLocalizedMessage, getMessage, getStackTrace, getSuppressed, initCause, printStackTrace, printStackTrace, printStackTrace, setStackTrace, toString

• Constructor Details

  • SQLException

    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.

    Parameters:

    reason - a description of the exception

    SQLState - an XOPEN or SQL:2003 code identifying the exception

    vendorCode - a database vendor-specific exception code

  • SQLException

    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.

    Parameters:

    reason - a description of the exception

    SQLState - an XOPEN or SQL:2003 code identifying the exception

  • SQLException

    public SQLException​(String reason)

    Constructs a SQLException object with a given reason. The SQLState is 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.

    Parameters:

    reason - a description of the exception

  • SQLException

    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.

  • SQLException

    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.

    Since:

    1.6

  • SQLException

    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.

    Since:

    1.6

  • SQLException

    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.

    Since:

    1.6

  • SQLException

    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.

    Since:

    1.6

• Method Details

  • getSQLState

    public String getSQLState()

    Retrieves the SQLState for this SQLException object.

    Returns:

    the SQLState value

  • getErrorCode

    public int getErrorCode()

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

    Returns:

    the vendor's error code

  • 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

    See Also:

    setNextException(java.sql.SQLException)

  • setNextException

    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

    See Also:

    getNextException()

  • iterator

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

    Specified by:

    iterator in interface Iterable<Throwable>

    Returns:

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

    Since:

    1.6