java.sql.SQLException: Data truncated for column ‘MonthlyIncome’ at row 1 error

I am trying to update as well as save data to my database using my GUI. My problem is, if i don’t enter any data to certain textboxes which i have allowed null on my database, i get this kind of error: java.sql.SQLException: Data truncated for column ‘MonthlyIncome’ at row 1

Answer

Typically this problem occurs when you are putting in a data that is too long for the column. In this case, whatever data you are updating the ‘MonthlyIncome’ field with is too long.