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 'update ge_data_meta_base set table_size=16384,update_time=now() where id=186  ; ' at line 1### The error may exist in com/geespace/microservices/directory/assets/dao/DataAssetsScreenMapper.java (best guess)### The error may involve com.geespace.microservices.directory.assets.dao.DataAssetsScreenMapper.batchUpdate-Inline### The error occurred while setting parameters### SQL: update ge_data_meta_base set table_size=?,update_time=now() where id=?  ;  update ge_data_meta_base set table_size=?,update_time=now() where id=?  ;  update ge_data_meta_base set table_size=?,update_time=now() where id=?  ;  update ge_data_meta_base set table_size=?,update_time=now() where id=?  ;  update ge_data_meta_base set table_size=?,update_time=now() where id=?  ;  update ge_data_meta_base set table_size=?,update_time=now() where 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 'update ge_data_meta_base set table_size=16384,update_time=now() where id=186  ; ' at line 1; 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 'update ge_data_meta_base set table_size=16384,update_time=now() where id=186  ; ' at line 1
  at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)  at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)  at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)  at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)  at com.sun.proxy.$Proxy87.update(Unknown Source)  at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)  at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)  at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)  at com.sun.proxy.$Proxy113.batchUpdate(Unknown Source)  at com.geespace.microservices.directory.assets.es.DataAssetsScreenTest.batchQueryAndUpdate(DataAssetsScreenTest.java:228)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)  at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)  at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)  at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)  at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)  at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)  at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)  at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)  at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)  at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)  at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)  at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)  at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)  at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)  at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)  at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)  at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)  at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)  at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)  at org.junit.runners.ParentRunner.run(ParentRunner.java:363)  at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)  at org.junit.runner.JUnitCore.run(JUnitCore.java:137)  at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)  at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)  at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)  at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)Caused by: 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 'update ge_data_meta_base set table_size=16384,update_time=now() where id=186  ; ' at line 1  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)  at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:387)  at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)  at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)  at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)  at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)  at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)  at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)  at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)  at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)  at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)  at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)  at com.sun.proxy.$Proxy138.update(Unknown Source)  at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)  at java.lang.reflect.Method.invoke(Method.java:498)  at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)  ... 36 more

/**     * 批量更新     * @param list     * @author liudz     * @date 2021/4/13     * @return long     **/    @Update({"<script>",            "<foreach collection='list' item= 'item' index ='index' separator=';'>",            "update ge_data_meta_base set table_size=#{item.dataLength},update_time=now() where id=#{item.id}",            "</foreach>",            "</script>"})    long batchUpdate(@Param("list") List<AssociationTable> list);