mysql报错: Data truncation: Truncated incorrect DOUBLE value

日志如下

### Error updating database.  Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update `table_test set data_json= ? where 1=1 and model_id= ?
Parameters: {"cableActualForce":"2699","cableLength":"57372"}(String), 300799287(Long)

检查入参的数据类型和数据库类型是否一致。

UPDATE `table_test`
SET data_json = '{"cableActualForce":"2699","cableLength":"57372"}'
WHERE 1 = 1 
AND model_id = 300799287

查库发现字段model_id是varchar类型，而在java里入参时给的是Long类型，导致报错。