error.2023-05-16.log 166 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731
  1. 10:00:55.012 [XNIO-1 task-4] ERROR c.z.x.c.e.GlobalExceptionHandler -
  2. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  3. WHERE oc_id = 406283' at line 5
  4. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  5. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  6. ### The error occurred while setting parameters
  7. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  8. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  9. WHERE oc_id = 406283' at line 5
  10. ; bad SQL grammar []
  11. org.springframework.jdbc.BadSqlGrammarException:
  12. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  13. WHERE oc_id = 406283' at line 5
  14. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  15. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  16. ### The error occurred while setting parameters
  17. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  18. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  19. WHERE oc_id = 406283' at line 5
  20. ; bad SQL grammar []
  21. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  22. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  23. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  24. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  25. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  26. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  27. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  28. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  29. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  30. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  31. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByList(Unknown Source)
  32. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  34. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  36. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  37. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  38. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  39. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  40. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  41. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  42. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByList(Unknown Source)
  43. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByList(GoafChecklistServiceImpl.java:53)
  44. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  45. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  46. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  47. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  48. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  49. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  50. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  51. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  52. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  53. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  54. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  55. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  56. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  57. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  58. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByList(<generated>)
  59. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistByList(GoafChecklistController.java:41)
  60. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  61. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  62. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  63. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  64. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  65. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  66. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  67. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  68. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  69. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  70. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  71. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  72. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  73. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  74. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  75. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  76. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  77. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  78. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  79. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  80. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  81. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  82. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  83. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  84. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  85. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  86. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  87. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  88. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  89. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  90. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  91. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  92. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  93. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  94. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  95. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  96. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  97. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  98. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  99. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  100. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  101. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  102. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  103. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  104. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  105. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  106. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  107. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  108. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  109. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  110. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  111. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  112. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  113. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  114. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  115. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  116. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  117. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  118. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  119. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  120. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  121. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  122. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  123. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  124. at java.base/java.lang.Thread.run(Thread.java:833)
  125. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  126. WHERE oc_id = 406283' at line 5
  127. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  128. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  129. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  130. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  131. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  132. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  133. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  134. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  135. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  136. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  137. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  138. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  139. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  140. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
  141. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  142. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  143. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  144. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  145. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  146. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  147. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  148. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  149. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  150. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  151. ... 100 common frames omitted
  152. 10:00:59.255 [XNIO-1 task-2] ERROR c.z.x.c.e.GlobalExceptionHandler -
  153. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  154. WHERE oc_id = 406283' at line 5
  155. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  156. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  157. ### The error occurred while setting parameters
  158. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  159. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  160. WHERE oc_id = 406283' at line 5
  161. ; bad SQL grammar []
  162. org.springframework.jdbc.BadSqlGrammarException:
  163. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  164. WHERE oc_id = 406283' at line 5
  165. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  166. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  167. ### The error occurred while setting parameters
  168. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  169. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  170. WHERE oc_id = 406283' at line 5
  171. ; bad SQL grammar []
  172. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  173. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  174. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  175. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  176. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  177. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  178. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  179. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  180. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  181. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  182. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByList(Unknown Source)
  183. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  184. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  185. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  186. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  187. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  188. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  189. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  190. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  191. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  192. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  193. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByList(Unknown Source)
  194. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByList(GoafChecklistServiceImpl.java:53)
  195. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  196. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  197. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  198. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  199. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  200. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  201. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  202. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  203. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  204. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  205. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  206. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  207. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  208. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  209. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByList(<generated>)
  210. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistByList(GoafChecklistController.java:41)
  211. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  212. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  213. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  214. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  215. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  216. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  217. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  218. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  219. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  220. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  221. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  222. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  223. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  224. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  225. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  226. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  227. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  228. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  229. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  230. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  231. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  232. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  233. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  234. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  235. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  236. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  237. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  238. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  239. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  240. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  241. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  242. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  243. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  244. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  245. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  246. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  247. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  248. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  249. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  250. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  251. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  252. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  253. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  254. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  255. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  256. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  257. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  258. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  259. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  260. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  261. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  262. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  263. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  264. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  265. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  266. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  267. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  268. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  269. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  270. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  271. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  272. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  273. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  274. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  275. at java.base/java.lang.Thread.run(Thread.java:833)
  276. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  277. WHERE oc_id = 406283' at line 5
  278. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  279. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  280. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  281. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  282. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  283. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  284. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  285. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  286. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  287. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  288. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  289. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  290. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  291. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
  292. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  293. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  294. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  295. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  296. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  297. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  298. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  299. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  300. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  301. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  302. ... 100 common frames omitted
  303. 10:01:07.647 [XNIO-1 task-2] ERROR c.z.x.c.e.GlobalExceptionHandler -
  304. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  305. WHERE oc_id = 406283' at line 5
  306. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  307. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  308. ### The error occurred while setting parameters
  309. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  310. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  311. WHERE oc_id = 406283' at line 5
  312. ; bad SQL grammar []
  313. org.springframework.jdbc.BadSqlGrammarException:
  314. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  315. WHERE oc_id = 406283' at line 5
  316. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  317. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  318. ### The error occurred while setting parameters
  319. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  320. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  321. WHERE oc_id = 406283' at line 5
  322. ; bad SQL grammar []
  323. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  324. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  325. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  326. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  327. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  328. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  329. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  330. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  331. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  332. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  333. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByList(Unknown Source)
  334. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  335. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  336. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  337. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  338. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  339. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  340. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  341. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  342. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  343. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  344. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByList(Unknown Source)
  345. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByList(GoafChecklistServiceImpl.java:53)
  346. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  347. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  348. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  349. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  350. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  351. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  352. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  353. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  354. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  355. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  356. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  357. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  358. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  359. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  360. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByList(<generated>)
  361. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistByList(GoafChecklistController.java:41)
  362. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  363. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  364. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  365. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  366. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  367. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  368. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  369. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  370. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  371. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  372. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  373. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  374. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  375. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  376. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  377. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  378. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  379. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  380. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  381. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  382. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  383. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  384. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  385. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  386. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  387. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  388. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  389. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  390. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  391. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  392. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  393. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  394. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  395. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  396. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  397. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  398. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  399. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  400. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  401. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  402. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  403. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  404. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  405. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  406. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  407. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  408. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  409. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  410. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  411. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  412. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  413. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  414. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  415. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  416. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  417. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  418. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  419. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  420. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  421. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  422. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  423. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  424. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  425. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  426. at java.base/java.lang.Thread.run(Thread.java:833)
  427. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  428. WHERE oc_id = 406283' at line 5
  429. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  430. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  431. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  432. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  433. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  434. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  435. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  436. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  437. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  438. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  439. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  440. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  441. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  442. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
  443. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  444. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  445. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  446. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  447. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  448. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  449. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  450. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  451. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  452. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  453. ... 100 common frames omitted
  454. 10:01:18.820 [XNIO-1 task-3] ERROR c.z.x.c.e.GlobalExceptionHandler -
  455. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  456. WHERE oc_id = 406283' at line 5
  457. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  458. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  459. ### The error occurred while setting parameters
  460. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  461. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  462. WHERE oc_id = 406283' at line 5
  463. ; bad SQL grammar []
  464. org.springframework.jdbc.BadSqlGrammarException:
  465. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  466. WHERE oc_id = 406283' at line 5
  467. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  468. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  469. ### The error occurred while setting parameters
  470. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  471. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  472. WHERE oc_id = 406283' at line 5
  473. ; bad SQL grammar []
  474. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  475. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  476. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  477. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  478. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  479. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  480. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  481. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  482. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  483. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  484. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByList(Unknown Source)
  485. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  486. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  487. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  488. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  489. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  490. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  491. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  492. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  493. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  494. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  495. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByList(Unknown Source)
  496. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByList(GoafChecklistServiceImpl.java:53)
  497. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  498. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  499. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  500. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  501. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  502. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  503. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  504. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  505. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  506. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  507. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  508. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  509. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  510. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  511. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByList(<generated>)
  512. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistByList(GoafChecklistController.java:41)
  513. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  514. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  515. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  516. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  517. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  518. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  519. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  520. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  521. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  522. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  523. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  524. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  525. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  526. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  527. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  528. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  529. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  530. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  531. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  532. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  533. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  534. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  535. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  536. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  537. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  538. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  539. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  540. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  541. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  542. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  543. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  544. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  545. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  546. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  547. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  548. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  549. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  550. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  551. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  552. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  553. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  554. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  555. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  556. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  557. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  558. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  559. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  560. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  561. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  562. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  563. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  564. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  565. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  566. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  567. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  568. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  569. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  570. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  571. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  572. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  573. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  574. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  575. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  576. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  577. at java.base/java.lang.Thread.run(Thread.java:833)
  578. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  579. WHERE oc_id = 406283' at line 5
  580. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  581. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  582. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  583. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  584. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  585. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  586. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  587. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  588. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  589. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  590. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  591. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  592. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  593. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
  594. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  595. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  596. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  597. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  598. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  599. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  600. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  601. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  602. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  603. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  604. ... 100 common frames omitted
  605. 10:01:50.549 [XNIO-1 task-2] ERROR c.z.x.c.e.GlobalExceptionHandler -
  606. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  607. WHERE oc_id = 406283' at line 5
  608. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  609. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  610. ### The error occurred while setting parameters
  611. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  612. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  613. WHERE oc_id = 406283' at line 5
  614. ; bad SQL grammar []
  615. org.springframework.jdbc.BadSqlGrammarException:
  616. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  617. WHERE oc_id = 406283' at line 5
  618. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  619. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByList-Inline
  620. ### The error occurred while setting parameters
  621. ### SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ?
  622. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  623. WHERE oc_id = 406283' at line 5
  624. ; bad SQL grammar []
  625. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  626. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  627. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  628. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  629. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  630. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  631. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  632. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  633. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  634. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  635. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByList(Unknown Source)
  636. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  637. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  638. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  639. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  640. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  641. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  642. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  643. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  644. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  645. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  646. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByList(Unknown Source)
  647. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByList(GoafChecklistServiceImpl.java:53)
  648. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  649. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  650. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  651. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  652. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  653. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  654. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  655. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  656. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  657. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  658. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  659. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  660. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  661. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  662. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByList(<generated>)
  663. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistByList(GoafChecklistController.java:41)
  664. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  665. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  666. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  667. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  668. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  669. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  670. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  671. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  672. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  673. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  674. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  675. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  676. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  677. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  678. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  679. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  680. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  681. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  682. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  683. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  684. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  685. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  686. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  687. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  688. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  689. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  690. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  691. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  692. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  693. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  694. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  695. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  696. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  697. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  698. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  699. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  700. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  701. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  702. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  703. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  704. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  705. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  706. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  707. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  708. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  709. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  710. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  711. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  712. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  713. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  714. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  715. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  716. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  717. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  718. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  719. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  720. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  721. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  722. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  723. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  724. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  725. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  726. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  727. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  728. at java.base/java.lang.Thread.run(Thread.java:833)
  729. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  730. WHERE oc_id = 406283' at line 5
  731. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  732. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  733. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  734. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  735. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  736. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  737. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  738. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  739. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  740. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  741. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  742. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  743. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  744. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151)
  745. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  746. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  747. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  748. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  749. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  750. at jdk.internal.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
  751. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  752. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  753. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  754. ... 100 common frames omitted
  755. 10:03:24.594 [XNIO-1 task-3] ERROR c.z.x.c.e.GlobalExceptionHandler -
  756. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  757. WHERE oc_id = 406283
  758. ) tmp_count' at line 6
  759. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  760. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByPage-Inline
  761. ### The error occurred while setting parameters
  762. ### SQL: select count(0) from ( SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ? ) tmp_count
  763. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  764. WHERE oc_id = 406283
  765. ) tmp_count' at line 6
  766. ; bad SQL grammar []
  767. org.springframework.jdbc.BadSqlGrammarException:
  768. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  769. WHERE oc_id = 406283
  770. ) tmp_count' at line 6
  771. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  772. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByPage-Inline
  773. ### The error occurred while setting parameters
  774. ### SQL: select count(0) from ( SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ? ) tmp_count
  775. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  776. WHERE oc_id = 406283
  777. ) tmp_count' at line 6
  778. ; bad SQL grammar []
  779. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  780. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  781. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  782. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  783. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  784. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  785. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  786. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  787. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  788. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  789. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByPage(Unknown Source)
  790. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  791. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  792. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  793. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  794. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  795. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  796. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  797. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  798. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  799. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  800. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByPage(Unknown Source)
  801. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByPage(GoafChecklistServiceImpl.java:78)
  802. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  803. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  804. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  805. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  806. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  807. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  808. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  809. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  810. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  811. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  812. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  813. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  814. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  815. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  816. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByPage(<generated>)
  817. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistBypage(GoafChecklistController.java:57)
  818. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  819. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  820. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  821. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  822. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  823. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  824. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  825. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  826. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  827. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  828. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  829. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  830. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  831. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  832. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  833. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  834. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  835. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  836. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  837. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  838. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  839. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  840. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  841. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  842. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  843. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  844. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  845. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  846. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  847. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  848. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  849. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  850. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  851. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  852. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  853. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  854. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  855. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  856. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  857. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  858. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  859. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  860. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  861. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  862. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  863. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  864. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  865. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  866. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  867. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  868. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  869. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  870. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  871. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  872. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  873. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  874. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  875. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  876. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  877. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  878. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  879. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  880. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  881. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  882. at java.base/java.lang.Thread.run(Thread.java:833)
  883. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  884. WHERE oc_id = 406283
  885. ) tmp_count' at line 6
  886. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  887. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  888. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  889. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  890. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  891. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  892. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  893. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  894. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  895. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  896. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  897. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  898. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  899. at com.github.pagehelper.util.ExecutorUtil.executeAutoCount(ExecutorUtil.java:169)
  900. at com.github.pagehelper.PageInterceptor.count(PageInterceptor.java:197)
  901. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:140)
  902. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  903. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  904. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  905. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  906. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  907. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  908. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  909. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  910. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  911. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  912. ... 100 common frames omitted
  913. 10:03:36.071 [XNIO-1 task-4] ERROR c.z.x.c.e.GlobalExceptionHandler -
  914. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  915. WHERE oc_id = 406283
  916. ) tmp_count' at line 6
  917. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  918. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByPage-Inline
  919. ### The error occurred while setting parameters
  920. ### SQL: select count(0) from ( SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ? ) tmp_count
  921. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  922. WHERE oc_id = 406283
  923. ) tmp_count' at line 6
  924. ; bad SQL grammar []
  925. org.springframework.jdbc.BadSqlGrammarException:
  926. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  927. WHERE oc_id = 406283
  928. ) tmp_count' at line 6
  929. ### The error may exist in file [E:\syf3prj\xps-server-3\xps-goaf\target\classes\mapper\GoafChecklistMapper.xml]
  930. ### The error may involve com.zhyc.xps.goaf.mapper.GoafChecklistMapper.getChecklistByPage-Inline
  931. ### The error occurred while setting parameters
  932. ### SQL: select count(0) from ( SELECT checklist_id, oc_id, checklist_title, checklist_desc, FROM goaf_checklist WHERE oc_id = ? ) tmp_count
  933. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  934. WHERE oc_id = 406283
  935. ) tmp_count' at line 6
  936. ; bad SQL grammar []
  937. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:243)
  938. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  939. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  940. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  941. at jdk.proxy2/jdk.proxy2.$Proxy108.selectList(Unknown Source)
  942. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  943. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  944. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  945. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  946. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  947. at jdk.proxy3/jdk.proxy3.$Proxy370.getChecklistByPage(Unknown Source)
  948. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  949. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  950. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  951. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  952. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  953. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  954. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  955. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  956. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  957. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  958. at jdk.proxy3/jdk.proxy3.$Proxy371.getChecklistByPage(Unknown Source)
  959. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistByPage(GoafChecklistServiceImpl.java:78)
  960. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  961. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  962. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  963. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  964. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  965. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  966. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  967. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  968. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  969. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  970. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  971. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  972. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  973. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  974. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistByPage(<generated>)
  975. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistBypage(GoafChecklistController.java:57)
  976. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  977. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  978. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  979. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  980. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  981. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  982. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  983. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  984. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  985. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  986. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  987. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  988. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  989. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  990. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  991. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  992. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  993. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  994. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  995. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  996. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  997. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  998. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  999. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1000. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1001. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1002. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1003. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1004. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1005. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1006. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1007. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1008. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1009. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1010. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1011. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1012. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1013. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1014. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1015. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1016. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1017. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1018. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1019. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1020. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1021. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1022. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1023. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1024. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1025. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1026. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1027. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1028. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1029. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1030. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1031. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1032. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1033. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1034. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1035. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1036. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1037. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1038. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1039. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1040. at java.base/java.lang.Thread.run(Thread.java:833)
  1041. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM goaf_checklist
  1042. WHERE oc_id = 406283
  1043. ) tmp_count' at line 6
  1044. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  1045. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  1046. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  1047. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  1048. at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
  1049. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  1050. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  1051. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  1052. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  1053. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  1054. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  1055. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  1056. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  1057. at com.github.pagehelper.util.ExecutorUtil.executeAutoCount(ExecutorUtil.java:169)
  1058. at com.github.pagehelper.PageInterceptor.count(PageInterceptor.java:197)
  1059. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:140)
  1060. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  1061. at jdk.proxy2/jdk.proxy2.$Proxy400.query(Unknown Source)
  1062. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  1063. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  1064. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  1065. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1066. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1067. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1068. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1069. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  1070. ... 100 common frames omitted
  1071. 10:05:58.331 [XNIO-1 task-2] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  1072. org.mybatis.spring.MyBatisSystemException: null
  1073. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  1074. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  1075. at jdk.proxy2/jdk.proxy2.$Proxy108.selectOne(Unknown Source)
  1076. at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
  1077. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
  1078. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  1079. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  1080. at jdk.proxy3/jdk.proxy3.$Proxy368.getChecklistItemById(Unknown Source)
  1081. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1082. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1083. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1084. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1085. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  1086. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  1087. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  1088. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  1089. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  1090. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  1091. at jdk.proxy3/jdk.proxy3.$Proxy369.getChecklistItemById(Unknown Source)
  1092. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl.getChecklistItemById(GoafChecklistServiceImpl.java:97)
  1093. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1094. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1095. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1096. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1097. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  1098. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  1099. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  1100. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  1101. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  1102. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  1103. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  1104. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  1105. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  1106. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  1107. at com.zhyc.xps.goaf.service.impl.GoafChecklistServiceImpl$$SpringCGLIB$$0.getChecklistItemById(<generated>)
  1108. at com.zhyc.xps.goaf.controller.GoafChecklistController.getGoafChecklistItemById(GoafChecklistController.java:88)
  1109. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1110. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1111. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1112. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1113. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1114. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1115. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1116. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1117. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1118. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1119. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1120. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1121. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1122. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1123. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1124. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1125. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1126. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1127. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1128. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1129. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1130. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1131. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1132. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1133. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1134. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1135. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1136. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1137. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1138. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1139. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1140. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1141. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1142. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1143. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1144. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1145. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1146. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1147. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1148. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1149. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1150. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1151. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1152. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1153. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1154. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1155. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1156. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1157. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1158. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1159. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1160. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1161. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1162. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1163. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1164. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1165. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1166. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1167. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1168. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1169. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1170. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1171. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1172. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1173. at java.base/java.lang.Thread.run(Thread.java:833)
  1174. Caused by: org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2
  1175. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:80)
  1176. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1177. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1178. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1179. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1180. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  1181. ... 99 common frames omitted
  1182. 11:19:52.115 [XNIO-1 task-4] ERROR c.z.x.c.e.GlobalExceptionHandler - Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1183. java.lang.NullPointerException: Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1184. at com.zhyc.xps.common.controller.BaseController.getCurOcId(BaseController.java:149)
  1185. at com.zhyc.xps.goaf.controller.GoafBaseInfoController.getGoafBaseInfoByList(GoafBaseInfoController.java:37)
  1186. at jdk.internal.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)
  1187. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1188. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1189. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1190. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1191. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1192. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1193. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1194. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1195. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1196. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1197. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1198. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1199. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1200. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1201. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1202. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1203. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1204. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1205. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1206. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1207. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1208. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1209. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1210. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1211. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1212. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1213. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1214. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1215. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1216. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1217. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1218. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1219. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1220. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1221. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1222. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1223. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1224. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1225. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1226. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1227. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1228. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1229. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1230. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1231. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1232. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1233. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1234. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1235. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1236. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1237. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1238. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1239. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1240. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1241. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1242. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1243. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1244. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1245. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1246. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1247. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1248. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1249. at java.base/java.lang.Thread.run(Thread.java:833)
  1250. 11:19:52.115 [XNIO-1 task-9] ERROR c.z.x.c.e.GlobalExceptionHandler - Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1251. java.lang.NullPointerException: Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1252. at com.zhyc.xps.common.controller.BaseController.getCurOcId(BaseController.java:149)
  1253. at com.zhyc.xps.sys.controller.EntMapController.getMapByList(EntMapController.java:57)
  1254. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1255. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1256. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1257. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1258. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1259. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1260. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1261. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1262. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1263. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1264. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1265. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1266. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1267. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1268. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1269. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1270. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1271. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1272. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1273. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1274. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1275. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1276. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1277. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1278. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1279. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1280. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1281. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1282. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1283. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1284. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1285. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1286. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1287. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1288. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1289. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1290. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1291. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1292. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1293. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1294. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1295. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1296. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1297. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1298. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1299. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1300. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1301. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1302. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1303. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1304. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1305. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1306. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1307. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1308. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1309. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1310. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1311. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1312. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1313. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1314. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1315. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1316. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1317. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1318. at java.base/java.lang.Thread.run(Thread.java:833)
  1319. 16:13:51.606 [XNIO-1 task-7] ERROR c.z.x.c.e.GlobalExceptionHandler - Could not open JDBC Connection for transaction
  1320. org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction
  1321. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:309)
  1322. at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
  1323. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  1324. at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:600)
  1325. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:384)
  1326. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  1327. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  1328. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  1329. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  1330. at com.zhyc.xps.sys.service.impl.ClientServiceImpl$$SpringCGLIB$$0.getClientByKey(<generated>)
  1331. at com.zhyc.xps.sys.controller.LoginController.login(LoginController.java:50)
  1332. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1333. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  1334. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1335. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1336. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1337. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1338. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1339. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1340. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1341. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1342. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1343. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1344. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1345. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
  1346. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:547)
  1347. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1348. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1349. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1350. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1351. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1352. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1353. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1354. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1355. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1356. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1357. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1358. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1359. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1360. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1361. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1362. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1363. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1364. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1365. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1366. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1367. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1368. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1369. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1370. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1371. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1372. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1373. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1374. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1375. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1376. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1377. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1378. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1379. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1380. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1381. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1382. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1383. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1384. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1385. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1386. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1387. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1388. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1389. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1390. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1391. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1392. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1393. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1394. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1395. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1396. at java.base/java.lang.Thread.run(Thread.java:833)
  1397. Caused by: java.sql.SQLException: DatebookHikariCP - Interrupted during connection acquisition
  1398. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  1399. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
  1400. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1401. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:265)
  1402. ... 75 common frames omitted
  1403. Caused by: java.lang.InterruptedException: null
  1404. at java.base/java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:906)
  1405. at com.zaxxer.hikari.util.ConcurrentBag.borrow(ConcurrentBag.java:151)
  1406. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:164)
  1407. ... 78 common frames omitted
  1408. 18:38:30.601 [XNIO-1 task-3] ERROR c.z.x.c.e.GlobalExceptionHandler - Could not open JDBC Connection for transaction
  1409. org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction
  1410. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:309)
  1411. at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
  1412. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  1413. at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:600)
  1414. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:384)
  1415. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  1416. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  1417. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  1418. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  1419. at com.zhyc.xps.sys.service.impl.ClientServiceImpl$$SpringCGLIB$$0.getClientByKey(<generated>)
  1420. at com.zhyc.xps.sys.controller.UserProfileController.getPermitListByRole(UserProfileController.java:71)
  1421. at jdk.internal.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)
  1422. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1423. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1424. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1425. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1426. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1427. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1428. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1429. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1430. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1431. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1432. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1433. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1434. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1435. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1436. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1437. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1438. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1439. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1440. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1441. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1442. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1443. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1444. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1445. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1446. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1447. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1448. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1449. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1450. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1451. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1452. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1453. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1454. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1455. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1456. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1457. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1458. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1459. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1460. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1461. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1462. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1463. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1464. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1465. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1466. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1467. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1468. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1469. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1470. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1471. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1472. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1473. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1474. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1475. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1476. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1477. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1478. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1479. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1480. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1481. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1482. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1483. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1484. at java.base/java.lang.Thread.run(Thread.java:833)
  1485. Caused by: java.sql.SQLException: DatebookHikariCP - Interrupted during connection acquisition
  1486. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  1487. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
  1488. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1489. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:265)
  1490. ... 74 common frames omitted
  1491. Caused by: java.lang.InterruptedException: null
  1492. at java.base/java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:906)
  1493. at com.zaxxer.hikari.util.ConcurrentBag.borrow(ConcurrentBag.java:151)
  1494. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:164)
  1495. ... 77 common frames omitted
  1496. 18:38:30.635 [XNIO-1 task-3] ERROR io.undertow.request - UT005023: Exception handling request to /user/permit
  1497. jakarta.servlet.ServletException: Request processing failed: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction
  1498. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1019)
  1499. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1500. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1501. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1502. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1503. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1504. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1505. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1506. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1507. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1508. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1509. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1510. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1511. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1512. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1513. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1514. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1515. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1516. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1517. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1518. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1519. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1520. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1521. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1522. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1523. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1524. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1525. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1526. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1527. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1528. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1529. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1530. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1531. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1532. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1533. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1534. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1535. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1536. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1537. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1538. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1539. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1540. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1541. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1542. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1543. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1544. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1545. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1546. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1547. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1548. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1549. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1550. at java.base/java.lang.Thread.run(Thread.java:833)
  1551. Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction
  1552. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:309)
  1553. at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
  1554. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  1555. at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:600)
  1556. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:384)
  1557. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  1558. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  1559. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  1560. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  1561. at com.zhyc.xps.sys.service.impl.ClientServiceImpl$$SpringCGLIB$$0.getClientByKey(<generated>)
  1562. at com.zhyc.xps.sys.controller.UserProfileController.getPermitListByRole(UserProfileController.java:71)
  1563. at jdk.internal.reflect.GeneratedMethodAccessor478.invoke(Unknown Source)
  1564. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1565. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1566. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1567. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1568. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1569. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1570. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1571. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1572. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1573. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1574. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1575. ... 52 common frames omitted
  1576. Caused by: java.sql.SQLException: DatebookHikariCP - Interrupted during connection acquisition
  1577. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  1578. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
  1579. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1580. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:265)
  1581. ... 74 common frames omitted
  1582. Caused by: java.lang.InterruptedException: null
  1583. at java.base/java.util.concurrent.SynchronousQueue.poll(SynchronousQueue.java:906)
  1584. at com.zaxxer.hikari.util.ConcurrentBag.borrow(ConcurrentBag.java:151)
  1585. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:164)
  1586. ... 77 common frames omitted
  1587. 19:05:29.117 [XNIO-1 task-7] ERROR c.z.x.c.e.GlobalExceptionHandler - Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1588. java.lang.NullPointerException: Cannot invoke "com.zhyc.xps.common.dto.UserDto.getOcId()" because the return value of "com.zhyc.xps.common.controller.BaseController.getCurUser()" is null
  1589. at com.zhyc.xps.common.controller.BaseController.getCurOcId(BaseController.java:149)
  1590. at com.zhyc.xps.sys.controller.EntMapController.getMapByList(EntMapController.java:57)
  1591. at jdk.internal.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
  1592. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1593. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  1594. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  1595. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  1596. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1597. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1598. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1599. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1600. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1601. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1602. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1603. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  1604. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  1605. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1606. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1607. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1608. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1609. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1610. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1611. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1612. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1613. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1614. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1615. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1616. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1617. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1618. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1619. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1620. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1621. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1622. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1623. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1624. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1625. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1626. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1627. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1628. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1629. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1630. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1631. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1632. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1633. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1634. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1635. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1636. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1637. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1638. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1639. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1640. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1641. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1642. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1643. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1644. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1645. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1646. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1647. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1648. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1649. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1650. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1651. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1652. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1653. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1654. at java.base/java.lang.Thread.run(Thread.java:833)
  1655. 19:50:05.672 [XNIO-1 task-5] ERROR c.z.x.c.e.GlobalExceptionHandler - JSON parse error: parseLong error, value : undefined
  1656. org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: parseLong error, value : undefined
  1657. at com.alibaba.fastjson2.support.spring.http.converter.FastJsonHttpMessageConverter.readType(FastJsonHttpMessageConverter.java:110)
  1658. at com.alibaba.fastjson2.support.spring.http.converter.FastJsonHttpMessageConverter.read(FastJsonHttpMessageConverter.java:77)
  1659. at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodArgumentResolver.readWithMessageConverters(AbstractMessageConverterMethodArgumentResolver.java:183)
  1660. at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.readWithMessageConverters(RequestResponseBodyMethodProcessor.java:163)
  1661. at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.resolveArgument(RequestResponseBodyMethodProcessor.java:136)
  1662. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122)
  1663. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:181)
  1664. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:148)
  1665. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1666. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  1667. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1668. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1669. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  1670. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  1671. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  1672. at org.springframework.web.servlet.FrameworkServlet.doPut(FrameworkServlet.java:925)
  1673. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:550)
  1674. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  1675. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  1676. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  1677. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  1678. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  1679. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1680. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1681. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1682. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1683. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1684. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1685. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  1686. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1687. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1688. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1689. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1690. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  1691. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  1692. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  1693. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  1694. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  1695. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  1696. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  1697. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  1698. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  1699. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  1700. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1701. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  1702. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  1703. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  1704. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  1705. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  1706. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1707. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  1708. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  1709. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  1710. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  1711. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  1712. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  1713. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  1714. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  1715. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  1716. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  1717. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  1718. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  1719. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  1720. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  1721. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  1722. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  1723. at java.base/java.lang.Thread.run(Thread.java:833)
  1724. Caused by: com.alibaba.fastjson2.JSONException: parseLong error, value : undefined
  1725. at com.alibaba.fastjson2.JSONReader.toInt64(JSONReader.java:2504)
  1726. at com.alibaba.fastjson2.JSONReader.getInt64(JSONReader.java:650)
  1727. at com.alibaba.fastjson2.JSONReaderUTF8.readInt64(JSONReaderUTF8.java:2242)
  1728. at com.alibaba.fastjson2.reader.ORG_3_26_GoafBaseInfo.readObject(Unknown Source)
  1729. at com.alibaba.fastjson2.JSON.parseObject(JSON.java:1240)
  1730. at com.alibaba.fastjson2.support.spring.http.converter.FastJsonHttpMessageConverter.readType(FastJsonHttpMessageConverter.java:108)
  1731. ... 66 common frames omitted