java批量修改foreach_springboot+Mybatis批量改foreach抛出java.sql.SQLSyntaxErrorException

最新推荐文章于 2024-01-18 17:18:27 发布

原创最新推荐文章于 2024-01-18 17:18:27 发布 · 377 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java批量修改foreach

博客围绕Java批量修改时的SQL语法错误展开。连接MySQL数据库执行多条query语句报错，虽检查语法无误，但报错指向分号后第二条语句。判断是数据源默认只允许单条语句执行，解决办法是在数据源URL后添加allowMultiQueries=true，并给出批量修改代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Type Exception Report

Message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is 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 t_yydxx_gjc a

set a.name = '找到工作,不需要'

' at line 5

### The error may involve com.wawa.dao.newdao.VcgeekDao.updateNoname-Inline

### The error occurred while setting parameters

### SQL: update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.id = ? ; update t_yydxx_gjc a set a.name = ? where a.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 t_yydxx_gjc a

set a.name = '找到工作,不需要'

' at line 5

; 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 t_yydxx_gjc a

set a.name = '找到工作,不需要'

' at line 5

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)

org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)

javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)

javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

com.wawa.service.system.HeaderFilter.doFilter(HeaderFilter.java:46)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)

Root Cause

org.springframework.jdbc.BadSqlGrammarException:

set a.name = '找到工作,不需要'

' at line 5

### The error may involve com.wawa.dao.newdao.VcgeekDao.updateNoname-Inline

### The error occurred while setting parameters

set a.name = '找到工作,不需要'

' at line 5

set a.name = '找到工作,不需要'

' at line 5

org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)

org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)

org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:368)

com.sun.proxy.$Proxy24.update(Unknown Source)

org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:254)

org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)

org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)

com.sun.proxy.$Proxy38.updateNoname(Unknown Source)

com.wawa.controller.newYygl.TemplateDesignController.yydUpdateNoname(TemplateDesignController.java:207)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

java.lang.reflect.Method.invoke(Method.java:498)

org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)

org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:690)

org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)

com.wawa.utils.spring.ReloadDispatcherServlet.doDispatch(ReloadDispatcherServlet.java:27)

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)