open_id=? WHERE id=? AND del_flag=0
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy156.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy161.updateById(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.updateById(IService.java:239)
at org.jeecg.modules.system.service.impl.SysUserServiceImpl.editUser(SysUserServiceImpl.java:545)
at org.jeecg.modules.system.service.impl.SysUserServiceImpl$$FastClassBySpringCGLIB$$5195d464.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:54)
at org.springframework.cache.interceptor.CacheAspectSupport.invokeOperation(CacheAspectSupport.java:366)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:421)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:345)
at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
at org.jeecg.modules.system.service.impl.SysUserServiceImpl$$EnhancerBySpringCGLIB$$f295b2e1.editUser()
at org.jeecg.modules.system.controller.SysUserController.edit(SysUserController.java:216)
at org.jeecg.modules.system.controller.SysUserController$$FastClassBySpringCGLIB$$97a54670.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at org.jeecg.common.aspect.DictAspect.doAround(DictAspect.java:62)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
at org.jeecg.modules.system.controller.SysUserController$$EnhancerBySpringCGLIB$$38e46f5a.edit()
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:920)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
open_id=? WHERE id=? AND del_flag=0
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:196)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
... 131 common frames omitted
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?,
password=?,
open_id=? WHERE id=? AND del_flag=0
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserMulti(JsqlParserSupport.java:74)
at com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforePrepare(TenantLineInnerInterceptor.java:78)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:102)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy390.prepare(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at org.jeecg.config.mybatis.MybatisInterceptor.intercept(MybatisInterceptor.java:136)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy388.update(Unknown Source)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy388.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
... 136 common frames omitted
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\n\n\n"
at line 21, column 14.
版本号:
3.4.3
问题描述:
方法,新增,修改,都会报一下错误 2024-07-05 17:58:44.521 [http-nio-7001-exec-2] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:44.521 [http-nio-7001-exec-1] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:44.521 [http-nio-7001-exec-2] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:44.521 [http-nio-7001-exec-1] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:44.521 [http-nio-7001-exec-2] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:44.521 [http-nio-7001-exec-1] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:44.537 [http-nio-7001-exec-2] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:44.538 [http-nio-7001-exec-1] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:44.567 [http-nio-7001-exec-2] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:20ms 2024-07-05 17:58:44.567 [http-nio-7001-exec-2] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms 2024-07-05 17:58:44.593 [http-nio-7001-exec-1] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:46ms 2024-07-05 17:58:44.593 [http-nio-7001-exec-1] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms 2024-07-05 17:58:46.582 [http-nio-7001-exec-7] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:46.583 [http-nio-7001-exec-4] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:46.583 [http-nio-7001-exec-5] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:46.583 [http-nio-7001-exec-7] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:46.583 [http-nio-7001-exec-4] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:46.583 [http-nio-7001-exec-5] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:46.583 [http-nio-7001-exec-7] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:46.583 [http-nio-7001-exec-5] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:46.584 [http-nio-7001-exec-4] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:46.596 [http-nio-7001-exec-7] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:46.596 [http-nio-7001-exec-5] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:46.596 [http-nio-7001-exec-4] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:46.606 [http-nio-7001-exec-7] INFO o.j.m.system.controller.DuplicateCheckController:50 - ----duplicate check------:DuplicateCheckVo(tableName=sys_user, fieldName=work_no, fieldVal=MLK79821, dataId=1797862256195588097) 2024-07-05 17:58:46.606 [http-nio-7001-exec-4] INFO o.j.m.system.controller.DuplicateCheckController:50 - ----duplicate check------:DuplicateCheckVo(tableName=sys_user, fieldName=phone, fieldVal=17390152912, dataId=1797862256195588097) 2024-07-05 17:58:46.606 [http-nio-7001-exec-5] INFO o.j.m.system.controller.DuplicateCheckController:50 - ----duplicate check------:DuplicateCheckVo(tableName=sys_user, fieldName=username, fieldVal=mutudu, dataId=1797862256195588097) 2024-07-05 17:58:46.615 [http-nio-7001-exec-5] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:9ms 2024-07-05 17:58:46.616 [http-nio-7001-exec-5] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms 2024-07-05 17:58:46.616 [http-nio-7001-exec-7] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:10ms 2024-07-05 17:58:46.617 [http-nio-7001-exec-7] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms 2024-07-05 17:58:46.623 [http-nio-7001-exec-4] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:17ms 2024-07-05 17:58:46.623 [http-nio-7001-exec-4] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms 2024-07-05 17:58:46.649 [http-nio-7001-exec-3] DEBUG org.jeecg.common.config.TenantContext:14 - setting tenant to 0 2024-07-05 17:58:46.649 [http-nio-7001-exec-3] DEBUG org.jeecg.config.shiro.ShiroRealm:93 - ===============Shiro身份认证开始============doGetAuthenticationInfo========== 2024-07-05 17:58:46.650 [http-nio-7001-exec-3] DEBUG org.jeecg.config.shiro.ShiroRealm:125 - ———校验token是否有效————checkUserTokenIsEffect——————— eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJleHAiOjE3MjAxNzUyNjgsInVzZXJuYW1lIjoiYWRtaW4ifQ.zjLCJh0NHJkStDqTgZouTNk9KF6L_wGaFN2HfngXnC0 2024-07-05 17:58:46.661 [http-nio-7001-exec-3] DEBUG o.j.common.desensitization.util.SensitiveInfoUtil:66 - obj --> LoginUser(id=IeYObuSa00K741IFwOv28hJ0HmTTuJxHVNAypLbgTR0=, username=grXDeTwZNGStnSu4yQuIQA==, realname=UTQuOhZCZXJmP76PKkcB/A==, password=5rx/KR6H3hQbbyTyxBatug==, orgCode=A03, avatar=17z+WdgIUwUWGpnQrpGOaweyj9CM8VPRNPq3rebmdRA0W4pF0Gncyc+q2R0rXgzzLUFYSnQZWYbJN6Wu3U8e6A==, birthday=Wed Dec 05 00:00:00 CST 2018, sex=1, email=f28NhDpxZuAdWRLU7uWS8w==, phone=5nve2G2QIL/+BASLYhjl0g==, status=1, delFlag=0, activitiSync=1, createTime=Fri Jun 21 17:54:10 CST 2019, userIdentity=2, departIds=1797860107973742593, post=, telephone=null, relTenantIds=, clientId=null, openId=oi15_6D7uvxmZjTSHwSDvLJgKjPg, workNo=00001) 2024-07-05 17:58:46.689 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:33 - ------sqlId------org.jeecg.modules.base.mapper.BaseCommonMapper.saveLog 2024-07-05 17:58:46.690 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:36 - ------sqlCommandType------INSERT 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------serialVersionUID 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------serialVersionUID 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------DEFAULT_INITIAL_CAPACITY 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------MAXIMUM_CAPACITY 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------DEFAULT_LOAD_FACTOR 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------TREEIFY_THRESHOLD 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------UNTREEIFY_THRESHOLD 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------MIN_TREEIFY_CAPACITY 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------table 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------entrySet 2024-07-05 17:58:46.691 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------size 2024-07-05 17:58:46.692 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------modCount 2024-07-05 17:58:46.692 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------threshold 2024-07-05 17:58:46.692 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------loadFactor 2024-07-05 17:58:46.692 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------keySet 2024-07-05 17:58:46.692 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:45 - ------field.name------values 2024-07-05 17:58:46.693 [http-nio-7001-exec-3] DEBUG o.j.modules.base.mapper.BaseCommonMapper.saveLog:137 - ==> Preparing: insert into sys_log (id, log_type, log_content, method, operate_type, request_url, request_type, request_param, ip, userid, username, cost_time, create_time,create_by) values( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2024-07-05 17:58:46.694 [http-nio-7001-exec-3] DEBUG o.j.modules.base.mapper.BaseCommonMapper.saveLog:137 - ==> Parameters: 1809165014139826178(String), 2(Integer), 编辑用户,username: mutudu(String), null, 2(Integer), null, null, null, 192.168.0.123(String), admin(String), 管理员(String), null, 2024-07-05 17:58:46.689(Timestamp), null 2024-07-05 17:58:46.707 [http-nio-7001-exec-3] DEBUG o.j.modules.base.mapper.BaseCommonMapper.saveLog:137 - <== Updates: 1 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:33 - ------sqlId------org.jeecg.modules.system.mapper.SysUserMapper.updateById 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:36 - ------sqlCommandType------UPDATE 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------serialVersionUID 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------id 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------username 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------realname 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------password 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------salt 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------avatar 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------birthday 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------sex 2024-07-05 17:58:46.716 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------email 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------phone 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------orgCode 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------orgCodeTxt 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------status 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------delFlag 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------workNo 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------post 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------telephone 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------createBy 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------createTime 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------updateBy 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------updateTime 2024-07-05 17:58:46.717 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------activitiSync 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------userIdentity 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------departIds 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------relTenantIds 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------clientId 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------homePath 2024-07-05 17:58:46.718 [http-nio-7001-exec-3] DEBUG org.jeecg.config.mybatis.MybatisInterceptor:115 - ------field.name------openId 2024-07-05 17:58:46.729 [http-nio-7001-exec-3] ERROR o.j.modules.system.controller.SysUserController:220 - nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0
The error may exist in org/jeecg/modules/system/mapper/SysUserMapper.java (best guess)
The error may involve org.jeecg.modules.system.mapper.SysUserMapper.updateById
The error occurred while executing an update
Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0
The error may exist in org/jeecg/modules/system/mapper/SysUserMapper.java (best guess)
The error may involve org.jeecg.modules.system.mapper.SysUserMapper.updateById
The error occurred while executing an update
Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0 at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy156.update(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy161.updateById(Unknown Source) at com.baomidou.mybatisplus.extension.service.IService.updateById(IService.java:239) at org.jeecg.modules.system.service.impl.SysUserServiceImpl.editUser(SysUserServiceImpl.java:545) at org.jeecg.modules.system.service.impl.SysUserServiceImpl$$FastClassBySpringCGLIB$$5195d464.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:54)
at org.springframework.cache.interceptor.CacheAspectSupport.invokeOperation(CacheAspectSupport.java:366)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:421)
at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:345)
at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
at org.jeecg.modules.system.service.impl.SysUserServiceImpl$$EnhancerBySpringCGLIB$$f295b2e1.editUser()
at org.jeecg.modules.system.controller.SysUserController.edit(SysUserController.java:216)
at org.jeecg.modules.system.controller.SysUserController$$FastClassBySpringCGLIB$$97a54670.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
at org.jeecg.common.aspect.DictAspect.doAround(DictAspect.java:62)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)
at org.jeecg.modules.system.controller.SysUserController$$EnhancerBySpringCGLIB$$38e46f5a.edit()
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:920)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0
The error may exist in org/jeecg/modules/system/mapper/SysUserMapper.java (best guess)
The error may involve org.jeecg.modules.system.mapper.SysUserMapper.updateById
The error occurred while executing an update
Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?,
realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0 at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:196) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 131 common frames omitted Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: UPDATE sys_user SET username=?, realname=?, password=?,
avatar=?, birthday=?, sex=?,
phone=?,
status=?, work_no=?, post=?,
create_by=?, create_time=?, update_by=?, update_time=?, activiti_sync=?, user_identity=?, depart_ids=?,
open_id=? WHERE id=? AND del_flag=0 at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39) at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserMulti(JsqlParserSupport.java:74) at com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforePrepare(TenantLineInnerInterceptor.java:78) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:102) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy390.prepare(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at org.jeecg.config.mybatis.MybatisInterceptor.intercept(MybatisInterceptor.java:136) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy388.update(Unknown Source) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy388.update(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194) ... 136 common frames omitted Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\n\n\n"
at line 21, column 14.
Was expecting one of:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "\n\n\n"
at line 21, column 14.
Was expecting one of:
2024-07-05 17:58:46.732 [http-nio-7001-exec-3] DEBUG org.jeecg.common.aspect.DictAspect:64 - 获取JSON数据 耗时:63ms 2024-07-05 17:58:46.732 [http-nio-7001-exec-3] DEBUG org.jeecg.common.aspect.DictAspect:68 - 注入字典到JSON数据 耗时0ms
错误截图:
友情提示: