字段长度超过数据库的设计长度报org.springframework.dao.DataIntegrityViolationException

字段长度超过数据库的设计长度报org.springframework.dao.DataIntegrityViolationException 

根据错误信息来看，字段长度超过数据库的设计长度了。根据业务规则重新设计表格字段长度！并做好对应字段的长度校验，以免落到数据库！

根据错误信息来看，字段长度超过数据库的设计长度了。根据业务规则重新设计表格字段长度！并做好对应字段的长度校验，以免落到数据库！

根据错误信息来看，字段长度超过数据库的设计长度了。根据业务规则重新设计表格字段长度！并做好对应字段的长度校验，以免落到数据库！

2021-09-13 20:47:12.810 [http-nio-10001-exec-7] ERROR com.iot.handler.IotGlobalExceptionHandler -
====> IotGlobalExceptionHandler#exceptionHandler Exception: org.springframework.dao.DataIntegrityViolationException: 
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1 
### The error may exist in com/iot/business/products/services/params/dao/ProductServicesParamsDao.java (best guess) 
### The error may involve com.iot.business.products.services.params.dao.ProductServicesParamsDao.updateById-Inline 
### The error occurred while setting parameters 
### SQL: UPDATE t_product_services_params SET ref_id=?, identifier=?, type=?, name=?, description=?, data_type=?, specs=?, ref=?, custom=?, update_time=?, create_time=? WHERE id=?
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1 ; Data truncation: Data too long for column 'description' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1 2021-09-13 20:47:12.810 [http-nio-10001-exec-7] ERROR com.iot.handler.IotGlobalExceptionHandler - =====>IotGlobalExceptionHandler#RuntimeException msg: 
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1 
### The error may exist in com/iot/business/products/services/params/dao/ProductServicesParamsDao.java (best guess)
### The error may involve com.iot.business.products.services.params.dao.ProductServicesParamsDao.updateById-Inline 

### The error occurred while setting parameters 
### SQL: UPDATE t_product_services_params SET ref_id=?, identifier=?, type=?, name=?, description=?, data_type=?, specs=?, ref=?, custom=?, update_time=?, create_time=? WHERE id=? 
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1 ; Data truncation: Data too long for column 'description' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1
====> IotGlobalExceptionHandler#exceptionHandler Exception: org.springframework.dao.DataIntegrityViolationException: 
### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1 
### The error may exist in com/iot/business/products/services/params/dao/ProductServicesParamsDao.java (best guess) 
### The error may involve com.iot.business.products.services.params.dao.ProductServicesParamsDao.insert-Inline 
### The error occurred while setting parameters ### SQL: INSERT INTO t_product_services_params ( ref_id, identifier, type, name, description, data_type, specs, ref, custom ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? )