sys-error.log 45 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503
  1. 17:16:00.068 [schedule-pool-4] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  2. org.springframework.jdbc.BadSqlGrammarException:
  3. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  4. ### The error may exist in file [C:\Users\11868\Desktop\ducha-houduan\supervision-system\target\classes\mapper\militaryvehicleManagement\TcTodayInouttimeMapper.xml]
  5. ### The error may involve com.supervision.militaryvehicleManagement.mapper.TcTodayInouttimeMapper.selectTcTodayInouttimeList-Inline
  6. ### The error occurred while setting parameters
  7. ### SQL: select P_KEY, CarNO, In_time, Out_time,ReMark from TC_Inoutls where P_KEY>?
  8. ### Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  9. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  10. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  11. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  12. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  13. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  14. at com.sun.proxy.$Proxy113.selectList(Unknown Source)
  15. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  16. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  17. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  18. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  19. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  20. at com.sun.proxy.$Proxy227.selectTcTodayInouttimeList(Unknown Source)
  21. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl.selectTcTodayInouttimeList(TcTodayInouttimeServiceImpl.java:39)
  22. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$FastClassBySpringCGLIB$$d1e020a0.invoke(<generated>)
  23. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  24. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
  25. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  26. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  27. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
  28. at com.supervision.framework.aspectj.DataSourceAspect.around(DataSourceAspect.java:49)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  30. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  31. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  32. at java.lang.reflect.Method.invoke(Method.java:498)
  33. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
  34. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
  35. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
  36. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  37. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  38. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
  39. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  40. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  41. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
  42. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$EnhancerBySpringCGLIB$$ed0d6f00.selectTcTodayInouttimeList(<generated>)
  43. at com.supervision.web.controller.militaryvehicleManagement.TimingController.updatePrivateCarState(TimingController.java:57)
  44. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  45. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  46. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  47. at java.lang.reflect.Method.invoke(Method.java:498)
  48. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  49. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  50. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  51. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  52. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  53. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  54. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  55. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  56. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  57. at java.lang.Thread.run(Thread.java:748)
  58. Caused by: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  59. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  60. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  61. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  62. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  63. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
  64. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  65. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
  66. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  67. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  68. at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  69. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  70. at java.lang.reflect.Method.invoke(Method.java:498)
  71. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  72. at com.sun.proxy.$Proxy135.execute(Unknown Source)
  73. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  74. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  75. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  76. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  77. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  78. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  79. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
  80. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  81. at com.sun.proxy.$Proxy339.query(Unknown Source)
  82. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  83. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  84. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  85. at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  86. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  87. at java.lang.reflect.Method.invoke(Method.java:498)
  88. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  89. ... 44 common frames omitted
  90. 17:17:00.024 [schedule-pool-5] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  91. org.springframework.jdbc.BadSqlGrammarException:
  92. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  93. ### The error may exist in file [C:\Users\11868\Desktop\ducha-houduan\supervision-system\target\classes\mapper\militaryvehicleManagement\TcTodayInouttimeMapper.xml]
  94. ### The error may involve com.supervision.militaryvehicleManagement.mapper.TcTodayInouttimeMapper.selectTcTodayInouttimeList-Inline
  95. ### The error occurred while setting parameters
  96. ### SQL: select P_KEY, CarNO, In_time, Out_time,ReMark from TC_Inoutls where P_KEY>?
  97. ### Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  98. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  99. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  100. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  101. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  102. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  103. at com.sun.proxy.$Proxy113.selectList(Unknown Source)
  104. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  105. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  106. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  107. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  108. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  109. at com.sun.proxy.$Proxy227.selectTcTodayInouttimeList(Unknown Source)
  110. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl.selectTcTodayInouttimeList(TcTodayInouttimeServiceImpl.java:39)
  111. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$FastClassBySpringCGLIB$$d1e020a0.invoke(<generated>)
  112. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  113. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
  114. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  115. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  116. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
  117. at com.supervision.framework.aspectj.DataSourceAspect.around(DataSourceAspect.java:49)
  118. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  119. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  120. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  121. at java.lang.reflect.Method.invoke(Method.java:498)
  122. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
  123. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
  124. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
  125. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  126. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  127. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
  128. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  129. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  130. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
  131. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$EnhancerBySpringCGLIB$$ed0d6f00.selectTcTodayInouttimeList(<generated>)
  132. at com.supervision.web.controller.militaryvehicleManagement.TimingController.updatePrivateCarState(TimingController.java:57)
  133. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  134. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  135. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  136. at java.lang.reflect.Method.invoke(Method.java:498)
  137. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  138. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  139. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  140. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  141. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  142. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  143. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  144. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  145. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  146. at java.lang.Thread.run(Thread.java:748)
  147. Caused by: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  148. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  149. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  150. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  151. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  152. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
  153. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  154. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
  155. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  156. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  157. at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  158. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  159. at java.lang.reflect.Method.invoke(Method.java:498)
  160. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  161. at com.sun.proxy.$Proxy135.execute(Unknown Source)
  162. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  163. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  164. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  165. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  166. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  167. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  168. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
  169. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  170. at com.sun.proxy.$Proxy339.query(Unknown Source)
  171. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  172. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  173. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  174. at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  175. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  176. at java.lang.reflect.Method.invoke(Method.java:498)
  177. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  178. ... 44 common frames omitted
  179. 17:18:00.012 [schedule-pool-8] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  180. org.springframework.jdbc.BadSqlGrammarException:
  181. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  182. ### The error may exist in file [C:\Users\11868\Desktop\ducha-houduan\supervision-system\target\classes\mapper\militaryvehicleManagement\TcTodayInouttimeMapper.xml]
  183. ### The error may involve com.supervision.militaryvehicleManagement.mapper.TcTodayInouttimeMapper.selectTcTodayInouttimeList-Inline
  184. ### The error occurred while setting parameters
  185. ### SQL: select P_KEY, CarNO, In_time, Out_time,ReMark from TC_Inoutls where P_KEY>?
  186. ### Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  187. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  188. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  189. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  190. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  191. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  192. at com.sun.proxy.$Proxy113.selectList(Unknown Source)
  193. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  194. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  195. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  196. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  197. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  198. at com.sun.proxy.$Proxy227.selectTcTodayInouttimeList(Unknown Source)
  199. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl.selectTcTodayInouttimeList(TcTodayInouttimeServiceImpl.java:39)
  200. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$FastClassBySpringCGLIB$$d1e020a0.invoke(<generated>)
  201. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  202. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
  203. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  204. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  205. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
  206. at com.supervision.framework.aspectj.DataSourceAspect.around(DataSourceAspect.java:49)
  207. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  208. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  209. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  210. at java.lang.reflect.Method.invoke(Method.java:498)
  211. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
  212. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
  213. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
  214. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  215. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  216. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
  217. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  218. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  219. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
  220. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$EnhancerBySpringCGLIB$$ed0d6f00.selectTcTodayInouttimeList(<generated>)
  221. at com.supervision.web.controller.militaryvehicleManagement.TimingController.updatePrivateCarState(TimingController.java:57)
  222. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  223. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  224. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  225. at java.lang.reflect.Method.invoke(Method.java:498)
  226. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  227. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  228. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  229. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  230. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  231. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  232. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  233. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  234. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  235. at java.lang.Thread.run(Thread.java:748)
  236. Caused by: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  237. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  238. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  239. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  240. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  241. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
  242. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  243. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
  244. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  245. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  246. at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  247. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  248. at java.lang.reflect.Method.invoke(Method.java:498)
  249. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  250. at com.sun.proxy.$Proxy135.execute(Unknown Source)
  251. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  252. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  253. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  254. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  255. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  256. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  257. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
  258. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  259. at com.sun.proxy.$Proxy339.query(Unknown Source)
  260. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  261. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  262. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  263. at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  264. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  265. at java.lang.reflect.Method.invoke(Method.java:498)
  266. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  267. ... 44 common frames omitted
  268. 17:19:00.012 [schedule-pool-3] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  269. org.springframework.jdbc.BadSqlGrammarException:
  270. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  271. ### The error may exist in file [C:\Users\11868\Desktop\ducha-houduan\supervision-system\target\classes\mapper\militaryvehicleManagement\TcTodayInouttimeMapper.xml]
  272. ### The error may involve com.supervision.militaryvehicleManagement.mapper.TcTodayInouttimeMapper.selectTcTodayInouttimeList-Inline
  273. ### The error occurred while setting parameters
  274. ### SQL: select P_KEY, CarNO, In_time, Out_time,ReMark from TC_Inoutls where P_KEY>?
  275. ### Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  276. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  277. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  278. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  279. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  280. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  281. at com.sun.proxy.$Proxy113.selectList(Unknown Source)
  282. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  283. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  284. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  285. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  286. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  287. at com.sun.proxy.$Proxy227.selectTcTodayInouttimeList(Unknown Source)
  288. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl.selectTcTodayInouttimeList(TcTodayInouttimeServiceImpl.java:39)
  289. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$FastClassBySpringCGLIB$$d1e020a0.invoke(<generated>)
  290. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  291. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
  292. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  293. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  294. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
  295. at com.supervision.framework.aspectj.DataSourceAspect.around(DataSourceAspect.java:49)
  296. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  297. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  298. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  299. at java.lang.reflect.Method.invoke(Method.java:498)
  300. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
  301. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
  302. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
  303. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  304. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  305. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
  306. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  307. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  308. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
  309. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$EnhancerBySpringCGLIB$$ed0d6f00.selectTcTodayInouttimeList(<generated>)
  310. at com.supervision.web.controller.militaryvehicleManagement.TimingController.updatePrivateCarState(TimingController.java:57)
  311. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  312. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  313. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  314. at java.lang.reflect.Method.invoke(Method.java:498)
  315. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  316. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  317. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  318. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  319. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  320. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  321. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  322. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  323. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  324. at java.lang.Thread.run(Thread.java:748)
  325. Caused by: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  326. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  327. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  328. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  329. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  330. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
  331. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  332. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
  333. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  334. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  335. at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  336. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  337. at java.lang.reflect.Method.invoke(Method.java:498)
  338. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  339. at com.sun.proxy.$Proxy135.execute(Unknown Source)
  340. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  341. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  342. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  343. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  344. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  345. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  346. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
  347. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  348. at com.sun.proxy.$Proxy339.query(Unknown Source)
  349. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  350. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  351. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  352. at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  353. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  354. at java.lang.reflect.Method.invoke(Method.java:498)
  355. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  356. ... 44 common frames omitted
  357. 17:20:00.041 [schedule-pool-5] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  358. org.springframework.jdbc.BadSqlGrammarException:
  359. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  360. ### The error may exist in file [C:\Users\11868\Desktop\ducha-houduan\supervision-system\target\classes\mapper\militaryvehicleManagement\TcTodayInouttimeMapper.xml]
  361. ### The error may involve com.supervision.militaryvehicleManagement.mapper.TcTodayInouttimeMapper.selectTcTodayInouttimeList-Inline
  362. ### The error occurred while setting parameters
  363. ### SQL: select P_KEY, CarNO, In_time, Out_time,ReMark from TC_Inoutls where P_KEY>?
  364. ### Cause: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  365. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  366. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  367. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  368. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  369. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  370. at com.sun.proxy.$Proxy113.selectList(Unknown Source)
  371. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  372. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  373. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  374. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  375. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  376. at com.sun.proxy.$Proxy227.selectTcTodayInouttimeList(Unknown Source)
  377. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl.selectTcTodayInouttimeList(TcTodayInouttimeServiceImpl.java:39)
  378. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$FastClassBySpringCGLIB$$d1e020a0.invoke(<generated>)
  379. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  380. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
  381. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  382. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  383. at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
  384. at com.supervision.framework.aspectj.DataSourceAspect.around(DataSourceAspect.java:49)
  385. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  386. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  387. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  388. at java.lang.reflect.Method.invoke(Method.java:498)
  389. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
  390. at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
  391. at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
  392. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
  393. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  394. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
  395. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  396. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
  397. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
  398. at com.supervision.militaryvehicleManagement.service.impl.TcTodayInouttimeServiceImpl$$EnhancerBySpringCGLIB$$ed0d6f00.selectTcTodayInouttimeList(<generated>)
  399. at com.supervision.web.controller.militaryvehicleManagement.TimingController.updatePrivateCarState(TimingController.java:57)
  400. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  401. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  402. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  403. at java.lang.reflect.Method.invoke(Method.java:498)
  404. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  405. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  406. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  407. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  408. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  409. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  410. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  411. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  412. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  413. at java.lang.Thread.run(Thread.java:748)
  414. Caused by: java.sql.SQLSyntaxErrorException: La table 'supervision04.tc_inoutls' n'existe pas
  415. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  416. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  417. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  418. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  419. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
  420. at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  421. at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
  422. at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  423. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  424. at sun.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)
  425. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  426. at java.lang.reflect.Method.invoke(Method.java:498)
  427. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  428. at com.sun.proxy.$Proxy135.execute(Unknown Source)
  429. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  430. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  431. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  432. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  433. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  434. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  435. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
  436. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  437. at com.sun.proxy.$Proxy339.query(Unknown Source)
  438. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  439. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  440. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  441. at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
  442. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  443. at java.lang.reflect.Method.invoke(Method.java:498)
  444. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  445. ... 44 common frames omitted
  446. 17:20:02.071 [schedule-pool-1] ERROR c.s.c.u.h.HttpUtils - [sendPost,157] - 调用HttpUtils.sendPost ConnectException, url=http://127.0.0.1:85/api/v2/employee/get/?key=2633p84hnnlavzcy9afjcbtj1jdnega0ftscjkka6h7a,param={"offduty":2}
  447. java.net.ConnectException: Connection refused: connect
  448. at java.net.DualStackPlainSocketImpl.connect0(Native Method)
  449. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
  450. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  451. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  452. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  453. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  454. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  455. at java.net.Socket.connect(Socket.java:589)
  456. at java.net.Socket.connect(Socket.java:538)
  457. at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
  458. at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
  459. at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
  460. at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
  461. at sun.net.www.http.HttpClient.New(HttpClient.java:339)
  462. at sun.net.www.http.HttpClient.New(HttpClient.java:357)
  463. at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
  464. at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
  465. at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
  466. at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
  467. at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1334)
  468. at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1309)
  469. at com.supervision.common.utils.http.HttpUtils.sendPost(HttpUtils.java:144)
  470. at com.supervision.grassrootsregistration.service.impl.BdglAttendanceRecordServiceImpl.getemployeeinfo(BdglAttendanceRecordServiceImpl.java:174)
  471. at com.supervision.web.controller.grassrootsregistration.GrassrootsregistrationController.getemployeeinfo(GrassrootsregistrationController.java:285)
  472. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  473. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  474. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  475. at java.lang.reflect.Method.invoke(Method.java:498)
  476. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  477. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  478. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  479. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  480. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  481. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  482. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  483. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  484. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  485. at java.lang.Thread.run(Thread.java:748)
  486. 17:20:02.073 [schedule-pool-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - [handleError,95] - Unexpected error occurred in scheduled task
  487. java.lang.NullPointerException: null
  488. at com.supervision.grassrootsregistration.service.impl.BdglAttendanceRecordServiceImpl.getemployeeinfo(BdglAttendanceRecordServiceImpl.java:176)
  489. at com.supervision.web.controller.grassrootsregistration.GrassrootsregistrationController.getemployeeinfo(GrassrootsregistrationController.java:285)
  490. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  491. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  492. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  493. at java.lang.reflect.Method.invoke(Method.java:498)
  494. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  495. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  496. at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:95)
  497. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  498. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  499. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
  500. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
  501. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  502. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  503. at java.lang.Thread.run(Thread.java:748)