sql 里面没有Comment，抛异常 syntax error, COMMA values

[yzhang921]

druid 0.2.26
db sqlserver

MyBatis 成功插入了数据

insert into dashboard_role_res
(res_id, role_id,res_type)
values

(#{rr.resId}, #{rr.roleId} ,#{rr.resType})

但是之后还是会抛个异常出来
[com.alibaba.druid.filter.stat.StatFilter]merge sql error, dbType null, sql :

insert into dashboard_role_res
        (res_id, role_id,res_type)
        values
          
            (?, ? ,?)
         , 
            (?, ? ,?)

com.alibaba.druid.sql.parser.ParserException: syntax error, COMMA values, pos 124
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:299)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:107)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:102)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:52)
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:145)
at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:629)
at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:305)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:124)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:446)

[wenshao]

更新到最新版本1.0.27试试看
http://repo1.maven.org/maven2/com/alibaba/druid/1.0.27/

[yzhang921]

@wenshao 嗯，早就这么干了，还真好了
😄