插入mysql失败，因为java数据类型是个实体类，加上.id就好了

最新推荐文章于 2022-04-11 15:48:58 发布

weixin_30588907

最新推荐文章于 2022-04-11 15:48:58 发布

阅读量244

点赞数

文章标签： java 数据库

原文链接：http://www.cnblogs.com/hoge66/p/10489022.html

版权

错误信息：
### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'create_by' at row 1
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO ecs_favourable_activity( id, act_name, start_time, end_time, user_rank, act_range, act_range_ext, min_amount, max_amount, act_type, act_type_ext, gift, sort_order, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'create_by' at row 1
; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'create_by' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xAC\xED\x00\x05sr...' for column 'create_by' at row 1

转载于:https://www.cnblogs.com/hoge66/p/10489022.html