2024-05-27 14:26:20 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$9e7aa8f5.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 8, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 14:28:41 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$f3088ef.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 8, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 14:30:29 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$2440b67f.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 8, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 14:35:04 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$6ccbfa75.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and DATE (ct.created_date_time) >= ?
|
-- and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 8, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 14:40:24 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$6babcbe.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:238)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
|
at com.sun.proxy.$Proxy276.parameterize(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:75)
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:236)
|
... 119 common frames omitted
|
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1345)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1358)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.setLong(ClientPreparedStatement.java:1543)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setLong(HikariProxyPreparedStatement.java)
|
at com.p6spy.engine.wrapper.PreparedStatementWrapper.setLong(PreparedStatementWrapper.java:173)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
|
at com.sun.proxy.$Proxy225.setLong(Unknown Source)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:31)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:26)
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:73)
|
... 120 common frames omitted
|
2024-05-27 14:41:44 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$bdbec46c.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:238)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
|
at com.sun.proxy.$Proxy276.parameterize(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:75)
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:236)
|
... 119 common frames omitted
|
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1345)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1358)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.setLong(ClientPreparedStatement.java:1543)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setLong(HikariProxyPreparedStatement.java)
|
at com.p6spy.engine.wrapper.PreparedStatementWrapper.setLong(PreparedStatementWrapper.java:173)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
|
at com.sun.proxy.$Proxy225.setLong(Unknown Source)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:31)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:26)
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:73)
|
... 120 common frames omitted
|
2024-05-27 14:44:17 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:120)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$83ab2d7d.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: -- SELECT ct.created_date_time,ct.sqe_confirm_result,
|
-- ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
SELECT *
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 8, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 14:57:12 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$f71d7af8.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:13:55 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$171f81f6.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:16:55 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$171f81f6.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:18:10 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$171f81f6.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and DATE (ct.created_date_time) >= ?
|
and DATE (ct.created_date_time) <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:18:57 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and ct.created_date_time >= ?
|
and ct.created_date_time <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and ct.created_date_time >= ?
|
and ct.created_date_time <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$8b9dd2a1.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and ct.created_date_time >= ?
|
and ct.created_date_time <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and ct.created_date_time >= ?
|
and ct.created_date_time <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
and ct.created_date_time >= ?
|
and ct.created_date_time <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:20:01 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$7be36507.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='bizType', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:238)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
|
at com.sun.proxy.$Proxy276.parameterize(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:75)
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:236)
|
... 119 common frames omitted
|
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1345)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1358)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.setLong(ClientPreparedStatement.java:1543)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setLong(HikariProxyPreparedStatement.java)
|
at com.p6spy.engine.wrapper.PreparedStatementWrapper.setLong(PreparedStatementWrapper.java:173)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
|
at com.sun.proxy.$Proxy225.setLong(Unknown Source)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:31)
|
at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:26)
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:73)
|
... 120 common frames omitted
|
2024-05-27 15:23:36 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and ct.created_date_time >= ?
|
-- and ct.created_date_time <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and ct.created_date_time >= ?
|
-- and ct.created_date_time <= ?
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$e5f39a4a.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and ct.created_date_time >= ?
|
-- and ct.created_date_time <= ?
|
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and ct.created_date_time >= ?
|
-- and ct.created_date_time <= ?
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT ct.created_date_time as dateTime,ct.sqe_confirm_result,
|
ct.check_task_id,bm.material_name,ct.material_id,ct.matnr
|
FROM check_task ct
|
INNER JOIN basic_material bm ON bm.material_id = ct.material_id
|
WHERE 1 = 1
|
AND ct.is_deleted = 0
|
AND ND ct.biz_type = ?
|
-- and ct.created_date_time >= ?
|
-- and ct.created_date_time <= ?
|
at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)
|
at com.dl.framework.interceptor.PlusDataPermissionInterceptor.beforeQuery(PlusDataPermissionInterceptor.java:49)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
... 102 common frames omitted
|
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ct" <S_IDENTIFIER>
|
at line 7, column 18.
|
|
Was expecting one of:
|
|
"&"
|
"::"
|
";"
|
"<<"
|
">>"
|
"COLLATE"
|
"CONNECT"
|
"EMIT"
|
"GROUP"
|
"HAVING"
|
"START"
|
"["
|
"^"
|
"|"
|
<EOF>
|
|
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31468)
|
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31301)
|
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
|
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
|
at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)
|
... 107 common frames omitted
|
2024-05-27 15:27:06 [XNIO-1 task-1] ERROR c.d.f.w.e.GlobalExceptionHandler - 请求地址'/ReportCheckTask/task/list', Mybatis系统异常
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='startTime', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
at com.sun.proxy.$Proxy142.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
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.$Proxy188.GetCheckTaskDefectReportByMaterial(Unknown Source)
|
at com.dl.report.service.impl.ReportCheckTaskServiceImpl.GetCheckTaskDefectReport(ReportCheckTaskServiceImpl.java:125)
|
at com.dl.web.controller.report.ReportCheckTaskController.GetCheckTaskDefectReport(ReportCheckTaskController.java:38)
|
at com.dl.web.controller.report.ReportCheckTaskController$$FastClassBySpringCGLIB$$a4f0489a.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
at com.dl.web.controller.report.ReportCheckTaskController$$EnhancerBySpringCGLIB$$1f904d87.GetCheckTaskDefectReport(<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:498)
|
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:1072)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at com.dl.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:32)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
|
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
|
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
|
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449)
|
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
|
at java.lang.Thread.run(Thread.java:748)
|
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='startTime', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:238)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
|
at com.sun.proxy.$Proxy276.parameterize(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
|
at com.sun.proxy.$Proxy275.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
... 95 common frames omitted
|
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:75)
|
at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:236)
|
... 119 common frames omitted
|
Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1345)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1358)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.setString(ClientPreparedStatement.java:1714)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setString(HikariProxyPreparedStatement.java)
|
at com.p6spy.engine.wrapper.PreparedStatementWrapper.setString(PreparedStatementWrapper.java:225)
|
at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
|
at com.sun.proxy.$Proxy225.setString(Unknown Source)
|
at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:31)
|
at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:26)
|
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:73)
|
... 120 common frames omitted
|
