I’m using SpringBoot and MyBatis. When tried to insert/update some rows into a table, I got the fllowing:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'remark' cannot be null ### The error may exist in org/chobit/service/mapper/UserMapper.java (best guess) ### The error may involve org.chobit.service.mapper.UserMapper.updateById-Inline ### The error occurred while setting parameters ### SQL: update user set username=?, `remark`=? where id=? ### Cause: java.sql.SQLIntegrityConstraintViolationException: Column 'remark' cannot be null ; Column 'remark' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'remark' cannot be null at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:87) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy88.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:67) |
The column remark in the table user was setted to NOT NULL, and the value of the column to insert was null. That’s why I received the error. Continue reading