一:
19:08:15.834 [http-nio-8080-exec-17] ERROR c.a.d.f.s.StatFilter - [mergeSql,149] - merge sql error, dbType mysql, druid-1.1.14, sql : update sar_wake
SET top_left_latitude = ?,
top_left_longitude = ?,
top_right_latitude = ?,
top_right_longitude = ?,
bot_left_latitude = ?,
bot_left_longitude = ?,
bot_right_latitude = ?,
bot_right_longitude = ?,
wave_band = ?,
polarity = ?,
angle_of_incidence = ?,
azimuth = ?,
image_width = ?,
image_height = ?,
image_path = ?,
png_path = ?,
platform = ?,
s_load = ?
start_time = ?,
end_time = ?
where s_id = ?
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' start_time = ?,
en', expect IDENTIFIER, actual IDENTIFIER pos 765, line 33, column 24, token IDENTIFIER start_time
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:287)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:532)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:171)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:98)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:81)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:54)
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:147)
这个异常很明显语法错了,start_time前后,s_load=?后面少了个逗号“,”
二:
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-->
start_time = '2016-07-15 ' at line 29
### The error may involve com.ruoyi.ds.dm.mapper.SarWakeMapper.updateSarWake-Inline
### The error occurred while setting parameters
### SQL: update sar_wake SET top_left_latitude = ?, top_left_longitude = ?, top_right_latitude = ?, top_right_longitude = ?, bot_left_latitude = ?, bot_left_longitude = ?, bot_right_latitude = ?, bot_right_longitude = ?, wave_band = ?, polarity = ?, angle_of_incidence = ?, azimuth = ?, image_width = ?, image_height = ?, image_path = ?, png_path = ?, platform = ?, s_load = ?, load_model = ?, --> start_time = ?, end_time = ? where s_id = ?
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-->
start_time = '2016-07-15 ' at line 29
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-->
这个异常的重点是:java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-->
在mapper文件中的注释右侧部分没有删除,找到删掉就好了。