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

时间:2023-03-08 17:52:36
错误信息:
### 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