database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL Q&A 31439 게시물 읽기
No. 31439
mysql procedure 진행 시 에러
작성자
inseong
작성일
2023-04-18 11:55
조회수
13,193


mysql 고수님 확인 부탁 드립니다.

mysql procedure  진행 시 에러 



mysql procedure-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

{call SEND_SMS_PROC_V2(#{searchWord1,jdbcType=VARCHAR}, #{searchWord2,jdbcType=VARCHAR}, #{searchWord3, jdbcType=VARCHAR}, #{searchWord, jdbcType=VARCHAR})}

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


정상일때 param----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

getSearchWord1 shaftkill

getSearchWord2 0EAA9B6AFF4C69E14AF7C69198F1FAD2

getSearchWord3 {"unitPrice":10.0,"reserveYn":"N","subject":"","divGap":0,"callBack":"010-0000-0001","ipAddress":"127.0.0.1","body":"(광고)\n정상\n무료거부 ","sendLind":"invito_v1","denyExclude":"Y","divYn":"N","adYn":"Y","attachCnt":0,"smsType":"SMS","divCnt":0,"waitCnt":3}

getSearchWord invito_v1

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------


비 정상일때 param----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

getSearchWord1 shaftkill

getSearchWord2 0EAA9B6AFF4C69E14AF7C69198F1FAD2

getSearchWord3 {"unitPrice":10.0,"reserveYn":"N","subject":"","divGap":0,"callBack":"010-0000-0001","ipAddress":"127.0.0.1","body":"(광고)\n에러 테스트\n무료거부","sendLind":"invito_v1","denyExclude":"Y","divYn":"N","adYn":"Y","attachCnt":0,"smsType":"SMS","divCnt":0,"waitCnt":500}

getSearchWord invito_v1

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

error ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

2023-04-18 11:46:02 [ERROR] jdbc.audit::exceptionOccured - 151. Connection.prepareCall({call SEND_SMS_PROC_V2(?, ?, ?, ?)}) {call SEND_SMS_PROC_V2(?, ?, ?, ?)}

java.sql.SQLException

    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.ConnectionImpl.setDatabase(ConnectionImpl.java:2107) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1426) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:3185) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:3054) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:795) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.CallableStatement.<init>(CallableStatement.java:588) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.CallableStatement.getInstance(CallableStatement.java:487) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:1497) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1522) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1513) ~[mysql-connector-java-8.0.27.jar:8.0.27]

    at com.zaxxer.hikari.pool.ProxyConnection.prepareCall(ProxyConnection.java:295) ~[HikariCP-3.4.2.jar:?]

    at com.zaxxer.hikari.pool.HikariProxyConnection.prepareCall(HikariProxyConnection.java) ~[HikariCP-3.4.2.jar:?]

    at net.sf.log4jdbc.ConnectionSpy.prepareCall(ConnectionSpy.java:674) [log4jdbc-remix-0.2.7.jar:?]

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_261]

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_261]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]

    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]

    at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:61) [mybatis-3.2.8.jar:3.2.8]

    at com.sun.proxy.$Proxy43.prepareCall(Unknown Source) [?:?]

    at org.apache.ibatis.executor.statement.CallableStatementHandler.instantiateStatement(CallableStatementHandler.java:77) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:85) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:57) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.ReuseExecutor.prepareStatement(ReuseExecutor.java:76) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:56) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:120) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102) [mybatis-3.2.8.jar:3.2.8]

    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66) [mybatis-3.2.8.jar:3.2.8]

    at sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source) ~[?:?]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]

    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]

    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358) [mybatis-spring-1.2.2.jar:1.2.2]

    at com.sun.proxy.$Proxy72.selectOne(Unknown Source) [?:?]

    at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163) [mybatis-spring-1.2.2.jar:1.2.2]

    at com.tagosms.service.dao.GeneralDAOImpl.selectOne(GeneralDAOImpl.java:25) [classes/:?]

    at com.tagosms.service.impl.SmsServiceImpl.insertSms(SmsServiceImpl.java:412) [classes/:?]

    at com.tagosms.service.impl.SmsServiceImpl$$FastClassBySpringCGLIB$$849ea09a.invoke(<generated>) [classes/:?]

    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656) [spring-aop-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at com.tagosms.service.impl.SmsServiceImpl$$EnhancerBySpringCGLIB$$24ecab5e.insertSms(<generated>) [classes/:?]

    at com.tagosms.controller.front.sms.SmsController.sendSms(SmsController.java:354) [classes/:?]

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_261]

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_261]

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_261]

    at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_261]

    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]

    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.73]

    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.73]

    at com.navercorp.lucy.security.xss.servletfilter.XssEscapeServletFilter.doFilter(XssEscapeServletFilter.java:36) [lucy-xss-servlet-2.0.0.jar:?]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.73]

    at org.springframework.web.multipart.support.MultipartFilter.doFilterInternal(MultipartFilter.java:122) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.73]

    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]

    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.73]

    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.73]

    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:196) [catalina.jar:8.5.73]

    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.73]

    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:8.5.73]

    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.73]

    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.73]

    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.73]

    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.73]

    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:364) [catalina.jar:8.5.73]

    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:624) [tomcat-coyote.jar:8.5.73]

    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.73]

    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) [tomcat-coyote.jar:8.5.73]

    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1673) [tomcat-coyote.jar:8.5.73]

    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.73]

    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.73]

    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.73]

    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.73]

    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_261]

------------------------------------------------------------------------------------------------------------------------------------------------------

[Top]
No.
제목
작성자
작성일
조회
31443고수님분께 여쭙니다. [10]
cheongha
2024-02-13
349
31442MYSQL 쿼리튜닝 [2]
사랑이
2023-12-17
1729
31440표시 순서 변경하기 [3]
mossmin
2023-06-30
6131
31439mysql procedure 진행 시 에러
inseong
2023-04-18
13193
31415복합키 조인 및 조회 [2]
mossmin
2023-03-09
13976
31414v24n1 을 제24권 제1호 로 s224를 제 244권 으로 어떻게 바꿀까요?? [3]
김종수
2023-03-02
14014
31413서비스 운영중인 Database 클러스터에 dump 파일을 안전하게 복원하는 방법에 대한 문의
개미
2023-02-15
13328
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.017초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다