贡献一个简单bug,在往数据库添加记录的时候报错
org.springframework.dao.DataIntegrityViolationException:
### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'model_belong_type' at row 1
### The error may involve com.louddt.ldp.analysis.model.mapper.ModelInfoMapper.updateByPrimaryKeySelective-Inline
### The error occurred while setting parameters
### SQL: update ldp_analy_model_info SET model_type = ?, model_name = ?, model_trade_type = ?, model_business_type = ?, audit_matters = ?, model_purpose = ?, input_data = ?, analysis_steps = ?, regulation = ?, model_sql = ?, model_belong_type = ?, other_model = ? where id = ?
### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'model_belong_type' at row 1
; SQL []; Data truncation: Data too long for column 'model_belong_type' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'model_belong_type' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
at com.sun.proxy.$Proxy13.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:269)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
at com.sun.proxy.$Proxy44.updateByPrimaryKeySelective(Unknown Source)
看代码标红的部分,多次提到错误原因
Data too long for column 'model_belong_type'
大概意思就是对 model_belong_type 这个字段数据太长,然后我去检查了一下表信息,发现这个字段的长度设置为1,然而我在赋值的时候,这个字段的长度为4个字段,赋值的数据字段太长了,超过了这个字段的定义长度,所以才报了data too lang!
希望可以帮到一些人!