Invalid bound statement (not found): gov.hkpf.cis2.ws.mapper.charge.CrtCaseMapper.getArrestPersons

2014-06-06 17:23:19:082 ERROR dbqueryexceptionhandler:80-
Org.apache.ibatis.binding.BindingException:Invalid bound statement (not found): Gov.hkpf.cis2.ws.mapper.charge.CrtCaseMapper.getArrestPersons
At Org.apache.ibatis.binding.mappermethod$sqlcommand.<init> (mappermethod.java:178)
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. $Proxy 49.getRefCrt (Unknown Source)
At Gov.hkpf.cis2.ws.policecase.service.GetRefModelListAction.getActiveRefList (getrefmodellistaction.java:87)
At Gov.hkpf.cis2.ws.policecase.service.GetRefModelListAction.getReferences (getrefmodellistaction.java:48)
At Gov.hkpf.cis2.ws.common.util.GenericReferenceQueryHandler.runImpl (genericreferencequeryhandler.java:33)
At Gov.hkpf.cis2.ws.common.util.GenericReferenceQueryHandler.runImpl (genericreferencequeryhandler.java:1)
At Gov.hkpf.cis2.ws.common.util.DbQueryExceptionHandler.run (dbqueryexceptionhandler.java:70)
At Gov.hkpf.cis2.ws.common.service.ReferenceServiceImpl.getReferenceModels (referenceserviceimpl.java:147)
At Gov.hkpf.cis2.ws.common.entrypoint.rest.ReferenceWebService.getReferenceModels (referencewebservice.java:53)
At Sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
At Sun.reflect.NativeMethodAccessorImpl.invoke (nativemethodaccessorimpl.java:57)
At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)
At Java.lang.reflect.Method.invoke (method.java:601)
At Org.springframework.web.method.support.InvocableHandlerMethod.invoke (invocablehandlermethod.java:219)
At Org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest (Invocablehandlermethod.java : 132)
At Org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle ( SERVLETINVOCABLEHANDLERMETHOD.JAVA:104)
At Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod ( requestmappinghandleradapter.java:745)
At Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal ( requestmappinghandleradapter.java:686)
At Org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle ( ABSTRACTHANDLERMETHODADAPTER.JAVA:80)
At Org.springframework.web.servlet.DispatcherServlet.doDispatch (dispatcherservlet.java:925)
At Org.springframework.web.servlet.DispatcherServlet.doService (dispatcherservlet.java:856)
At Org.springframework.web.servlet.FrameworkServlet.processRequest (frameworkservlet.java:936)
At Org.springframework.web.servlet.FrameworkServlet.doPost (frameworkservlet.java:838)
At Javax.servlet.http.HttpServlet.service (httpservlet.java:647)
At Org.springframework.web.servlet.FrameworkServlet.service (frameworkservlet.java:812)
At Javax.servlet.http.HttpServlet.service (httpservlet.java:728)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:305)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52)
At Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:243)
At Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:210)
At Org.apache.catalina.core.StandardWrapperValve.invoke (standardwrappervalve.java:222)
At Org.apache.catalina.core.StandardContextValve.invoke (standardcontextvalve.java:123)
At Org.apache.catalina.authenticator.AuthenticatorBase.invoke (authenticatorbase.java:502)
At Org.apache.catalina.core.StandardHostValve.invoke (standardhostvalve.java:171)
At Org.apache.catalina.valves.ErrorReportValve.invoke (errorreportvalve.java:100)
At Org.apache.catalina.valves.AccessLogValve.invoke (accesslogvalve.java:953)
At Org.apache.catalina.core.StandardEngineValve.invoke (standardenginevalve.java:118)
At Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.java:409)
At Org.apache.coyote.http11.AbstractHttp11Processor.process (abstracthttp11processor.java:1044)
At Org.apache.coyote.abstractprotocol$abstractconnectionhandler.process (abstractprotocol.java:607)
At Org.apache.tomcat.util.net.jioendpoint$socketprocessor.run (jioendpoint.java:313)
At Java.util.concurrent.ThreadPoolExecutor.runWorker (threadpoolexecutor.java:1145)
At Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:615)
At Java.lang.Thread.run (thread.java:722)
caused by:java.lang.IllegalArgumentException:Mapped statements collection does not contain value for GOV.HKPF.CIS2.WS.M Apper.charge.CrtCaseMapper.getArrestPersons
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)
... More

The solution was to re-write a Persondtomapper.java under mapper.

Put the method public list<persondto> getarrestpersons () throws Mybatissystemexception, DataAccessException; add it in

Write a good persondtomapper.xml file and write the corresponding SQL

Oneself feel is an XML file in Resulttype can only correspond to a DTO, write in other files will be error, waiting for confirmation