(sqlSession값이 매칭이 안됩니다.)Spring+Mybatis+MariaDB 연동 질문 드립니다.

Question

책을 보고 변형해서 진행하다가 오류가 나서 어디가 문제인지건지 찾지를 못하겠습니다; 오류 메세지 : INFO : com.lime_it.iotrashweb.HomeController - regist page SqlSession ===> null java.lang.NullPointerException at com.lime_it.dao.MemberDAOImpl.getMember(MemberDAOImpl.java:33) at com.lime_it.service.NewMemberServiceImpl.newRegist(NewMemberServiceImpl.java:18) at com.lime_it.iotrashweb.HomeController.webRegist(HomeController.java:44) 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: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: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:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) 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) 위에 보시다 시피 sqlSession에 null이 들어가는 문제가 생기는 것 같습니다.현재 DAOImpl 클래스에서 Inject를 통한 SqlSession을 구현하고 있습니다. MemberDAOImpl.javapackage com.lime_it.dao; ...//import부분 @Repository public class MemberDAOImpl implements MemberDAO { @Autowired private SqlSession sqlSession; private static final String namespace = "com.lime_it.mapper.memberMapper"; @Override public MemberVO getMember(String user_ID) { try{ System.out.println("SqlSession ===> " + sqlSession); return sqlSession.selectOne(namespace+".getLedID",user_ID); } catch(Exception e) { e.printStackTrace(); }finally{ sqlSession.close(); } return sqlSession.selectOne(namespace+".getLedID",user_ID); } ...//다른 메소드 생략 root-context.xml파일입니다.

mybatis-config.xml memberMapper.xml insert into tbl_user (user_ID, user_Password, user_Recognize, regdate) values (#{user_ID}, #{user_Password}, #{user_Recognize}, #{regdate}) 경로는 다음과 같습니다.. 막힌지 2일째인데 진전이 없어서 어떻게 진행해야할지 막막합니다.이럴땐 어떻게 해야할지도 알려주시면 감사하겠습니다..^^;

José Antonio Reyes · Answer

MemberDAOImpl.java:33여기부터 찾으시면 되겠네영

Lime맛 · Answer

33번째 부분입니다.sqlSession.close(); JUnit로 연동이 되는지 테스트한 것은 잘 되는데.. 이것 뿐만이 아니라 다른 블로그에 있는 예제를 가져와서 구현을 해도 동일한 에러가 납니다; Mybatis연결 테스트.. -> 이건 잘 됩니다;package com.lime_it.iotrashweb; import javax.inject.Inject; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.test.context.ContextConfiguration; &#64;RunWith(SpringJUnit4ClassRunner.class) &#64;ContextConfiguration(locations &#61;{&#34;file:src/main/webapp/WEB-INF/spring/**/root-context.xml&#34;}) public class MyBatisTest { &#64;Inject private SqlSessionFactory sqlFactory; &#64;Test public void testFactory(){ System.out.println(sqlFactory); } &#64;Test public void testSession()throws Exception{ try(SqlSession session &#61; sqlFactory.openSession()){ System.out.println(&#34;SqlSession &#61;&#61;&#61;> &#34; &#43; session); System.out.println(session); }catch(Exception e){ e.printStackTrace(); } } }

(sqlSession값이 매칭이 안됩니다.)Spring+Mybatis+MariaDB 연동 질문 드립니다.

2개의 답변

Q&A 목록