MySQL Forums
Forum List  »  Connector/JDBC and Java

Re: should be Set column with default value to null
Posted by: Filipe Silva
Date: February 20, 2017 12:11PM

Hi Fredrik,

You are running your database in non-STRICT mode. Please consult the documentation https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict.

You say it is running fine when executing those updates from the database tool but, in fact, you're missing the warning that is being issued in the background.

Connector/J, by default, automatically turns on the STRICT mode on all connections, as such, the same query fails here. This is by design, therefore not a bug.

Thank you,

Options: ReplyQuote


Subject
Written By
Posted
Re: should be Set column with default value to null
February 20, 2017 12:11PM


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.