mybatis insert도중 에러가 발생하였습니다

Question

안녕하세요. 홀로 공부중에 큰난간에 부딪혀 눈팅만 하던중 처음으로 글남겨봅니다.구글에 검색해본바로는 메이븐 업데이트, 타입에러 라는 경우가 많다고 하여 메이븐 업데이트도 진행을 해보고 vo,sql필드명 타입을 전부 확인해봤는데도 에러가 납니다...DAO에 작성한내용입니다 jsp에서 ajax를 통해 받아오는값이 있으나 데이터의 문제인가 싶어 직접 set시킨다음 추가중에도 에러가 발생하였습니다. @ResponseBody @RequestMapping(value="/orderAdd",method=RequestMethod.POST) public String orderAddPost(OrderVO vo, HttpSession session) { vo.setUidx(1); vo.setSelbidx("test"); vo.setBuylist("test"); vo.setPrice(100); vo.setPayment("test"); vo.setPaymentinfo("test"); vo.setOrderinfo("test"); vo.setOrderst("test"); System.out.println(vo); orderService.addOrder(vo); return ""; }맵퍼 내용 입니다. insert into order values( default, #{vo.uidx}, #{vo.selbidx}, #{vo.buylist}, #{vo.price}, #{vo.payment}, #{vo.paymentinfo}, #{vo.orderinfo}, default, #{vo.orderst}, default, default ); sql 에러내용OrderVO(idx=0, uidx=1, selbidx=test, buylist=test, price=100, payment=test, paymentinfo=test, orderinfo=test, st=null, orderst=test, orderDate=null, deliveryDate=null) 1월 19, 2022 12:04:36 오후 org.apache.catalina.core.StandardWrapperValve invoke SEVERE: 경로 [/cjs2108_PHS]의 컨텍스트 내의 서블릿 [appServlet]을(를) 위한 Servlet.service() 호출이, 근본 원인(root cause)과 함께, 예외 [Handler dispatch failed; nested exception is java.lang.NoClassDefFoundError: org/springframework/util/function/SingletonSupplier]을(를) 발생시켰습니다. java.lang.ClassNotFoundException: org.springframework.util.function.SingletonSupplier at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1407) at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1215) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:140) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.(SQLErrorCodeSQLExceptionTranslator.java:102) at org.mybatis.spring.MyBatisExceptionTranslator.lambda$new$0(MyBatisExceptionTranslator.java:55) at org.mybatis.spring.MyBatisExceptionTranslator.initExceptionTranslator(MyBatisExceptionTranslator.java:106) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy119.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.$Proxy134.addOrder(Unknown Source) at com.spring.cjs2108_PHS.service.OrderServiceImpl.addOrder(OrderServiceImpl.java:61) at com.spring.cjs2108_PHS.OrderController.orderAddPost(OrderController.java:167) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) 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: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.doPost(FrameworkServlet.java:872) at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) 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:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:832)

HSHidden · Accepted Answer

해결됐습니다. 도움주신 모든분 감사합니다. 원인은 sql 테이블명 &#34;order&#34;가 예약어라서 안된거였습니다.

siro · Answer

xml 에서 parametertype 은 어디 갔나요.

HSHidden · Answer

DAO에서public void addOrder(&#64;Param(&#34;vo&#34;) OrderVO vo);이렇게 보냈는데 xml에서도 따로 추가를 해줘야 되나요? parametertype에 vo클래스 위치 지정해줘도 같은오류가 발생합니다.. ㅜㅜ

베어 · Answer

스프링 버전과 jdbc버전을 확인해보세요. 몇버전이신지요 ? 그리고 default 대신 null로 넣어서 해보시겠어요 ?

HSHidden · Answer

베어스프링 버전은 현재 4.3.14.RELEASE, jdbc는 5.3.13버전 사용중입니다.default대신 null값을 넣어봤는데 같은오류가 발생하네요,,

베어 · Answer

jdbc 버전을 낮추세요. 스프링 버전이랑 맞게 singletonSupplier 는 jdbc 5.1버전 이상에 있는거라 못찾은 걸겁니다.

HSHidden · Answer

jdbc버전을 5.1 이하로 여러버전으로 변경후 해봤는데도 에러가 발생합니다.. 기본 버전에서 다른 테이블에 insert시에는 잘 작동 합니다

mybatis insert도중 에러가 발생하였습니다

7개의 답변

#dao 목록