Bug #3804 getWarnings() returns SQLWarning instead of DataTruncation
Submitted: 17 May 2004 23:34 Modified: 4 Aug 2004 18:39
Reporter: Antoine Martin
Status: Closed
Category:Connector/J Severity:S3 (Non-critical)
Version:3.1.1alpha OS:Linux (Linux 2.6.6 - glibc 2.3.2)
Assigned to: Mark Matthews Target Version:

[17 May 2004 23:34] Antoine Martin 
Description:
On insert of an overflow string into a varchar(255) column, the driver returns a
SQLWarning:
warning[0]= class java.sql.SQLWarning message=Data truncated for column 'TESTVC'
at row 1, sql state=S1000, error code=1264

when according to the jdbc spec, it should return:
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DataTruncation.html

I have worked around it using sql state and error code to detect the warning.

More details are available (including some sample test code) in bug 3697:
http://bugs.mysql.com/bug.php?id=3697&error=bc

How to repeat:
Insert a too long string in a varchar(255) column using jdbc and get the warnings.

Suggested fix:
The detection should go in the jdbc driver and return a DataTruncation
[8 Jun 2004 19:46] Mark Matthews 
This is fixed in the source repository, and will be available in C/J 3.1.2.
[4 Aug 2004 18:39] Mark Matthews 
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/