mapper文件的两个异常:com.alibaba.druid.sql.parser.ParserException 和 org.springframework.jdbc.BadSqlGrammar.

一:

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文件中的注释右侧部分没有删除,找到删掉就好了。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值