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