HTTP Status *** – Internal Server ErrorHTTP Status *** – Internal Server ErrorType Exception ReportMessage Request processing failed; nested exception is ***.******.***.MyBatisSystemException: nested exception is ***.******.***.exceptions.PersistenceException: Description The server encountered an unexpected condition that prevented it from fulfilling the ***.******.***.***.******.***: Request processing failed; nested exception is ***.******.***.MyBatisSystemException: nested exception is ***.******.***.exceptions.PersistenceException: ### Error querying database. Cause: ***.******.***: 请您在sql中包含order by语句! ### The error may exist in class path resource [***.******.***] ### The error may involve ***.******.***.***.******.***.AnnouncementMapper.findClarificationAnnouncementOahtmlContent_COUNT ### The error occurred while handling results ### SQL: SELECT count(*) FROM Notice_Clarify WHERE (ShowDate GETDATE()) AND (DATEADD(Day, *, AvailDate) GETDATE()) AND (Status = 启用) AND SNID = ? AND openMode ** ### Cause: ***.******.***: 请您在sql中包含order by语句!***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***.doFilter(WsFilter.java:**)***.******.***.***.******.***(CharacterEncodingFilter.java:***)***.******.***.***.******.***(OncePerRequestFilter.java:***) Root ***.******.***.MyBatisSystemException: nested exception is ***.******.***.exceptions.PersistenceException: ### Error querying database. Cause: ***.******.***: 请您在sql中包含order by语句! ### The error may exist in class path resource [***.******.***] ### The error may involve ***.******.***.***.******.***.AnnouncementMapper.findClarificationAnnouncementOahtmlContent_COUNT ### The error occurred while handling results ### SQL: SELECT count(*) FROM Notice_Clarify WHERE (ShowDate GETDATE()) AND (DATEADD(Day, *, AvailDate) GETDATE()) AND (Status = 启用) AND SNID = ? AND openMode ** ### Cause: ***.******.***: 请您在sql中包含order by语句!***.******.***.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:**)***.******.***.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:***)***.******.***.$Proxy**.selectOne(Unknown Source)***.******.***.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:***)***.******.***.***.******.***(MapperMethod.java:**)***.******.***.***.******.***(MapperProxy.java:**)***.******.***.$Proxy**.findClarificationAnnouncementOahtmlContent(Unknown Source)***.******.***.***.******.***.AnnouncementServiceImpl.findAnnouncementOahtmlContent(AnnouncementServiceImpl.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$FastClassBySpringCGLIB$$***a****.invoke(generated)***.******.***.***.******.***(MethodProxy.java:***)***.******.***.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:***)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.***.******.***(ExposeInvocationInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$EnhancerBySpringCGLIB$$*******.findAnnouncementOahtmlContent(generated)***.******.***.***.******.***(AnnouncementController.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.***.******.***.doInvoke(InvocableHandlerMethod.java:***)***.******.***.***.******.***.invokeForRequest(InvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(ServletInvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:**)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***.doFilter(WsFilter.java:**)***.******.***.***.******.***(CharacterEncodingFilter.java:***)***.******.***.***.******.***(OncePerRequestFilter.java:***) Root ***.******.***.exceptions.PersistenceException: ### Error querying database. Cause: ***.******.***: 请您在sql中包含order by语句! ### The error may exist in class path resource [***.******.***] ### The error may involve ***.******.***.***.******.***.AnnouncementMapper.findClarificationAnnouncementOahtmlContent_COUNT ### The error occurred while handling results ### SQL: SELECT count(*) FROM Notice_Clarify WHERE (ShowDate GETDATE()) AND (DATEADD(Day, *, AvailDate) GETDATE()) AND (Status = 启用) AND SNID = ? AND openMode ** ### Cause: ***.******.***: 请您在sql中包含order by语句!***.******.***.***.******.***(ExceptionFactory.java:**)***.******.***.***.******.***.selectList(DefaultSqlSession.java:***)***.******.***.***.******.***.selectList(DefaultSqlSession.java:***)***.******.***.***.******.***.selectOne(DefaultSqlSession.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:***)***.******.***.$Proxy**.selectOne(Unknown Source)***.******.***.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:***)***.******.***.***.******.***(MapperMethod.java:**)***.******.***.***.******.***(MapperProxy.java:**)***.******.***.$Proxy**.findClarificationAnnouncementOahtmlContent(Unknown Source)***.******.***.***.******.***.AnnouncementServiceImpl.findAnnouncementOahtmlContent(AnnouncementServiceImpl.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$FastClassBySpringCGLIB$$***a****.invoke(generated)***.******.***.***.******.***(MethodProxy.java:***)***.******.***.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:***)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.***.******.***(ExposeInvocationInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$EnhancerBySpringCGLIB$$*******.findAnnouncementOahtmlContent(generated)***.******.***.***.******.***(AnnouncementController.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.***.******.***.doInvoke(InvocableHandlerMethod.java:***)***.******.***.***.******.***.invokeForRequest(InvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(ServletInvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:**)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***.doFilter(WsFilter.java:**)***.******.***.***.******.***(CharacterEncodingFilter.java:***)***.******.***.***.******.***(OncePerRequestFilter.java:***) Root ***.******.***: 请您在sql中包含order by语句!***.******.***.***.******.***(SqlServer.java:***)***.******.***.***.******.***(SqlServer.java:***)***.******.***.***.******.***(SqlServer.java:***)***.******.***.***.******.***.getPageSql(SqlServerParser.java:**)***.******.***.***.******.***(PageStaticSqlSource.java:**)***.******.***.***.******.***(PageRawSqlSource.java:**)***.******.***.***.******.***(PageSqlSource.java:**)***.******.***.***.******.***(MappedStatement.java:***)***.******.***.***.******.***(CachingExecutor.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.***.******.***(Invocation.java:**)***.******.***.SqlUtil.doProcessPage(SqlUtil.java:***)***.******.***.SqlUtil._processPage(SqlUtil.java:***)***.******.***.SqlUtil.processPage(SqlUtil.java:***)***.******.***.PageHelper.intercept(PageHelper.java:***)***.******.***.***.******.***(Plugin.java:**)***.******.***.$Proxy**.query(Unknown Source)***.******.***.***.******.***.selectList(DefaultSqlSession.java:***)***.******.***.***.******.***.selectList(DefaultSqlSession.java:***)***.******.***.***.******.***.selectOne(DefaultSqlSession.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:***)***.******.***.$Proxy**.selectOne(Unknown Source)***.******.***.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:***)***.******.***.***.******.***(MapperMethod.java:**)***.******.***.***.******.***(MapperProxy.java:**)***.******.***.$Proxy**.findClarificationAnnouncementOahtmlContent(Unknown Source)***.******.***.***.******.***.AnnouncementServiceImpl.findAnnouncementOahtmlContent(AnnouncementServiceImpl.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$FastClassBySpringCGLIB$$***a****.invoke(generated)***.******.***.***.******.***(MethodProxy.java:***)***.******.***.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:***)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.interceptor.TransactionInterceptor$*.proceedWithInvocation(TransactionInterceptor.java:**)***.******.***.***.******.***(TransactionAspectSupport.java:***)***.******.***.***.******.***(TransactionInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.***.******.***(ExposeInvocationInterceptor.java:**)***.******.***.***.******.***(ReflectiveMethodInvocation.java:***)***.******.***.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:***)***.******.***.***.******.***.AnnouncementServiceImpl$$EnhancerBySpringCGLIB$$*******.findAnnouncementOahtmlContent(generated)***.******.***.***.******.***(AnnouncementController.java:**)***.******.***.invoke(Unknown Source)***.******.***.invoke(DelegatingMethodAccessorImpl.java:**)***.******.***.Method.invoke(Method.java:***)***.******.***.***.******.***.doInvoke(InvocableHandlerMethod.java:***)***.******.***.***.******.***.invokeForRequest(InvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(ServletInvocableHandlerMethod.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.***.******.***(RequestMappingHandlerAdapter.java:***)***.******.***.***.******.***.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:**)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(DispatcherServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***(FrameworkServlet.java:***)***.******.***.HttpServlet.service(HttpServlet.java:***)***.******.***.***.******.***.doFilter(WsFilter.java:**)***.******.***.***.******.***(CharacterEncodingFilter.java:***)***.******.***.***.******.***(OncePerRequestFilter.java:***) Note The full stack trace of the root cause is available in the server logs.Apache Tomcat/***.******.***