ConvertJSONToSQL -> ExecuteSQL 

If the field name is the sql keyword, there will be error. 
Is there any simple way to avoid this? 

INSERT INTO t_stat_robot_poll (id, robot_id, shelf_code, 
task_id, exe_task_id, task_type, exe_task_type, onload_flag, new_shelf_flag, 
value, start_time, complete_time, start_point,
 end_point, distance, instruction, path, pos, power_percent, stop_time, 
station_id, stop_count) VALUES (?, ?, ?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) for 
StandardFlowFileRecord[uuid=c228ec24-626e-4868-946c-69ada0ac2fa6,claim=S
tandardContentClaim 
[resourceClaim=StandardResourceClaim[id=1566460129309-36512, container=default, 
section=672], offset=90
191, length=349],offset=0,name=a049ba19-72b8-482c-827c-29241e04b7ae,size=349] 
due to com.mysql.jdbc.exceptions.jdbc4.MySQLS
yntaxErrorException: [13000, 2019082215484919216800001603151061933] syntax 
error :ERROR. token : value is reserved keyword,
 you shoud use `value`, pos : 139; routing to failure: 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: [13000, 2
019082215484919216800001603151061933] syntax error :ERROR. token : value is 
reserved keyword, you shoud use `value`, pos : 
139



wangl...@geekplus.com.cn

Reply via email to