Re: data truncation and prepared statements

[Roshan Iqbal]

I am also experiencing the same problem the original poster reported. If I use Statement java.sql.DataTruncation gets thrown but when I use PreparedStatement no exceptions are thrown. I am using MySQL 4.1.10 and connector-j version is 3.1.7

Is there a way to fix this problem? Essentially I would like java.sql.DataTruncation exception to be thrown irrespective of whether I use Statement or PreparedStatement.

Would appreciate your help.

Thanks
Roshan