- 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 aDataTruncation
exception (on writes) or reported as aDataTruncation
warning (on reads) when a data values is unexpectedly truncated for reasons other than its having execeededMaxFieldSize
.The SQLstate for a
DataTruncation
during read is01004
.The SQLstate for a
DataTruncation
during write is22001
.- See Also:
- Serialized Form
-
-
Constructor Summary
Constructors Constructor and Description DataTruncation(int index, boolean parameter, boolean read, int dataSize, int transferSize)
Creates aDataTruncation
object with the SQLState initialized to 01004 whenread
is set totrue
and 22001 whenread
is set tofalse
, 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 aDataTruncation
object with the SQLState initialized to 01004 whenread
is set totrue
and 22001 whenread
is set tofalse
, the reason set to "Data truncation", the vendor code set to 0, and the other fields set to the given values.
-
Method Summary
Methods Modifier and Type Method and 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
getNextWarning, setNextWarning
-
Methods inherited from class java.sql.SQLException
getErrorCode, getNextException, getSQLState, iterator, setNextException
-
Methods inherited from class java.lang.Throwable
addSuppressed, fillInStackTrace, getCause, getLocalizedMessage, getMessage, getStackTrace, getSuppressed, initCause, printStackTrace, printStackTrace, printStackTrace, setStackTrace, toString
-
-
-
-
Constructor Detail
-
DataTruncation
public DataTruncation(int index, boolean parameter, boolean read, int dataSize, int transferSize)
Creates aDataTruncation
object with the SQLState initialized to 01004 whenread
is set totrue
and 22001 whenread
is set tofalse
, the reason set to "Data truncation", the vendor code set to 0, and the other fields set to the given values. Thecause
is not initialized, and may subsequently be initialized by a call to theThrowable.initCause(java.lang.Throwable)
method.- Parameters:
index
- The index of the parameter or column valueparameter
- true if a parameter value was truncatedread
- true if a read was truncateddataSize
- the original size of the datatransferSize
- the size after truncation
-
DataTruncation
public DataTruncation(int index, boolean parameter, boolean read, int dataSize, int transferSize, Throwable cause)
Creates aDataTruncation
object with the SQLState initialized to 01004 whenread
is set totrue
and 22001 whenread
is set tofalse
, 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 valueparameter
- true if a parameter value was truncatedread
- true if a read was truncateddataSize
- the original size of the datatransferSize
- the size after truncationcause
- the underlying reason for thisDataTruncation
(which is saved for later retrieval by thegetCause()
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
andread
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
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.