java.sql

Class DataTruncation

  • All Implemented Interfaces:
    Serializable, Iterable<Throwable>

    public class DataTruncation
    extends SQLWarning
    An exception thrown as a DataTruncation exception (on writes) or reported as a DataTruncation warning (on reads) when a data values is unexpectedly truncated for reasons other than its having execeeded MaxFieldSize.

    The SQLstate for a DataTruncation during read is 01004.

    The SQLstate for a DataTruncation during write is 22001.

    See Also:
    Serialized Form
    • Constructor Detail

      • DataTruncation

        public DataTruncation(int index,
                      boolean parameter,
                      boolean read,
                      int dataSize,
                      int transferSize)
        Creates a DataTruncation object with the SQLState initialized to 01004 when read is set to true and 22001 when read is set to false, the reason set to "Data truncation", the vendor code set to 0, and the other fields set to the given values. The cause is not initialized, and may subsequently be initialized by a call to the Throwable.initCause(java.lang.Throwable) method.

        Parameters:
        index - The index of the parameter or column value
        parameter - true if a parameter value was truncated
        read - true if a read was truncated
        dataSize - the original size of the data
        transferSize - the size after truncation
      • DataTruncation

        public DataTruncation(int index,
                      boolean parameter,
                      boolean read,
                      int dataSize,
                      int transferSize,
                      Throwable cause)
        Creates a DataTruncation object with the SQLState initialized to 01004 when read is set to true and 22001 when read is set to false, the reason set to "Data truncation", the vendor code set to 0, and the other fields set to the given values.

        Parameters:
        index - The index of the parameter or column value
        parameter - true if a parameter value was truncated
        read - true if a read was truncated
        dataSize - the original size of the data
        transferSize - the size after truncation
        cause - the underlying reason for this DataTruncation (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 Detail

      • getIndex

        public int getIndex()
        Retrieves the index of the column or parameter that was truncated.

        This may be -1 if the column or parameter index is unknown, in which case the parameter and read fields should be ignored.

        Returns:
        the index of the truncated paramter or column value
      • getParameter

        public boolean getParameter()
        Indicates whether the value truncated was a parameter value or a column value.
        Returns:
        true if the value truncated was a parameter; false if it was a column value
      • getRead

        public boolean getRead()
        Indicates whether or not the value was truncated on a read.
        Returns:
        true if the value was truncated when read from the database; false if the data was truncated on a write
      • getDataSize

        public int getDataSize()
        Gets the number of bytes of data that should have been transferred. This number may be approximate if data conversions were being performed. The value may be -1 if the size is unknown.
        Returns:
        the number of bytes of data that should have been transferred
      • getTransferSize

        public int getTransferSize()
        Gets the number of bytes of data actually transferred. The value may be -1 if the size is unknown.
        Returns:
        the number of bytes of data actually transferred

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/datatruncation.html/.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