java.sql

Class 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 Detail

      • 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 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
        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 bythe 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

Document created the 11/06/2005, last modified the 04/03/2020
Source of the printed document:https://www.gaudry.be/en/java-api-rf-java/sql/sqlsyntaxerrorexception.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

  1. View the html document Language of the document:fr Manuel PHP : https://docs.oracle.com

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut