[Spring 4] Mapped Statements collection does not contain value for . . .

이틀 째 mvc 연결 안 됨. 미쳐버리갔음

 

 

5월 30, 2019 11:09:44 오전 org.apache.tomcat.util.digester.SetPropertiesRule begin
경고: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Usher' did not find a matching property.
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Server version:        Apache Tomcat/8.0.46
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Server built:          Aug 10 2017 10:10:31 UTC
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Server number:         8.0.46.0
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: OS Name:               Windows 10
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: OS Version:            10.0
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Architecture:          amd64
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Java Home:             C:\Program Files\Java\jre1.8.0_171
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: JVM Version:           1.8.0_171-b11
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: JVM Vendor:            Oracle Corporation
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: CATALINA_BASE:         F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: CATALINA_HOME:         C:\Program Files\apache-tomcat-8.0.46
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:53885
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -Dcatalina.base=F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -Dcatalina.home=C:\Program Files\apache-tomcat-8.0.46
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -Dwtp.deploy=F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -Djava.endorsed.dirs=C:\Program Files\apache-tomcat-8.0.46\endorsed
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.VersionLoggerListener log
정보: Command line argument: -Dfile.encoding=UTF-8
5월 30, 2019 11:09:44 오전 org.apache.catalina.core.AprLifecycleListener lifecycleEvent
정보: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.8.0_171\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jre1.8.0_171/bin/server;C:/Program Files/Java/jre1.8.0_171/bin;C:/Program Files/Java/jre1.8.0_171/lib/amd64;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;D:\app\jian\product\12.2.0\dbhome_1\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Tibero\tibero5_client\client\bin;C:\Tibero\tibero5_client\client\lib;C:\Tibero\tibero5_client\bin;C:\Program Files (x86)\MySQL\MySQL Server 5.7\bin;C:\Program Files\Java\jdk1.8.0_144\bin;C:\Program Files\Git\cmd;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\nodejs\;C:\Program Files\dotnet\;C:\Users\U3CNC\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Bandizip\;C:\Users\U3CNC\AppData\Local\Programs\Fiddler;C:\Users\U3CNC\AppData\Local\Microsoft\WindowsApps;C:\Users\U3CNC\AppData\Roaming\npm;C:\Users\U3CNC\AppData\Local\atom\bin;C:\Users\U3CNC\AppData\Local\GitHubDesktop\bin;C:\Developer\eGovFrameDev-3.6.0-64bit\eclipse;;.
5월 30, 2019 11:09:44 오전 org.apache.coyote.AbstractProtocol init
정보: Initializing ProtocolHandler ["http-nio-8080"]
5월 30, 2019 11:09:44 오전 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
정보: Using a shared selector for servlet write/read
5월 30, 2019 11:09:44 오전 org.apache.coyote.AbstractProtocol init
정보: Initializing ProtocolHandler ["ajp-nio-8009"]
5월 30, 2019 11:09:44 오전 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
정보: Using a shared selector for servlet write/read
5월 30, 2019 11:09:44 오전 org.apache.catalina.startup.Catalina load
정보: Initialization processed in 878 ms
5월 30, 2019 11:09:44 오전 org.apache.catalina.core.StandardService startInternal
정보: Starting service Catalina
5월 30, 2019 11:09:44 오전 org.apache.catalina.core.StandardEngine startInternal
정보: Starting Servlet Engine: Apache Tomcat/8.0.46
5월 30, 2019 11:09:45 오전 org.apache.jasper.servlet.TldScanner scanJars
정보: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
5월 30, 2019 11:09:47 오전 org.apache.jasper.servlet.TldScanner scanJars
정보: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
5월 30, 2019 11:09:47 오전 org.apache.catalina.core.ApplicationContext log
정보: No Spring WebApplicationInitializer types detected on classpath
5월 30, 2019 11:09:47 오전 org.apache.catalina.core.ApplicationContext log
정보: Initializing Spring root WebApplicationContext
INFO : org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization started
INFO : org.springframework.web.context.support.XmlWebApplicationContext - Refreshing Root WebApplicationContext: startup date [Thu May 30 11:09:48 KST 2019]; root of context hierarchy
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Usher\WEB-INF\classes\config\spring\context-common.xml]
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Usher\WEB-INF\classes\config\spring\context-datasource.xml]
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from file [F:\workspace\teamUsher\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\Usher\WEB-INF\classes\config\spring\context-mapper.xml]
INFO : org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
INFO : org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 1406 ms
5월 30, 2019 11:09:49 오전 org.apache.catalina.core.ApplicationContext log
정보: Initializing Spring FrameworkServlet 'action'
INFO : org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'action': initialization started
INFO : org.springframework.web.context.support.XmlWebApplicationContext - Refreshing WebApplicationContext for namespace 'action-servlet': startup date [Thu May 30 11:09:49 KST 2019]; parent: Root WebApplicationContext
INFO : org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from ServletContext resource [/WEB-INF/config/action-servlet.xml]
INFO : org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor - JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/main/openDrawing.do]}" onto public java.lang.String usher.common.controller.MainController.openSampleList(java.util.Map<java.lang.String, java.lang.Object>) throws java.lang.Exception
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Mapped "{[/usher/getStickerList.doJson]}" onto public java.lang.String usher.common.controller.MainController.getStickerList(java.util.Map<java.lang.String, java.lang.Object>,org.springframework.ui.ModelMap) throws java.lang.Exception
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: WebApplicationContext for namespace 'action-servlet': startup date [Thu May 30 11:09:49 KST 2019]; parent: Root WebApplicationContext
INFO : org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter - Looking for @ControllerAdvice: WebApplicationContext for namespace 'action-servlet': startup date [Thu May 30 11:09:49 KST 2019]; parent: Root WebApplicationContext
INFO : org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapped URL path [/resource/] onto handler 'org.springframework.web.servlet.resource.ResourceHttpRequestHandler#0'
INFO : org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'action': initialization completed in 1343 ms
5월 30, 2019 11:09:50 오전 org.apache.coyote.AbstractProtocol start
정보: Starting ProtocolHandler ["http-nio-8080"]
5월 30, 2019 11:09:50 오전 org.apache.coyote.AbstractProtocol start
정보: Starting ProtocolHandler ["ajp-nio-8009"]
5월 30, 2019 11:09:50 오전 org.apache.catalina.startup.Catalina start
정보: Server startup in 6265 ms
5월 30, 2019 11:11:27 오전 org.apache.catalina.core.StandardWrapperValve invoke
심각: Servlet.service() for servlet [action] in context with path [/sns] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): usher.common.service.MainService.getStickerList] with root cause
java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for usher.common.service.MainService.getStickerList
	at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:775)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:615)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:608)
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:176)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:38)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:49)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:42)
	at com.sun.proxy.$Proxy23.getStickerList(Unknown Source)
	at usher.common.controller.MainController.getStickerList(MainController.java:42)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)