Mysql issue java.sql.SQLException: Field '' doesn't have a default value


#1

Dear Friends

I have some issue related to mysql

In production server I have installed CentOS 6.5 (Final) and mysql-5.1.73 package in test sever also I have the same OS and mysql same package

The issue is in production server the java file which I am executing is giving expected output but the same file when executed in test server it is showing the error as below

“exception in execute update:java.sql.SQLException: Field ‘confirm_units’ doesn’t have a default value”

Please help me to fix the same ASAP

Thanks
Kiran