스프링 마이바티스 프로시저 실행 out값 질문

Question

{ call SP_NTS_VALIDATION ( #{rceptSn, mode=IN, jdbcType=VARCHAR, javaType=java.lang.String} , #{P_RETURN_MSG, mode=OUT, jdbcType=VARCHAR, javaType=java.lang.String} , #{P_RETURN_CODE, mode=OUT, jdbcType=VARCHAR, javaType=java.lang.String} ) } 위와같은 프로시저를 호출하는데요,결과값으로 { call SP_NTS_VALIDATION ( '600000000006350' , ' ' , ' ' ) } 의형태로 리턴메시지랑 리턴코드를 가져오지못하네요흔하디 흔한 NullPointerException에러가 뜹니다(아래) ### Error updating database. Cause: java.lang.NullPointerException ### The error may involve kr.rrs.webportal.minwon.rqs.rtsRegist.mapper.RtsRegistMapperR.activateNtsCheckProcedure-Inline ### The error occurred while setting parameters ### SQL: { call SP_NTS_VALIDATION ( ? , ? , ? ) } ### Cause: java.lang.NullPointerException at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:76) ~[mybatis-spring-1.2.3.jar:1.2.3] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399) ~[mybatis-spring-1.2.3.jar:1.2.3] at com.sun.proxy.$Proxy33.insert(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:253) ~[mybatis-spring-1.2.3.jar:1.2.3] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52) ~[mybatis-3.3.0.jar:3.3.0] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53) ~[mybatis-3.3.0.jar:3.3.0] at com.sun.proxy.$Proxy216.activateNtsCheckProcedure(Unknown Source) ~[?:?] at kr.rrs.webportal.minwon.rqs.rtsRegist.service.impl.RtsRegistServiceImpl.activateNtsCheckProcedure(RtsRegistServiceImpl.java:1198) ~[RtsRegistServiceImpl.class:?] at kr.rrs.webportal.minwon.rqs.rtsRegist.service.impl.RtsRegistServiceImpl$$FastClassBySpringCGLIB$$7a4ec8a8.invoke() ~[spring-core-4.1.2.RELEASE.jar:?] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:267) ~[spring-tx-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) ~[spring-aop-4.1.2.RELEASE.jar:4.1.2.RELEASE] at kr.rrs.webportal.minwon.rqs.rtsRegist.service.impl.RtsRegistServiceImpl$$EnhancerBySpringCGLIB$$6e57aad6.activateNtsCheckProcedure() ~[spring-core-4.1.2.RELEASE.jar:?] at kr.rrs.webportal.minwon.rqs.rtsRegist.web.RtsRegistController.activateNtsCheckProcedure(RtsRegistController.java:511) ~[RtsRegistController.class:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_79] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) ~[spring-web-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) ~[spring-web-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) ~[spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:781) ~[spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:721) ~[spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83) ~[spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943) [spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877) [spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966) [spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868) [spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) [servlet-api.jar:?] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842) [spring-webmvc-4.1.2.RELEASE.jar:4.1.2.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) [servlet-api.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) [catalina.jar:7.0.47] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.47] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) [tomcat7-websocket.jar:7.0.47] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.47] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.47] at egovframework.rte.ptl.mvc.filter.HTMLTagFilter.doFilter(HTMLTagFilter.java:52) [egovframework.rte.ptl.mvc-3.6.0.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.47] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.47] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) [spring-web-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.1.2.RELEASE.jar:4.1.2.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) [catalina.jar:7.0.47] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) [catalina.jar:7.0.47] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) [catalina.jar:7.0.47] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) [catalina.jar:7.0.47] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) [catalina.jar:7.0.47] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) [catalina.jar:7.0.47] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) [catalina.jar:7.0.47] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) [catalina.jar:7.0.47] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) [catalina.jar:7.0.47] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) [catalina.jar:7.0.47] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) [tomcat-coyote.jar:7.0.47] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603) [tomcat-coyote.jar:7.0.47] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) [tomcat-coyote.jar:7.0.47] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_79] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_79] at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79] 실제로 파라미터 타입도 확인했구요,같은환경에서 다른 프로시져는 같은 방법으로 실행되고있습니다.또한 SQL환경에서 직접 테스트를 하면 실행이 잘 되구있어요. 왜이런지좀 알려주세요...

코딩하는그리즈만 · Accepted Answer

call 실행 후 보내신 map에 P_RETRUN_MSGP_RETURN_CODE에 값이 담겨있지 않나요? String rs = (String) map.get("TEST_ID"); 이렇게 하면 rs 에 결과(?) 값을 담아옵니다. 저는 이렇게 사용하고있습니다. 도움이 되셨으면 좋겠네요.

Coon · Answer

코딩하는그리즈만 말씀해주신 방법대로 했는데 안되네요~에러가 나는 포인트는 프로시저의 실행 자체에서 되는 것이라,문자열 형태로 받아 옮겨담기도 전입니다... 도무지 모르겠네요...

코딩하는그리즈만 · Answer

Coon맵에서 보내실때P_RETRUN_MSGP_RETURN_CODE두개는 NULL로 보내시나요?

Coon · Answer

이 문제는 스스로 해결했습니다... { call SP_NTS_VALIDATION ( #{rceptSn, mode&#61;IN, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} , #{P_RETURN_MSG, mode&#61;OUT, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} , #{P_RETURN_CODE, mode&#61;OUT, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} ) }다만 해당 부분에서 {}를 제거하니까 되었는데요... 도통 모르겠네요. 일단 해결입니다. call SP_NTS_VALIDATION ( #{rceptSn, mode&#61;IN, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} , #{P_RETURN_MSG, mode&#61;OUT, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} , #{P_RETURN_CODE, mode&#61;OUT, jdbcType&#61;VARCHAR, javaType&#61;java.lang.String} )

스프링 마이바티스 프로시저 실행 out값 질문

4개의 답변

#output 목록