게시판 만드는 중인데 등록이 안되요 ..

Question

게시판 만드는 중에서 버튼을 눌러서 글을 쓰면 oracle에 등록은 되는데,에러가 나네요.. 뭐가 문제일까요.. controllor에서는 이렇게..@RequestMapping(value="insertQuestion", method=RequestMethod.POST) public ModelAndView insertQuestion(QuestionVO questionVO) { ModelAndView model = new ModelAndView(); int insert = 0; insert = QnADao.insertQuestion(questionVO); model.addObject("questionVO",questionVO); model.setViewName("QnA/QnA"); return model; } view 페이지 에서 form은 이렇게..

mybatis mapper에서는 이렇게 insert into QUESTION (NUM, USERS_NUM, TAG_NAME, TEXT, TITLE, INDATE) values (question_seq.nextval, 2, #{tag_name}, #{text}, #{title}, sysdate) 3일째 안되네요 12:10:53 [tomcat-http--101] DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/web_project/QnA/insertQuestion]12:10:53 [tomcat-http--101] RequestMappingHandlerMapping - Looking up handler method for path /QnA/insertQuestion12:10:53 [tomcat-http--101] RequestMappingHandlerMapping - Returning handler method [public org.springframework.web.servlet.ModelAndView com.bc.web_project.controller.QnAController.insertQuestion(com.bc.web_project.vo.QuestionVO)]12:10:53 [tomcat-http--101] DefaultCorsProcessor - Skip CORS processing, request is a same-origin one{ "num":0, "users_num":0, "tag_name":"test", "text":"test", "title":"test", "indate":"null", "user_name":"null", "user_imageadd":"null" }QnADAOImpQnADAOImpQnADAOImpQnADAOImpQnADAOImpQnADAOImpQnADAOImpQnADAOImpQnADAOImp12:10:53 [tomcat-http--101] connection - 2. Connection opened12:10:53 [tomcat-http--101] audit - 2. Connection.new Connection returned 12:10:53 [tomcat-http--101] audit - 2. Connection.getAutoCommit() returned true12:10:53 [tomcat-http--101] audit - 2. PreparedStatement.new PreparedStatement returned 12:10:53 [tomcat-http--101] audit - 2. Connection.prepareStatement(insert into QUESTION (NUM, USERS_NUM, TAG_NAME, TEXT, TITLE, INDATE) values (question_seq.nextval, 2, ?, ?, ?, sysdate)) returned net.sf.log4jdbc.PreparedStatementSpy@274443f512:10:53 [tomcat-http--101] audit - 2. PreparedStatement.setString(1, "test") returned 12:10:53 [tomcat-http--101] audit - 2. PreparedStatement.setString(2, "test") returned 12:10:53 [tomcat-http--101] audit - 2. PreparedStatement.setString(3, "test") returned 12:10:53 [tomcat-http--101] sqlonly - SQL ::insert into QUESTION (NUM, USERS_NUM, TAG_NAME, TEXT, TITLE, INDATE) values (question_seq.nextval, 2, 'test', 'test', 'test', sysdate)12:10:53 [tomcat-http--101] sqltiming - insert into QUESTION (NUM, USERS_NUM, TAG_NAME, TEXT, TITLE, INDATE) values (question_seq.nextval, 2, 'test', 'test', 'test', sysdate) {executed in 3 msec} ============================================================================= HTTP Status 500 – Internal Server ErrorType Exception ReportMessage Request processing failed; nested exception is java.lang.NullPointerExceptionDescription The server encountered an unexpected condition that prevented it from fulfilling the request.Exceptionorg.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.NullPointerException org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) javax.servlet.http.HttpServlet.service(HttpServlet.java:661) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Causejava.lang.NullPointerException com.bc.web_project.dao.QnADAOImp.insertQuestion(QnADAOImp.java:46) com.bc.web_project.controller.QnAController.insertQuestion(QnAController.java:76) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221) org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137) org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806) org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729) org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) javax.servlet.http.HttpServlet.service(HttpServlet.java:661) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Note The full stack trace of the root cause is available in the server logs.Pivotal tc Runtime 3.2.8.RELEASE/8.5.23.A.RELEASE

오후 · Accepted Answer

쓴지오래돼었지만 insert 문아닌가요?? sqlSession.insert 였던가일겁니다. selectOne 은 조회시 select 구문에 1개의 객체(row)를 응답받을때 사용됩니다.

basscraft · Answer

QnADAOImp.java 46번째 줄에 Null 이라네요.

gun6750 · Answer

DAO 에서는 이렇게 했는데.. 어떤게 null이라는건지 모르겠어요 db에는 값이 입력되는대..&#64;Override public int insertQuestion(QuestionVO questionVO) { return sqlSession.selectOne(qnaMapper&#43;&#34;.insertQuestion&#34;, questionVO); }

gun6750 · Answer

아~ sqlSession.insert 이렇게 하는게 맞는거 같은데 별다른 차이가 없네요.. 컨트롤러 부분에서 model.setViewName(&#34;QnA/QnA&#34;); <--이게 게시판의 list페이지 인데 list페이지에 아무것도 안떠요.. 처음 서버실행하고 나서는 list페이지가 잘 보이는데 insert 하고 나서는 다 사라져 있다는...

gun6750 · Answer

14:47:04 [tomcat-http--13] DispatcherServlet - Rendering view [org.springframework.web.servlet.view.tiles3.TilesView: name 'QnA/QnA'; URL [QnA/QnA]] in DispatcherServlet with name 'appServlet'14:47:04 [tomcat-http--13] TilesView - Added model object 'questionVO' of type [com.bc.web_project.vo.QuestionVO] to request in view with name 'QnA/QnA'14:47:04 [tomcat-http--13] TilesView - Added model object 'org.springframework.validation.BindingResult.questionVO' of type [org.springframework.validation.BeanPropertyBindingResult] to request in view with name 'QnA/QnA'14:47:04 [tomcat-http--13] TilesView - Added model object 'string' of type [java.lang.String] to request in view with name 'QnA/QnA' 이부분이 뭔가 핵심인것 같은데..

gun6750 · Answer

List<QuestionVO> questionList &#61; QnADao.QnAselect(); model.addObject(&#34;questionList&#34;, questionList); 리스트를 다시 안불러와서 그런것 같네요..

게시판 만드는 중인데 등록이 안되요 ..

6개의 답변

Q&A 목록