一、该问题的重现步骤是什么?
1. 我使用的是2.0版本并且融合了bladex4.5.0 的物联网系统
报错信息:### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'data_snapshot' at row 1 ### The error may exist in org/springblade/iot/product/mapper/ProductVersionMapper.java (best guess) ### The error may involve org.springblade.iot.product.mapper.ProductVersionMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO iot_product_version (id, product_id, product_key, version_no, version_desc, data_status, data_snapshot, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'data_snapshot' at row 1 ; Data truncation: Data too long for column 'data_snapshot' at row 1
2. 有四十个属性
{
"profile": {
"productKey": "XrSgk3R9MlgQ",
"version": "2"
},
"properties": [
{
"identifier": "machRun",
"name": "机床运行状态",
"accessMode": "rw",
"required": true,
"dataType": {
"type": "text",
"specs": {
"length": "64"
}
}
},
{
"identifier": "serAxNum",
"name": "伺服轴数",
"accessMode": "rw",
"required": true,
"dataType": {
"type": "text",
"specs": {
"length": "64"
}
}
},
扫一扫访问 Blade技术社区 移动端