java mvc ibatis 오류 났는데 이게 파라미터를 못가져오고 있는걸까요?

Question

초보개발자입니다. 계속 오류가 떠서 이게 쿼리에서 문제인지 아니면 serviceimpl쪽에서 문제인지 영 감이 안잡혀서요 고수님들 답변 부탁드립니다 ㅠserviceimpl.javapublic Hashtable selectCustomerAddressByDongName(Object objForm) { Hashtable htRet = new Hashtable(); //htRet 객체생성. 해시테이블은 키와 값의 쌍을 저장. CustomerForm customerForm = (CustomerForm)objForm;String sido = customerForm.getCustomerAddress() + customerForm.getsiValue() + customerForm.getSigunguValue().replaceAll("%", "\\%");VocCombDB vocCombDB = new VocCombDB();List list = null;try { list = customerDao.selectCustomerAddressByDongName(vocCombDB);System.out.println("list>>>>>>>>>>>"+list);} catch (Exception e) { e.printStackTrace(); }daoimpl.java public List selectCustomerAddressByDongName(VocCombDB vocCombDB) throws SQLException { System.out.println(">>>>>>>>>>>>>>>>>>>>"+vocCombDB); return (List)getSqlMapClientTemplate().queryForList("Customer.selectPost", vocCombDB); }.xml 오류메세지org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1008]; --- The error occurred in spectra/ext/webapps/customer/dao/ibatis/maps/oracle/Customer.xml. --- The error occurred while applying a parameter map. --- Check the Customer.paramSido. --- Check the statement (query failed). --- Cause: java.sql.SQLException: ORA-01008: 일부 변수가 바인드되지 않았습니다.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in spectra/ext/webapps/customer/dao/ibatis/maps/oracle/Customer.xml. --- The error occurred while applying a parameter map. --- Check the Customer.paramSido. --- Check the statement (query failed). --- Cause: java.sql.SQLException: ORA-01008: 일부 변수가 바인드되지 않았습니다.Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in spectra/ext/webapps/customer/dao/ibatis/maps/oracle/Customer.xml. --- The error occurred while applying a parameter map. --- Check the Customer.paramSido. --- Check the statement (query failed). --- Cause: java.sql.SQLException: ORA-01008: 일부 변수가 바인드되지 않았습니다. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:626) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:600) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:269) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194) at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220) at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267) at spectra.ext.webapps.customer.dao.ibatis.CustomerDaoImpl.selectCustomerAddressByDongName(CustomerDaoImpl.java:68) at spectra.ext.webapps.customer.service.CustomerServiceImpl.selectCustomerAddressByDongName(CustomerServiceImpl.java:136) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77) at spectra.ee.webapps.common.web.LogAdvice.writeServiceLog(LogAdvice.java:149) at sun.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:597) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:583) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:60) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy62.selectCustomerAddressByDongName(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at spectra.base.util.Util.invokeMothod(Util.java:182) at spectra.base.ajax.AjaxBaseControllerImpl.invokeService(AjaxBaseControllerImpl.java:191) at spectra.base.ajax.AjaxBaseControllerImpl.handle(AjaxBaseControllerImpl.java:108) at spectra.base.ajax.AjaxBaseControllerImpl.baseHandle(AjaxBaseControllerImpl.java:62) at spectra.ee.webapps.common.web.controller.AjaxController.baseHandle(AjaxController.java:74) at spectra.ee.webapps.common.web.controller.AjaxController.handle(AjaxController.java:120) at org.springframework.web.servlet.mvc.AbstractCommandController.handleRequestInternal(AbstractCommandController.java:84) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:859) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:793) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:662)Caused by: java.sql.SQLException: ORA-01008: 일부 변수가 바인드되지 않았습니다. at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at sun.reflect.GeneratedMethodAccessor102.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:113) at com.sun.proxy.$Proxy8.execute(Unknown Source) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) ... 68 more

roggue2 · Answer

참조 : https://xzio.tistory.com/356

java mvc ibatis 오류 났는데 이게 파라미터를 못가져오고 있는걸까요?

1개의 답변

Q&A 목록