解决 Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘dept_code’

2021-01-19 10:44:02 [DEBUG] org.springframework.jdbc.datasource.DataSourceUtils {DataSourceUtils.java:327} - Returning JDBC Connection to DataSource
2021-01-19 10:44:02 [ERROR] cn.sf.yyfxj.controller.YyfxjSubPcController {YyfxjSubPcController.java:613} -
; SQL []; Data truncation: Data too long for column ‘dept_code’ at row 3; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘dept_code’ at row 3
2021-01-19 10:44:02 [DEBUG] org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor {AbstractMessageConverterMethodProcessor.java:207} - Written [失败，请检查数据！] as “application/json;charset=UTF-8” using [org.springframework.http.converter.StringHttpMessageConverter@12db2ed5]
2021-01-19 10:44:02 [DEBUG] org.springframework.web.servlet.DispatcherServlet {DispatcherServlet.java:1034} - Null ModelAndView returned to DispatcherServlet with name ‘FrontController’: assuming HandlerAdapter completed request handling
2021-01-19 10:44:02 [DEBUG] org.springframework.web.servlet.DispatcherServlet {FrameworkServlet.java:995} - Successfully completed request
2021-01-19 10:45:02 [DEBUG] com.sf.novatar.log.audit.LogSaver {LogSaver.java:48} - Saving log size 0.

解决方案

2. 报错原因：

dept_code字段设置长度不够。

3. 解决：修改表字段长度设置。