Spring 프로젝트에서 Mybatis SQL에 값이 안들어갑니다.

Question

인텔리제이로 스프링 프로젝트를 진행중입니다.DAO입니다.// Board Insert public int boardInsert(String rb_uid, String rb_sub, String r_name, String r_address, String rb_contents, int rb_rating) { System.out.println("===== Board Insert DAO ====="); HashMap map = new HashMap(); map.put("rb_uid", rb_uid); map.put("rb_sub", rb_sub); map.put("r_name", r_name); map.put("r_address", r_address); map.put("rb_contents", rb_contents); map.put("rb_rating", rb_rating); return sqlSession.insert("ResBoardMapper.boardInsert", map); }XML입니다. INSERT IGNORE INTO m_restaurant(r_name, r_address) VALUES(#{r_name }, #{r_address }); INSERT INTO m_resboard(rb_rid, rb_uid, rb_sub, rb_rating, rb_contents) VALUES((SELECT r_id FROM m_restaurant WHERE r_name = #{r_name }), #{rb_uid }, #{rb_sub }, #{rb_ratring }, #{rb_contents }); 쿼리문 실행 전까지 콘솔로 찍어보면 분명 값은 제대로 넘어갔는데, XML에서만 값을 인식을 못합니다.. 도와주십쇼....아래는 오류 내용입니다.HTTP 상태 500 – 내부 서버 오류타입 예외 보고메시지 Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:설명 서버가, 해당 요청을 충족시키지 못하게 하는 예기치 않은 조건을 맞닥뜨렸습니다.예외org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: (conn:135) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO m_resboard(rb_rid, rb_uid, rb_sub, rb_rating, rb_contents) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: INSERT IGNORE INTO m_restaurant(r_name, r_address) VALUES(?, ?); INSERT INTO m_resboard(rb_rid, rb_uid, rb_sub, rb_rating, rb_contents) VALUES((SELECT r_id FROM m_restaurant WHERE r_name = ?), ?, ?, ?, ?); ### Cause: java.sql.SQLSyntaxErrorException: (conn:135) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO m_resboard(rb_rid, rb_uid, rb_sub, rb_rating, rb_contents) ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: (conn:135) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO m_resboard(rb_rid, rb_uid, rb_sub, rb_rating, rb_contents) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) javax.servlet.http.HttpServlet.service(HttpServlet.java:681) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) javax.servlet.http.HttpServlet.service(HttpServlet.java:764) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)

팩트폭행범 · Answer

문법이 틀렸습니다insert ignore 그렇게 쓰는거 아닙니다

Spring 프로젝트에서 Mybatis SQL에 값이 안들어갑니다.

1개의 답변

Q&A 목록