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
운영게시판
최근게시물
Tibero Q&A 587 게시물 읽기
No. 587
Tibero + QueryService(Anyframe) 조합에서 결과값을 리턴하는 프로시져 호출 에러
작성자
선영석(sunys99)
작성일
2010-08-18 15:53
조회수
9,065

 Tibero 4.0 + *QueryService 를 이용해서 database를 연결해서 사용하고자 합니다.

 결과 값을 넘겨주는 CallableStatement  를 사용하는 프로시져를 호출 하고자 할때 다음과 같은 에러가 발생합니다.

2010-08-18 12:53:26,687 ERROR [anyframe.core.query.IQueryService] Query Service : Fail to execute statement [query id = 'call_syncSvcCiTrAndMbSvcTr'].

 Query = [CALL syncSvcCiTrAndMbSvcTr(?)] 

 Reason = [CallableStatementCallback; uncategorized SQLException for SQL [CALL syncSvcCiTrAndMbSvcTr(?)]; SQL state [null]; error code [-90201]; TJDBC-90201:Unsupported operation.; nested exception is com.tmax.tibero.jdbc.TbSQLException: TJDBC-90201:Unsupported operation.]. 

org.springframework.jdbc.UncategorizedSQLException: CallableStatementCallback; uncategorized SQLException for SQL [CALL syncSvcCiTrAndMbSvcTr(?)]; SQL state [null]; error code [-90201]; TJDBC-90201:Unsupported operation.; nested exception is com.tmax.tibero.jdbc.TbSQLException: TJDBC-90201:Unsupported operation.

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:952)

at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:324)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:291)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:286)

at com.sds.maxigent.mitw.components.mboard.sync.MboardSyncMgmtImpl.syncMboardSvcTrFromSvcCiTr(MboardSyncMgmtImpl.java:111)

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:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

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 $Proxy53.syncMboardSvcTrFromSvcCiTr(Unknown Source)

at com.sds.maxigent.mitw.action.mboard.admin.AdminMboardModelingAction.syncMboardServiceTree(AdminMboardModelingAction.java:497)

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:585)

at anyframe.web.struts.action.DefaultDispatchActionSupport.dispatchMethod(DefaultDispatchActionSupport.java:215)

at anyframe.web.struts.action.DefaultDispatchActionSupport.process(DefaultDispatchActionSupport.java:141)

at anyframe.web.struts.action.AbstractActionSupport.execute(AbstractActionSupport.java:103)

at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)

at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)

at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)

at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)

at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)

at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)

at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)

at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)

at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)

at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)

at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)

at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)

at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:516)

at com.caucho.util.ThreadPool.run(ThreadPool.java:442)

at java.lang.Thread.run(Thread.java:595)

Caused by: com.tmax.tibero.jdbc.TbSQLException: TJDBC-90201:Unsupported operation.

at com.tmax.tibero.jdbc.TbCallableStatement.registerOutParameter(TbCallableStatement.java:877)

at org.apache.commons.dbcp.DelegatingCallableStatement.registerOutParameter(DelegatingCallableStatement.java:171)

at org.springframework.jdbc.core.CallableStatementCreatorFactory$CallableStatementCreatorImpl.createCallableStatement(CallableStatementCreatorFactory.java:192)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:930)

... 52 more

Root cause follows.

com.tmax.tibero.jdbc.TbSQLException: TJDBC-90201:Unsupported operation.

at com.tmax.tibero.jdbc.TbCallableStatement.registerOutParameter(TbCallableStatement.java:877)

at org.apache.commons.dbcp.DelegatingCallableStatement.registerOutParameter(DelegatingCallableStatement.java:171)

at org.springframework.jdbc.core.CallableStatementCreatorFactory$CallableStatementCreatorImpl.createCallableStatement(CallableStatementCreatorFactory.java:192)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:930)

at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:985)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:324)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:291)

at anyframe.core.query.impl.QueryServiceImpl.execute(QueryServiceImpl.java:286)

at com.sds.maxigent.mitw.components.mboard.sync.MboardSyncMgmtImpl.syncMboardSvcTrFromSvcCiTr(MboardSyncMgmtImpl.java:111)

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:585)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:54)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

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 $Proxy53.syncMboardSvcTrFromSvcCiTr(Unknown Source)

at com.sds.maxigent.mitw.action.mboard.admin.AdminMboardModelingAction.syncMboardServiceTree(AdminMboardModelingAction.java:497)

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:585)

at anyframe.web.struts.action.DefaultDispatchActionSupport.dispatchMethod(DefaultDispatchActionSupport.java:215)

at anyframe.web.struts.action.DefaultDispatchActionSupport.process(DefaultDispatchActionSupport.java:141)

at anyframe.web.struts.action.AbstractActionSupport.execute(AbstractActionSupport.java:103)

at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)

at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)

at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)

at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)

at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)

at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)

at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)

at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)

at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)

at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)

at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)

at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)

at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:516)

at com.caucho.util.ThreadPool.run(ThreadPool.java:442)

 

이런 경우를 어떻게 처리해야 하나요~? 고수님들의 조언 부탁 드립니다.

 

*QueryService는 Anyframe에서 사용하는 DB연동 프레임워크로 ibatis나hibernate와 비슷하게 xml기반으로 DB를 사용하는

  프레임 워크 입니다.

 

 

[Top]
No.
제목
작성자
작성일
조회
590티베로 망했나요? [2]
오새롬
2011-06-22
10218
589리눅스 티베로 설치 관련 질문이 있습니다ㅠㅠ
wideon2
2010-11-17
9491
588티베로 TJDBC-90400 에러에 관해서요 [1]
박제범
2010-09-03
11501
587Tibero + QueryService(Anyframe) 조합에서 결과값을 리턴하는 프로시져 호출 에러
선영석
2010-08-18
9065
584TAC 사용 시 system hang 현상 [1]
grrrr
2010-03-24
8885
574티베로 트랜잭션 처리 [1]
해소수
2010-02-09
12997
524티베로 + 스프링 사용중 에러.. ㅠㅠ [4]
쵸리
2009-11-17
30819
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2020 DSN, All rights reserved.
작업시간: 0.040초, 이곳 서비스는
	PostgreSQL v13.0으로 자료를 관리합니다