123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831 |
- [2024-01-15 12:57:45.599] [ restartedMain] [ERROR] com.its.web.config.DatabaseConfig.sqlSessionFactoryBean 17348
- sqlSessionFactoryBean: IOException
- [2024-01-15 12:57:45.614] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 17348
- Application run failed
- org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/web/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
- at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
- at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
- at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
- at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:771)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:763)
- at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:438)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1318)
- at com.its.web.ItsWebServerApplication.main(ItsWebServerApplication.java:10)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
- Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
- ... 25 common frames omitted
- Caused by: java.lang.NullPointerException: null
- at org.mybatis.spring.SqlSessionTemplate.<init>(SqlSessionTemplate.java:92)
- at com.its.web.config.DatabaseConfig.sqlSession(DatabaseConfig.java:76)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$3ca8b384.CGLIB$sqlSession$3(<generated>)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$3ca8b384$$FastClassBySpringCGLIB$$87dda131.invoke(<generated>)
- at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
- at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$3ca8b384.sqlSession(<generated>)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
- ... 26 common frames omitted
- [2024-01-15 12:59:31.593] [ restartedMain] [ERROR] com.its.web.config.DatabaseConfig.sqlSessionFactoryBean 6380
- sqlSessionFactoryBean: IOException
- [2024-01-15 12:59:31.625] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 6380
- Application run failed
- org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/web/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
- at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
- at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
- at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
- at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:771)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:763)
- at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:438)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1318)
- at com.its.web.ItsWebServerApplication.main(ItsWebServerApplication.java:10)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
- Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
- ... 25 common frames omitted
- Caused by: java.lang.NullPointerException: null
- at org.mybatis.spring.SqlSessionTemplate.<init>(SqlSessionTemplate.java:92)
- at com.its.web.config.DatabaseConfig.sqlSession(DatabaseConfig.java:76)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$df1b3966.CGLIB$sqlSession$1(<generated>)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$df1b3966$$FastClassBySpringCGLIB$$b8fbdfd6.invoke(<generated>)
- at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
- at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$df1b3966.sqlSession(<generated>)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
- ... 26 common frames omitted
- [2024-01-15 13:07:30.269] [ restartedMain] [ERROR] com.its.web.config.DatabaseConfig.sqlSessionFactoryBean 14328
- sqlSessionFactoryBean: IOException
- [2024-01-15 13:07:30.285] [ restartedMain] [ERROR] o.s.boot.SpringApplication.reportFailure 14328
- Application run failed
- org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSession' defined in class path resource [com/its/web/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582)
- at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
- at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
- at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
- at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
- at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
- at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944)
- at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
- at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
- at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:144)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:771)
- at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:763)
- at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:438)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:339)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1329)
- at org.springframework.boot.SpringApplication.run(SpringApplication.java:1318)
- at com.its.web.ItsWebServerApplication.main(ItsWebServerApplication.java:10)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
- Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.mybatis.spring.SqlSessionTemplate]: Factory method 'sqlSession' threw exception; nested exception is java.lang.NullPointerException
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
- at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653)
- ... 25 common frames omitted
- Caused by: java.lang.NullPointerException: null
- at org.mybatis.spring.SqlSessionTemplate.<init>(SqlSessionTemplate.java:92)
- at com.its.web.config.DatabaseConfig.sqlSession(DatabaseConfig.java:76)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$a68580a6.CGLIB$sqlSession$4(<generated>)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$a68580a6$$FastClassBySpringCGLIB$$9fa730fc.invoke(<generated>)
- at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
- at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
- at com.its.web.config.DatabaseConfig$$EnhancerBySpringCGLIB$$a68580a6.sqlSession(<generated>)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
- ... 26 common frames omitted
- [2024-01-15 16:35:12.586] [ http-nio-8996-exec-10] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 13136
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
- ### Error querying database. Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ### The error may exist in file [C:\00.PROJECT\24.01.PHITS-WEB\its-web-server\target\classes\mybatis\mapper\statistics\StatisticsMapper.xml]
- ### The error may involve com.its.web.mapper.statistics.StatisticsMapper.findAllTrafficAmountStatistics-Inline
- ### The error occurred while setting parameters
- ### SQL: SELECT A.ROAD_ID AS ROAD_ID, D.STRT_NM || ' > ' || D.END_NM AS SECT_NM, SUBSTR(A.STAT_DT, 7, 2) AS STAT_DT, SUM(A.TFVL) AS TFVL_TOT FROM TB_ROAD_DD_STAT A, TB_ATRD_ROAD_RLTN B, TB_ATRD C, TB_ROAD D WHERE A.ROAD_ID = B.ROAD_ID AND B.ATRD_ID = C.ATRD_ID AND B.ROAD_ID = D.ROAD_ID AND TO_DATE(A.STAT_DT, 'YYYYMMDDHH24MISS') BETWEEN TO_DATE(?, 'YYYYMMDDHH24MISS') AND TO_DATE(?, 'YYYYMMDDHH24MISS') GROUP BY SUBSTR(A.STAT_DT, 7, 2) , A.ROAD_ID, D.STRT_NM || ' > ' || D.END_NM, B.ATRD_ID, B.ORD ORDER BY STAT_DT, B.ATRD_ID, B.ORD;
- ### Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ; JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.; nested exception is java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.] with root cause
- java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source)
- at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbStream.readMsg(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbCommType4.prepareExecute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeCompleteSQL(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeInternal(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.execute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatement.execute(Unknown Source)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
- at com.sun.proxy.$Proxy88.selectList(Unknown Source)
- at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
- at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
- at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
- at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
- at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
- at com.sun.proxy.$Proxy89.findAllTrafficAmountStatistics(Unknown Source)
- at com.its.web.service.statistics.StatisticsService.findAllTrafficAmountStatistics(StatisticsService.java:40)
- at com.its.web.controller.statistics.StatisticsController.findAllTrafficAmountStatistics(StatisticsController.java:33)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 16:37:34.782] [ http-nio-8996-exec-1] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 21892
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
- ### Error querying database. Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ### The error may exist in file [C:\00.PROJECT\24.01.PHITS-WEB\its-web-server\target\classes\mybatis\mapper\statistics\StatisticsMapper.xml]
- ### The error may involve com.its.web.mapper.statistics.StatisticsMapper.findAllTrafficAmountStatistics-Inline
- ### The error occurred while setting parameters
- ### SQL: SELECT A.ROAD_ID AS ROAD_ID, D.STRT_NM || ' > ' || D.END_NM AS SECT_NM, SUBSTR(A.STAT_DT, 7, 2) AS STAT_DT, SUM(A.TFVL) AS TFVL_TOT FROM TB_ROAD_DD_STAT A, TB_ATRD_ROAD_RLTN B, TB_ATRD C, TB_ROAD D WHERE A.ROAD_ID = B.ROAD_ID AND B.ATRD_ID = C.ATRD_ID AND B.ROAD_ID = D.ROAD_ID AND TO_DATE(A.STAT_DT, 'YYYYMMDDHH24MISS') BETWEEN TO_DATE(?, 'YYYYMMDDHH24MISS') AND TO_DATE(?, 'YYYYMMDDHH24MISS') GROUP BY SUBSTR(A.STAT_DT, 7, 2) , A.ROAD_ID, D.STRT_NM || ' > ' || D.END_NM, B.ATRD_ID, B.ORD ORDER BY STAT_DT, B.ATRD_ID, B.ORD;
- ### Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ; JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.; nested exception is java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.] with root cause
- java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source)
- at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbStream.readMsg(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbCommType4.prepareExecute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeCompleteSQL(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeInternal(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.execute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatement.execute(Unknown Source)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
- at com.sun.proxy.$Proxy88.selectList(Unknown Source)
- at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
- at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
- at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
- at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
- at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
- at com.sun.proxy.$Proxy89.findAllTrafficAmountStatistics(Unknown Source)
- at com.its.web.service.statistics.StatisticsService.findAllTrafficAmountStatistics(StatisticsService.java:40)
- at com.its.web.controller.statistics.StatisticsController.findAllTrafficAmountStatistics(StatisticsController.java:33)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 16:38:33.231] [ http-nio-8996-exec-1] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 22520
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
- ### Error querying database. Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ### The error may exist in file [C:\00.PROJECT\24.01.PHITS-WEB\its-web-server\target\classes\mybatis\mapper\statistics\StatisticsMapper.xml]
- ### The error may involve com.its.web.mapper.statistics.StatisticsMapper.findAllTrafficAmountStatistics-Inline
- ### The error occurred while setting parameters
- ### SQL: SELECT A.ROAD_ID AS ROAD_ID, D.STRT_NM || ' > ' || D.END_NM AS SECT_NM, SUBSTR(A.STAT_DT, 7, 2) AS STAT_DT, SUM(A.TFVL) AS TFVL_TOT FROM TB_ROAD_DD_STAT A, TB_ATRD_ROAD_RLTN B, TB_ATRD C, TB_ROAD D WHERE A.ROAD_ID = B.ROAD_ID AND B.ATRD_ID = C.ATRD_ID AND B.ROAD_ID = D.ROAD_ID AND TO_DATE(A.STAT_DT, 'YYYYMMDDHH24MISS') BETWEEN TO_DATE(?, 'YYYYMMDDHH24MISS') AND TO_DATE(?, 'YYYYMMDDHH24MISS') GROUP BY SUBSTR(A.STAT_DT, 7, 2) , A.ROAD_ID, D.STRT_NM || ' > ' || D.END_NM, B.ATRD_ID, B.ORD ORDER BY STAT_DT, B.ATRD_ID, B.ORD;
- ### Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ; JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.; nested exception is java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.] with root cause
- java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source)
- at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbStream.readMsg(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbCommType4.prepareExecute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeCompleteSQL(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeInternal(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.execute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatement.execute(Unknown Source)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
- at com.sun.proxy.$Proxy88.selectList(Unknown Source)
- at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
- at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
- at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
- at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
- at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
- at com.sun.proxy.$Proxy89.findAllTrafficAmountStatistics(Unknown Source)
- at com.its.web.service.statistics.StatisticsService.findAllTrafficAmountStatistics(StatisticsService.java:40)
- at com.its.web.controller.statistics.StatisticsController.findAllTrafficAmountStatistics(StatisticsController.java:33)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 16:39:46.265] [ http-nio-8996-exec-1] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 4660
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
- ### Error querying database. Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ### The error may exist in file [C:\00.PROJECT\24.01.PHITS-WEB\its-web-server\target\classes\mybatis\mapper\statistics\StatisticsMapper.xml]
- ### The error may involve com.its.web.mapper.statistics.StatisticsMapper.findAllTrafficAmountStatistics-Inline
- ### The error occurred while setting parameters
- ### SQL: SELECT A.ROAD_ID AS ROAD_ID, D.STRT_NM || ' > ' || D.END_NM AS SECT_NM, SUBSTR(A.STAT_DT, 7, 2) AS STAT_DT, SUM(A.TFVL) AS TFVL_TOT FROM TB_ROAD_DD_STAT A, TB_ATRD_ROAD_RLTN B, TB_ATRD C, TB_ROAD D WHERE A.ROAD_ID = B.ROAD_ID AND B.ATRD_ID = C.ATRD_ID AND B.ROAD_ID = D.ROAD_ID AND TO_DATE(A.STAT_DT, 'YYYYMMDDHH24MISS') BETWEEN TO_DATE(?, 'YYYYMMDDHH24MISS') AND TO_DATE(?, 'YYYYMMDDHH24MISS') GROUP BY SUBSTR(A.STAT_DT, 7, 2) , A.ROAD_ID, D.STRT_NM || ' > ' || D.END_NM, B.ATRD_ID, B.ORD ORDER BY STAT_DT, B.ATRD_ID, B.ORD;
- ### Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ; JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.; nested exception is java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.] with root cause
- java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source)
- at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbStream.readMsg(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbCommType4.prepareExecute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeCompleteSQL(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeInternal(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.execute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatement.execute(Unknown Source)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
- at com.sun.proxy.$Proxy88.selectList(Unknown Source)
- at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
- at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
- at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
- at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
- at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
- at com.sun.proxy.$Proxy89.findAllTrafficAmountStatistics(Unknown Source)
- at com.its.web.service.statistics.StatisticsService.findAllTrafficAmountStatistics(StatisticsService.java:42)
- at com.its.web.controller.statistics.StatisticsController.findAllTrafficAmountStatistics(StatisticsController.java:33)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 16:42:40.314] [ http-nio-8996-exec-1] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 9712
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException:
- ### Error querying database. Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ### The error may exist in file [C:\00.PROJECT\24.01.PHITS-WEB\its-web-server\target\classes\mybatis\mapper\statistics\StatisticsMapper.xml]
- ### The error may involve com.its.web.mapper.statistics.StatisticsMapper.findAllTrafficAmountStatistics-Inline
- ### The error occurred while setting parameters
- ### SQL: SELECT A.ROAD_ID AS ROAD_ID, D.STRT_NM || ' > ' || D.END_NM AS SECT_NM, SUBSTR(A.STAT_DT, 7, 2) AS STAT_DT, SUM(A.TFVL) AS TFVL_TOT FROM TB_ROAD_DD_STAT A, TB_ATRD_ROAD_RLTN B, TB_ATRD C, TB_ROAD D WHERE A.ROAD_ID = B.ROAD_ID AND B.ATRD_ID = C.ATRD_ID AND B.ROAD_ID = D.ROAD_ID AND TO_DATE(A.STAT_DT, 'YYYYMMDDHH24MISS') BETWEEN TO_DATE(?, 'YYYYMMDDHH24MISS') AND TO_DATE(?, 'YYYYMMDDHH24MISS') GROUP BY SUBSTR(A.STAT_DT, 7, 2) , A.ROAD_ID, D.STRT_NM || ' > ' || D.END_NM, B.ATRD_ID, B.ORD ORDER BY STAT_DT, B.ATRD_ID, B.ORD;
- ### Cause: java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- ; JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.; nested exception is java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.] with root cause
- java.sql.SQLException: JDBC-5114:Invalid day value '0': must be an integer between 1 and 31.
- at com.tmax.tibero.jdbc.err.TbError.makeSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.err.TbError.newSQLException(Unknown Source)
- at com.tmax.tibero.jdbc.msg.common.TbMsgError.readErrorStackInfo(Unknown Source)
- at com.tmax.tibero.jdbc.msg.TbMsgEreply.deserialize(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbStream.readMsg(Unknown Source)
- at com.tmax.tibero.jdbc.comm.TbCommType4.prepareExecute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeCompleteSQL(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.executeInternal(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatementImpl.execute(Unknown Source)
- at com.tmax.tibero.jdbc.driver.TbPreparedStatement.execute(Unknown Source)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
- at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
- at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
- at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
- at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
- at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
- at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
- at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
- at com.sun.proxy.$Proxy88.selectList(Unknown Source)
- at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
- at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
- at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
- at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
- at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
- at com.sun.proxy.$Proxy89.findAllTrafficAmountStatistics(Unknown Source)
- at com.its.web.service.statistics.StatisticsService.findAllTrafficAmountStatistics(StatisticsService.java:41)
- at com.its.web.controller.statistics.StatisticsController.findAllTrafficAmountStatistics(StatisticsController.java:33)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
- at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
- at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
- at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
- at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 17:42:20.461] [ http-nio-8996-exec-4] [ERROR] org.thymeleaf.TemplateEngine.process 4292
- [THYMELEAF][http-nio-8996-exec-4] Exception processing template "main/main": Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.java:869)
- at org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:607)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1098)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1072)
- at org.thymeleaf.spring5.view.ThymeleafView.renderFragment(ThymeleafView.java:366)
- at org.thymeleaf.spring5.view.ThymeleafView.render(ThymeleafView.java:190)
- at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1400)
- at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1145)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 17:42:20.464] [ http-nio-8996-exec-4] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 4292
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers] with root cause
- org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.java:869)
- at org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:607)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1098)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1072)
- at org.thymeleaf.spring5.view.ThymeleafView.renderFragment(ThymeleafView.java:366)
- at org.thymeleaf.spring5.view.ThymeleafView.render(ThymeleafView.java:190)
- at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1400)
- at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1145)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 17:47:49.542] [ http-nio-8996-exec-1] [ERROR] org.thymeleaf.TemplateEngine.process 21696
- [THYMELEAF][http-nio-8996-exec-1] Exception processing template "main/main": Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.java:869)
- at org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:607)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1098)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1072)
- at org.thymeleaf.spring5.view.ThymeleafView.renderFragment(ThymeleafView.java:366)
- at org.thymeleaf.spring5.view.ThymeleafView.render(ThymeleafView.java:190)
- at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1400)
- at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1145)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
- [2024-01-15 17:47:49.550] [ http-nio-8996-exec-1] [ERROR] o.a.c.c.C.[.[.[.[dispatcherServlet].log 21696
- Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers] with root cause
- org.thymeleaf.exceptions.TemplateInputException: Error resolving template [main/main], template might not exist or might not be accessible by any of the configured Template Resolvers
- at org.thymeleaf.engine.TemplateManager.resolveTemplate(TemplateManager.java:869)
- at org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:607)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1098)
- at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1072)
- at org.thymeleaf.spring5.view.ThymeleafView.renderFragment(ThymeleafView.java:366)
- at org.thymeleaf.spring5.view.ThymeleafView.render(ThymeleafView.java:190)
- at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1400)
- at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1145)
- at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1084)
- at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
- at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
- at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
- at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
- at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
- at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
- at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
- at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
- at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
- at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Thread.java:748)
|