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

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.

Another reason why this error could occur is when the type of your column is an ENUM with a limited list of values but you are trying to insert something that doesnt belong in that list.

For instance, if your column type is ENUM ('XXX','YYY','ZZZ') but you are trying to insert a value 'AAA' into this column, you'll get the same error.