Re: Data truncation throws java.sql.SQLException instead of com.mysql.jdbc.MysqlDataTruncation
Posted by: Jesus Marquez Sanchez
Date: December 09, 2005 12:46PM

Hi,

I finally found what the problem was and I post it here to whom might be interested in.

I was running MySQL 5.0 in strict mode. Switching to non-strict mode now raises the "right" com.mysql.jdbc.MysqlDataTruncation exception.
Also, jdbcCompliantTruncation=false" property works as espected.

Even though I had a look at the MySQL doc about strict mode, I'm still a bit confused about it. I have to work a bit more on it.

Regards,
Jesus

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.