DataTruncation (Java Platform SE 8 ) (original) (raw)

• java.lang.Object

• • java.lang.Throwable
  • • java.lang.Exception
      • • java.sql.SQLException
          * * java.sql.SQLWarning
          * * java.sql.DataTruncation

• All Implemented Interfaces:
  Serializable, Iterable<Throwable>

public class DataTruncation
extends SQLWarning
An exception thrown as a DataTruncation exception (on writes) or reported as aDataTruncation warning (on reads) when a data values is unexpectedly truncated for reasons other than its having exceeded MaxFieldSize.
The SQLstate for a DataTruncation during read is 01004.
The SQLstate for a DataTruncation during write is 22001.
See Also:
Serialized Form

• • Constructor Summary

  Constructors

  Constructor	Description
  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.
  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.

  • Method Summary

  All Methods Instance Methods Concrete Methods

  Modifier and Type	Method	Description
  int	getDataSize()	Gets the number of bytes of data that should have been transferred.
  int	getIndex()	Retrieves the index of the column or parameter that was truncated.
  boolean	getParameter()	Indicates whether the value truncated was a parameter value or a column value.
  boolean	getRead()	Indicates whether or not the value was truncated on a read.
  int	getTransferSize()	Gets the number of bytes of data actually transferred.

     * ### Methods inherited from class java.sql.[SQLWarning](../../java/sql/SQLWarning.html "class in java.sql")  
     `[getNextWarning](../../java/sql/SQLWarning.html#getNextWarning--), [setNextWarning](../../java/sql/SQLWarning.html#setNextWarning-java.sql.SQLWarning-)`  
     * ### Methods inherited from class java.sql.[SQLException](../../java/sql/SQLException.html "class in java.sql")  
     `[getErrorCode](../../java/sql/SQLException.html#getErrorCode--), [getNextException](../../java/sql/SQLException.html#getNextException--), [getSQLState](../../java/sql/SQLException.html#getSQLState--), [iterator](../../java/sql/SQLException.html#iterator--), [setNextException](../../java/sql/SQLException.html#setNextException-java.sql.SQLException-)`  
     * ### Methods inherited from class java.lang.[Throwable](../../java/lang/Throwable.html "class in java.lang")  
     `[addSuppressed](../../java/lang/Throwable.html#addSuppressed-java.lang.Throwable-), [fillInStackTrace](../../java/lang/Throwable.html#fillInStackTrace--), [getCause](../../java/lang/Throwable.html#getCause--), [getLocalizedMessage](../../java/lang/Throwable.html#getLocalizedMessage--), [getMessage](../../java/lang/Throwable.html#getMessage--), [getStackTrace](../../java/lang/Throwable.html#getStackTrace--), [getSuppressed](../../java/lang/Throwable.html#getSuppressed--), [initCause](../../java/lang/Throwable.html#initCause-java.lang.Throwable-), [printStackTrace](../../java/lang/Throwable.html#printStackTrace--), [printStackTrace](../../java/lang/Throwable.html#printStackTrace-java.io.PrintStream-), [printStackTrace](../../java/lang/Throwable.html#printStackTrace-java.io.PrintWriter-), [setStackTrace](../../java/lang/Throwable.html#setStackTrace-java.lang.StackTraceElement:A-), [toString](../../java/lang/Throwable.html#toString--)`  
     * ### Methods inherited from class java.lang.[Object](../../java/lang/Object.html "class in java.lang")  
     `[clone](../../java/lang/Object.html#clone--), [equals](../../java/lang/Object.html#equals-java.lang.Object-), [finalize](../../java/lang/Object.html#finalize--), [getClass](../../java/lang/Object.html#getClass--), [hashCode](../../java/lang/Object.html#hashCode--), [notify](../../java/lang/Object.html#notify--), [notifyAll](../../java/lang/Object.html#notifyAll--), [wait](../../java/lang/Object.html#wait--), [wait](../../java/lang/Object.html#wait-long-), [wait](../../java/lang/Object.html#wait-long-int-)`  
     * ### Methods inherited from interface java.lang.[Iterable](../../java/lang/Iterable.html "interface in java.lang")  
     `[forEach](../../java/lang/Iterable.html#forEach-java.util.function.Consumer-), [spliterator](../../java/lang/Iterable.html#spliterator--)`

• • 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)](../../java/lang/Throwable.html#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](../../java/lang/Throwable.html "class in java.lang") 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 parameter 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

Submit a bug or feature
For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
Copyright © 1993, 2025, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.