Exception:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for colu

[rajasri]

When you get this error while running jsp program "Exception in Upload.jsp-->com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'columnname' at row 1"

The first thing to lookup is mysql database table columns datatype.

For uploading or inserting large images or texts you need to assign datatype as "blob or longblob" Then these errors are avoided. What we do mistake is we are uploading simple text or image for testing but at real time these are not enough carefull testing makes program error free,

Happy Coding