Class SQLSyntaxErrorException

java.lang.Object

java.lang.Throwable

java.lang.Exception

java.sql.SQLException

java.sql.SQLNonTransientException

java.sql.SQLSyntaxErrorException

All Implemented Interfaces:

Serializable, Iterable<Throwable>

public class SQLSyntaxErrorException
extends SQLNonTransientException

The subclass of SQLException thrown when the SQLState class value is '42', or under vendor-specified conditions. This indicates that the in-progress query has violated SQL syntax rules.

Please consult your driver vendor documentation for the vendor-specified conditions for which this Exception may be thrown.

Since:

1.6

See Also:

• Serialized Form

Constructor Summary

Constructors

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

Method Summary

Methods declared in class SQLException

getErrorCode, getNextException, getSQLState, iterator, setNextException

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 Throwable

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

Modifier and Type	Method	Description
final void	addSuppressed(Throwable exception)	The specified exception is going to be suppressed in order to give priority to this exception (primary exception) and to be appended to the list of suppressed exceptions.
Throwable	fillInStackTrace()	Record in the receiver a walkback from the point where this message was sent.
Throwable	getCause()	Answers the cause of this Throwable, or null if there is no cause.
String	getLocalizedMessage()	Answers the extra information message which was provided when the throwable was created.
String	getMessage()	Answers the extra information message which was provided when the throwable was created.
StackTraceElement[]	getStackTrace()	Answers an array of StackTraceElement.
final Throwable[]	getSuppressed()	Returns an array of exceptions suppressed, typically by the automatically generated code from the try-with-resources statement, in order to give priority to this exception (primary exception).
Throwable	initCause(Throwable throwable)	Initialize the cause of the receiver.
void	printStackTrace()	Outputs a printable representation of the receiver's walkback on the System.err stream.
void	printStackTrace(PrintStream err)	Outputs a printable representation of the receiver's walkback on the stream specified by the argument.
void	printStackTrace(PrintWriter err)	Outputs a printable representation of the receiver's walkback on the writer specified by the argument.
void	setStackTrace(StackTraceElement[] trace)	Sets the array of StackTraceElements.
String	toString()	Answers a string containing a concise, human-readable description of the receiver.

Methods declared in class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Modifier and Type	Method	Description
protected Object	clone()	Answers a new instance of the same class as the receiver, whose slots have been filled in with the values in the slots of the receiver.
boolean	equals(Object o)	Compares the argument to the receiver, and answers true if they represent the same object using a class specific comparison.
protected void	finalize()	Deprecated, for removal: This API element is subject to removal in a future version. May cause performance issues, deadlocks and hangs.
final Class<? extends Object>	getClass()	Answers the unique instance of java.lang.Class which represents the class of the receiver.
int	hashCode()	Answers an integer hash code for the receiver.
final void	notify()	Causes one thread which is waiting on the receiver to be made ready to run.
final void	notifyAll()	Causes all threads which are waiting on the receiver to be made ready to run.
final void	wait()	Causes the thread which sent this message to be made not ready to run pending some change in the receiver (as indicated by notify or notifyAll).
final void	wait(long time)	Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by notify or notifyAll) or the expiration of the timeout.
final void	wait(long time, int frac)	Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by notify or notifyAll) or the expiration of the timeout.

Methods declared in interface Iterable

forEach, spliterator

Modifier and Type	Method	Description
default void	forEach(Consumer<? super Throwable> action)	Performs the given action for each element of the Iterable until all elements have been processed or the action throws an exception.
default Spliterator<Throwable>	spliterator()	Creates a Spliterator over the elements described by this Iterable.

Constructor Details

SQLSyntaxErrorException

public SQLSyntaxErrorException()

Constructs a SQLSyntaxErrorException 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.

Since:

1.6

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason)

Constructs a SQLSyntaxErrorException 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

Since:

1.6

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason,
 String SQLState)

Constructs a SQLSyntaxErrorException 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

Since:

1.6

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason,
 String SQLState,
 int vendorCode)

Constructs a SQLSyntaxErrorException 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

Since:

1.6

SQLSyntaxErrorException

public SQLSyntaxErrorException(Throwable cause)

Constructs a SQLSyntaxErrorException 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

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason,
 Throwable cause)

Constructs a SQLSyntaxErrorException 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

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason,
 String SQLState,
 Throwable cause)

Constructs a SQLSyntaxErrorException 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 (which is saved for later retrieval by the getCause() method); may be null indicating the cause is non-existent or unknown.

Since:

1.6

SQLSyntaxErrorException

public SQLSyntaxErrorException(String reason,
 String SQLState,
 int vendorCode,
 Throwable cause)

Constructs a SQLSyntaxErrorException 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