首页 新闻 赞助 找找看

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)
。思索的主页 。思索 | 菜鸟二级 | 园豆:362
提问于:2019-08-26 09:41
< >
分享
所有回答(2)
0

配置问题数据库链接&allowMultiQueries=true

。思索 | 园豆:362 (菜鸟二级) | 2019-08-26 10:58
0

你是想批量插入吗
这样用;分割语句是不识别的

周广法GODOING | 园豆:212 (菜鸟二级) | 2019-08-28 17:06

谢谢你的回答,不过我的不是这原因,是因为数据库连接的后面没有跟&allowMultiQueries=true参数

支持(0) 反对(0) 。思索 | 园豆:362 (菜鸟二级) | 2019-08-28 17:08
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册