java.sql
public class: SQLException [javadoc |
source]
java.lang.Object
java.lang.Throwable
java.lang.Exception
java.sql.SQLException
All Implemented Interfaces:
Iterable, Serializable
Direct Known Subclasses:
SQLFeatureNotSupportedException, SyncProviderException, SQLRecoverableException, SQLTransientConnectionException, SQLTransientException, SQLIntegrityConstraintViolationException, BatchUpdateException, SQLInvalidAuthorizationSpecException, SQLNonTransientConnectionException, SQLWarning, SQLTimeoutException, SyncFactoryException, SQLSyntaxErrorException, SQLTransactionRollbackException, SQLClientInfoException, SQLDataException, RowSetWarning, SQLNonTransientException, DataTruncation, SerialException
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.
| Constructor: |
public SQLException() {
super();
this.SQLState = null;
this.vendorCode = 0;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
}
}
}
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(String reason) {
super(reason);
this.SQLState = null;
this.vendorCode = 0;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
}
}
}
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 - a description of the exception
|
public SQLException(Throwable cause) {
super(cause);
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
}
}
}
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 -
|
public SQLException(String reason,
String SQLState) {
super(reason);
this.SQLState = SQLState;
this.vendorCode = 0;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
DriverManager.println("SQLException: SQLState(" + 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
|
public SQLException(String reason,
Throwable cause) {
super(reason,cause);
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
}
}
}
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 -
|
public SQLException(String reason,
String SQLState,
int vendorCode) {
super(reason);
this.SQLState = SQLState;
this.vendorCode = vendorCode;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
DriverManager.println("SQLState(" + SQLState +
") vendor code(" + vendorCode + ")");
printStackTrace(DriverManager.getLogWriter());
}
}
}
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
|
public SQLException(String reason,
String sqlState,
Throwable cause) {
super(reason,cause);
this.SQLState = sqlState;
this.vendorCode = 0;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
printStackTrace(DriverManager.getLogWriter());
DriverManager.println("SQLState(" + SQLState + ")");
}
}
}
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 -
|
public SQLException(String reason,
String sqlState,
int vendorCode,
Throwable cause) {
super(reason,cause);
this.SQLState = sqlState;
this.vendorCode = vendorCode;
if (!(this instanceof SQLWarning)) {
if (DriverManager.getLogWriter() != null) {
DriverManager.println("SQLState(" + SQLState +
") vendor code(" + vendorCode + ")");
printStackTrace(DriverManager.getLogWriter());
}
}
}
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 -
|
| Methods from java.lang.Throwable: |
|---|
|
fillInStackTrace, getCause, getLocalizedMessage, getMessage, getStackTrace, initCause, printStackTrace, printStackTrace, printStackTrace, setStackTrace, toString |
| Methods from java.lang.Object: |
|---|
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method from java.sql.SQLException Detail: |
public int getErrorCode() {
return (vendorCode);
}
Retrieves the vendor-specific exception code
for this SQLException object. |
public SQLException getNextException() {
return (next);
}
Retrieves the exception chained to this
SQLException object by setNextException(SQLException ex). |
public String getSQLState() {
return (SQLState);
}
Retrieves the SQLState for this SQLException object. |
public Iterator iterator() {
return new Iterator< Throwable >() {
SQLException firstException = SQLException.this;
SQLException nextException = firstException.getNextException();
Throwable cause = firstException.getCause();
public boolean hasNext() {
if(firstException != null || nextException != null || cause != null)
return true;
return false;
}
public Throwable next() {
Throwable throwable = null;
if(firstException != null){
throwable = firstException;
firstException = null;
}
else if(cause != null){
throwable = cause;
cause = cause.getCause();
}
else if(nextException != null){
throwable = nextException;
cause = nextException.getCause();
nextException = nextException.getNextException();
}
else
throw new NoSuchElementException();
return throwable;
}
public void remove() {
throw new UnsupportedOperationException();
}
};
}
Returns an iterator over the chained SQLExceptions. The iterator will
be used to iterate over each SQLException and its underlying cause
(if any). |
public void setNextException(SQLException ex) {
SQLException current = this;
for(;;) {
SQLException next=current.next;
if (next != null) {
current = next;
continue;
}
if (nextUpdater.compareAndSet(current,null,ex)) {
return;
}
current=current.next;
}
}
Adds an SQLException object to the end of the chain. |