org.springframework.dao.DataIntegrityViolationException:
###Error updating database. Cause: java.sql.SQLException: Data truncated for column ‘trade_type_no’ at row 1
###The error may exist in file [D:\Idea\workspace\demo2\core\target\classes\mapper\trade\foreignapi\xxxxMapper.xml]
###The error may involve com.xxxx.xxx.trade.foreignapi.mapper.xxxxMapper.insertList-Inline
###The error occurred while setting parameters
一度以为是自己的字段写错了,反反复复检查很多遍,发现字段其实没错,错的是数据库中的类型及长度,接口文档中标明了字段类型为枚举,就直接设置字段类型为enum,虽然设置字段长度了,可是实际操作发现只要一保存,字段长度就回复为零。实际最好还是用varchar类型,字段长度也要够。
错误示范:
正确示范: