Wlsepf
30
2021-10-07 16:45:47 작성 2021-10-07 16:47:10 수정됨
1
86

Invalid bound statement (not found): ~


지금 DB 연동해서 selectList을 만들고 있는데 다음과 같은 오류 때문에 고민이 큽니다.

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): egovframework.hans.kips.mapper.KipssafetyProcessingMapper.processingSelect

at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227)

at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:49)

at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)

at com.sun.proxy.$Proxy49.processingSelect(Unknown Source)

at egovframework.hans.kips.service.impl.KipssafetyProcessingServiceimpl.processingSelect(KipssafetyProcessingServiceimpl.java:24)

at egovframework.hans.kips.web.KipssafetyProcessingController.ProcessingList(KipssafetyProcessingController.java:23)

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:133)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at egovframework.com.cmm.filter.SessionTimeoutCookieFilter.doFilter(SessionTimeoutCookieFilter.java:80)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at egovframework.com.cmm.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:36)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:122)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

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:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:201)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1629)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Processing.xml

	<select id="processingSelect" parameterType="egovframework.hans.kips.model.KipssafetyProcessingVO" resultType="egovframework.hans.kips.model.KipssafetyProcessingVO" >
		SELECT 
			seq_no, turn, folder, recNum, recDate,
			recForm, comNum, company, representative, origin, businesstype, area,
			address, companycontact, companyRegNum, sortation, applicableto,
			productfamily, item, detailItem, detailItem_temleader,
			researchManager, investigator1, surveyDate, reportDate, inputDate,
			surveyContent, violationClause, actionOpinion, fieldSurvey,
			policeStation, judReqDate, judReqDocNum, judReqCon, munName,
			munReqDate, munReqDocNum, munReqCon, relOrgName, relOrgReqDate,
			relOrgReqDocNum, relOrgReqCon, policeReply, policeReplyDate,
			policeReplyDocNum, policeReplyResult, munNameReply, munReplyDate,
			munReplyDocNum, munReplyResult, relOrgNameReply, relOrgReplyDate,
			regOrgReplyDocNum, regOrgReplyResult, prosecutorReply,
			prosecutorReplyDate, disposalDate, proReplyDocNum, proReplyResult,
			fine, complaintComName, complaint, address1, complaintcontact1,
			complaintcontact2, complaintcontact3, etc, complaintTitle, itemGroup,
			zipcode, phone, transferDate, targetAddress1, targetAddress2,
			targetAddress3, targetZipcode, complaintZipcode, complaintAddress1,
			complaintAddress2, complaintAddress3, classification
		FROM 
		_surveyManage;
	</select>

Mapper

@Mapper("kipssafetyProcessingMapper")
public interface KipssafetyProcessingMapper  {
	public List<KipssafetyProcessingVO> processingSelect(KipssafetyProcessingVO boardVO) throws Exception;
}

service

@Service("kipssafetyProcessingService")
public interface KipssafetyProcessingService {
	public Map<String, Object> processingSelect(KipssafetyProcessingVO boardVO) throws Exception;
}

impl

	@Resource(name = "kipssafetyProcessingMapper")
	private KipssafetyProcessingMapper kipssafetyProcessingMapper;
	
	@Override
	public Map<String, Object> processingSelect(KipssafetyProcessingVO boardVO) throws Exception {
		List<KipssafetyProcessingVO> list = kipssafetyProcessingMapper.processingSelect(boardVO);
		
		Map<String, Object> map = new HashMap<String, Object>();
		
		map.put("resultList", list);
		return map;
	}

controller


	@Resource(name = "kipssafetyProcessingService")
	private KipssafetyProcessingService Service;
	
	@RequestMapping(value = "/ProcessingList.do")
	public String ProcessingList(KipssafetyProcessingVO boardVO, ModelMap model) {
		try {
			Map<String, Object> map = Service.processingSelect(boardVO);
			System.out.println("====================> " + boardVO.getDisposalDate());
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			return "kips/Processing/ProcessingList";
		}
		return "kips/Processing/ProcessingList";
	}


0
  • 답변 1

  • Wlsepf
    30
    2021-10-07 16:53:16

    선배님들 해결했습니다. 생각보다 간단 했군요

    인터넷을 계속 봤는데 Spring 기준이라 mapper-locations을 찾지 못했습니다.

    하지만 context-mapper에 

    <property name="mapperLocations">

    <list>

    <value>classpath:/egovframework/mapper/com/hans/*.xml</value>

    </list>

    </property>


    있더라고여 그래서 경로를 변경해줬습니다!! 감사합니다.

  • 로그인을 하시면 답변을 등록할 수 있습니다.