java的MySQL报语法错误,但是把debug中的语句直接拿出来是可以正常运行的，求个java大佬指点下
0
悬赏园豆：15
[已关闭问题]
关闭于 2019-08-26 10:58
[1566783530435] 08-26 09:38:50.600 [http-nio-51002-exec-3] [/oem/v1.0/customer/enter] DEBUG c.v.b.d.I.initDataByEnterpriseId - ==> Preparing: INSERT INTO `risk_phone_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '手机短信敏感词', 0, '', 0, '', NOW(), NOW(), 1, null); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发红包请求', 0, '', 0, '', NOW(), NOW(), 1, 1); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收红包请求', 0, '', 0, '', NOW(), NOW(), 1, 2); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收红包确认', 0, '', 0, '', NOW(), NOW(), 1, 3); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发红包确认', 0, '', 0, '', NOW(), NOW(), 1, 4); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收转账请求', 0, '', 0, '', NOW(), NOW(), 1, 5); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发转账请求', 0, '', 0, '', NOW(), NOW(), 1, 6); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收转账确认', 0, '', 0, '', NOW(), NOW(), 1, 7); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发转账确认', 0, '', 0, '', NOW(), NOW(), 1, 8); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '打开扫一扫', 0, '', 0, '', NOW(), NOW(), 1, 9); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '设置声音锁', 0, '', 0, '', NOW(), NOW(), 1, 10); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '更换手机号', 0, '', 0, '', NOW(), NOW(), 1, 11); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '尝试登陆', 0, '', 0, '', NOW(), NOW(), 1, 12); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '登陆PC或者网页版微信', 0, '', 0, '', NOW(), NOW(), 1, 13); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '视频与语音通话', 0, '', 0, '', NOW(), NOW(), 1, 14); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '打开微信拍照', 0, '', 0, '', NOW(), NOW(), 1, 15); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发共享位置', 0, '', 0, '', NOW(), NOW(), 1, 16); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收共享位置', 0, '', 0, '', NOW(), NOW(), 1, 17); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发位置', 0, '', 0, '', NOW(), NOW(), 1, 18); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收位置', 0, '', 0, '', NOW(), NOW(), 1, 19); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发名片', 0, '', 0, '', NOW(), NOW(), 1, 20); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收名片', 0, '', 0, '', NOW(), NOW(), 1, 21); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '敏感消息', 0, '', 0, '', NOW(), NOW(), 1, 22); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '删除联系人', 0, '', 0, '', NOW(), NOW(), 1, 23); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '删除聊天记录', 0, '', 0, '', NOW(), NOW(), 1, 28); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '拉黑联系人', 0, '', 0, '', NOW(), NOW(), 1, 25); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '创建群', 0, '', 0, '', NOW(), NOW(), 1, 27);
[1566783530435] 08-26 09:38:50.602 [http-nio-51002-exec-3] [/oem/v1.0/customer/enter] DEBUG c.v.b.d.I.initDataByEnterpriseId - ==> Parameters: 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer), 36(Integer)
[1566783530435] 08-26 09:38:50.638 [http-nio-51002-exec-3] [/oem/v1.0/customer/enter] ERROR com.vma.aop.WebLogAop - 处理时间:201ms 接口异常
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_ope' at line 2
### The error may involve com.vma.business.dao.IEnterpriseDao.initDataByEnterpriseId-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO `risk_phone_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '手机短信敏感词', 0, '', 0, '', NOW(), NOW(), 1, null); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发红包请求', 0, '', 0, '', NOW(), NOW(), 1, 1); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收红包请求', 0, '', 0, '', NOW(), NOW(), 1, 2); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收红包确认', 0, '', 0, '', NOW(), NOW(), 1, 3); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发红包确认', 0, '', 0, '', NOW(), NOW(), 1, 4); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收转账请求', 0, '', 0, '', NOW(), NOW(), 1, 5); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发转账请求', 0, '', 0, '', NOW(), NOW(), 1, 6); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收转账确认', 0, '', 0, '', NOW(), NOW(), 1, 7); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发转账确认', 0, '', 0, '', NOW(), NOW(), 1, 8); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '打开扫一扫', 0, '', 0, '', NOW(), NOW(), 1, 9); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '设置声音锁', 0, '', 0, '', NOW(), NOW(), 1, 10); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '更换手机号', 0, '', 0, '', NOW(), NOW(), 1, 11); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '尝试登陆', 0, '', 0, '', NOW(), NOW(), 1, 12); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '登陆PC或者网页版微信', 0, '', 0, '', NOW(), NOW(), 1, 13); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '视频与语音通话', 0, '', 0, '', NOW(), NOW(), 1, 14); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '打开微信拍照', 0, '', 0, '', NOW(), NOW(), 1, 15); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发共享位置', 0, '', 0, '', NOW(), NOW(), 1, 16); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收共享位置', 0, '', 0, '', NOW(), NOW(), 1, 17); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发位置', 0, '', 0, '', NOW(), NOW(), 1, 18); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收位置', 0, '', 0, '', NOW(), NOW(), 1, 19); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '发名片', 0, '', 0, '', NOW(), NOW(), 1, 20); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '收名片', 0, '', 0, '', NOW(), NOW(), 1, 21); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '敏感消息', 0, '', 0, '', NOW(), NOW(), 1, 22); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '删除联系人', 0, '', 0, '', NOW(), NOW(), 1, 23); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '删除聊天记录', 0, '', 0, '', NOW(), NOW(), 1, 28); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '拉黑联系人', 0, '', 0, '', NOW(), NOW(), 1, 25); INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_open`, `accept_mail_address`, `message_open`, `accept_msg_phone`, `create_time`, `update_time`, `status`, `action_id`) VALUES (?, '创建群', 0, '', 0, '', NOW(), NOW(), 1, 27);
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_ope' at line 2
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'INSERT INTO `risk_wechat_notice_cfg`( `enterprise_id`, `action_name`, `mail_ope' at line 2
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.$Proxy151.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:58)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy160.initDataByEnterpriseId(Unknown Source)
at com.vma.business.service.impl.EnterpriseServiceImpl.addEnterprise(EnterpriseServiceImpl.java:688)
at com.vma.business.service.impl.EnterpriseServiceImpl$$FastClassBySpringCGLIB$$ef8e6cdc.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.vma.business.service.impl.EnterpriseServiceImpl$$EnhancerBySpringCGLIB$$57f689bd.addEnterprise(<generated>)
at com.vma.manager.controller.oem.customer.EnterpriseController.add(EnterpriseController.java:66)
at com.vma.manager.controller.oem.customer.EnterpriseController$$FastClassBySpringCGLIB$$cf823d36.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:55)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.vma.manager.controller.oem.customer.EnterpriseController$$EnhancerBySpringCGLIB$$d21f6be3.add(<generated>)
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:497)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:891)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.vma.core.filter.ParamFilter.doFilterInternal(ParamFilter.java:29)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:155)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:123)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
所有回答(2)
0
配置问题数据库链接&allowMultiQueries=true
0
你是想批量插入吗
这样用；分割语句是不识别的
谢谢你的回答,不过我的不是这原因,是因为数据库连接的后面没有跟&allowMultiQueries=true参数
