java - Mule Database connector issue -
i have stored procedure in cache database, , trying call mule database connector. able connect it, every time, when call procedure, giving following error on console,
java.sql.sqlexception: keep_current_result not supported. @ com.intersys.jdbc.cachestatement.getmoreresults(cachestatement.java:2273) @ org.mule.module.db.internal.result.statement.statementresultiterator.movetonextresult(statementresultiterator.java:199) @ org.mule.module.db.internal.result.statement.statementresultiterator.hasnext(statementresultiterator.java:93) @ org.mule.module.db.internal.result.statement.abstractmapstatementresulthandler.processstatement(abstractmapstatementresulthandler.java:41) @ org.mule.module.db.internal.domain.executor.storedprocedureexecutor.doexecutequery(storedprocedureexecutor.java:45) @ org.mule.module.db.internal.domain.executor.abstractsinglequeryexecutor.execute(abstractsinglequeryexecutor.java:48) @ org.mule.module.db.internal.processor.storedproceduremessageprocessor.doexecutequery(storedproceduremessageprocessor.java:58) @ org.mule.module.db.internal.processor.abstractsinglequerydbmessageprocessor.executequery(abstractsinglequerydbmessageprocessor.java:42) @ org.mule.module.db.internal.processor.abstractdbmessageprocessor.process(abstractdbmessageprocessor.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.processor.asyncinterceptingmessageprocessor.process(asyncinterceptingmessageprocessor.java:97) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.construct.dynamicpipelinemessageprocessor.process(dynamicpipelinemessageprocessor.java:54) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.interceptor.abstractenvelopeinterceptor.process(abstractenvelopeinterceptor.java:51) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.processor.abstractfilteringmessageprocessor.process(abstractfilteringmessageprocessor.java:40) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.construct.abstractpipeline$1.process(abstractpipeline.java:109) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.construct.abstractpipeline$3.process(abstractpipeline.java:207) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.simplemessageprocessorchain.doprocess(simplemessageprocessorchain.java:43) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.simplemessageprocessorchain.doprocess(simplemessageprocessorchain.java:43) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.transport.abstractmessagereceiver.routeevent(abstractmessagereceiver.java:511) @ org.mule.transport.abstracttransportmessageprocesstemplate.routeevent(abstracttransportmessageprocesstemplate.java:80) @ org.mule.execution.flowprocessingphase$1$1.process(flowprocessingphase.java:76) @ org.mule.execution.flowprocessingphase$1$1.process(flowprocessingphase.java:63) @ org.mule.execution.executecallbackinterceptor.execute(executecallbackinterceptor.java:16) @ org.mule.execution.handleexceptioninterceptor.execute(handleexceptioninterceptor.java:30) @ org.mule.execution.handleexceptioninterceptor.execute(handleexceptioninterceptor.java:14) @ org.mule.execution.beginandresolvetransactioninterceptor.execute(beginandresolvetransactioninterceptor.java:54) @ org.mule.execution.resolveprevioustransactioninterceptor.execute(resolveprevioustransactioninterceptor.java:44) @ org.mule.execution.suspendxatransactioninterceptor.execute(suspendxatransactioninterceptor.java:50) @ org.mule.execution.validatetransactionalstateinterceptor.execute(validatetransactionalstateinterceptor.java:40) @ org.mule.execution.isolatecurrenttransactioninterceptor.execute(isolatecurrenttransactioninterceptor.java:41) @ org.mule.execution.externaltransactioninterceptor.execute(externaltransactioninterceptor.java:48) @ org.mule.execution.rethrowexceptioninterceptor.execute(rethrowexceptioninterceptor.java:28) @ org.mule.execution.rethrowexceptioninterceptor.execute(rethrowexceptioninterceptor.java:13) @ org.mule.execution.transactionalerrorhandlingexecutiontemplate.execute(transactionalerrorhandlingexecutiontemplate.java:109) @ org.mule.execution.flowprocessingphase$1.run(flowprocessingphase.java:62) @ org.mule.transport.trackingworkmanager$trackeablework.run(trackingworkmanager.java:267) @ org.mule.work.workercontext.run(workercontext.java:286) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) info 2014-08-18 19:45:08,745 [[mule-cache].connector.http.mule.default.receiver.02] org.mule.api.processor.loggermessageprocessor: sunquest warn 2014-08-18 19:45:08,902 [[mule-cache].connector.http.mule.default.receiver.02] org.mule.module.db.internal.result.statement.statementresultiterator: unable determine if there more statement results java.sql.sqlexception: keep_current_result not supported. @ com.intersys.jdbc.cachestatement.getmoreresults(cachestatement.java:2273) @ org.mule.module.db.internal.result.statement.statementresultiterator.movetonextresult(statementresultiterator.java:199) @ org.mule.module.db.internal.result.statement.statementresultiterator.hasnext(statementresultiterator.java:93) @ org.mule.module.db.internal.result.statement.abstractmapstatementresulthandler.processstatement(abstractmapstatementresulthandler.java:41) @ org.mule.module.db.internal.domain.executor.storedprocedureexecutor.doexecutequery(storedprocedureexecutor.java:45) @ org.mule.module.db.internal.domain.executor.abstractsinglequeryexecutor.execute(abstractsinglequeryexecutor.java:48) @ org.mule.module.db.internal.processor.storedproceduremessageprocessor.doexecutequery(storedproceduremessageprocessor.java:58) @ org.mule.module.db.internal.processor.abstractsinglequerydbmessageprocessor.executequery(abstractsinglequerydbmessageprocessor.java:42) @ org.mule.module.db.internal.processor.abstractdbmessageprocessor.process(abstractdbmessageprocessor.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.processor.asyncinterceptingmessageprocessor.process(asyncinterceptingmessageprocessor.java:97) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.construct.dynamicpipelinemessageprocessor.process(dynamicpipelinemessageprocessor.java:54) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.interceptor.abstractenvelopeinterceptor.process(abstractenvelopeinterceptor.java:51) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.processor.abstractfilteringmessageprocessor.process(abstractfilteringmessageprocessor.java:40) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.abstractinterceptingmessageprocessorbase.processnext(abstractinterceptingmessageprocessorbase.java:102) @ org.mule.construct.abstractpipeline$1.process(abstractpipeline.java:109) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.defaultmessageprocessorchain.doprocess(defaultmessageprocessorchain.java:94) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.construct.abstractpipeline$3.process(abstractpipeline.java:207) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.simplemessageprocessorchain.doprocess(simplemessageprocessorchain.java:43) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.simplemessageprocessorchain.doprocess(simplemessageprocessorchain.java:43) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.doprocess(interceptingchainlifecyclewrapper.java:50) @ org.mule.processor.chain.abstractmessageprocessorchain.process(abstractmessageprocessorchain.java:67) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.access$001(interceptingchainlifecyclewrapper.java:22) @ org.mule.processor.chain.interceptingchainlifecyclewrapper$1.process(interceptingchainlifecyclewrapper.java:66) @ org.mule.execution.exceptiontomessagingexceptionexecutioninterceptor.execute(exceptiontomessagingexceptionexecutioninterceptor.java:24) @ org.mule.execution.messageprocessornotificationexecutioninterceptor.execute(messageprocessornotificationexecutioninterceptor.java:58) @ org.mule.execution.messageprocessorexecutiontemplate.execute(messageprocessorexecutiontemplate.java:44) @ org.mule.processor.chain.interceptingchainlifecyclewrapper.process(interceptingchainlifecyclewrapper.java:61) @ org.mule.transport.abstractmessagereceiver.routeevent(abstractmessagereceiver.java:511) @ org.mule.transport.abstracttransportmessageprocesstemplate.routeevent(abstracttransportmessageprocesstemplate.java:80) @ org.mule.execution.flowprocessingphase$1$1.process(flowprocessingphase.java:76) @ org.mule.execution.flowprocessingphase$1$1.process(flowprocessingphase.java:63) @ org.mule.execution.executecallbackinterceptor.execute(executecallbackinterceptor.java:16) @ org.mule.execution.handleexceptioninterceptor.execute(handleexceptioninterceptor.java:30) @ org.mule.execution.handleexceptioninterceptor.execute(handleexceptioninterceptor.java:14) @ org.mule.execution.beginandresolvetransactioninterceptor.execute(beginandresolvetransactioninterceptor.java:54) @ org.mule.execution.resolveprevioustransactioninterceptor.execute(resolveprevioustransactioninterceptor.java:44) @ org.mule.execution.suspendxatransactioninterceptor.execute(suspendxatransactioninterceptor.java:50) @ org.mule.execution.validatetransactionalstateinterceptor.execute(validatetransactionalstateinterceptor.java:40) @ org.mule.execution.isolatecurrenttransactioninterceptor.execute(isolatecurrenttransactioninterceptor.java:41) @ org.mule.execution.externaltransactioninterceptor.execute(externaltransactioninterceptor.java:48) @ org.mule.execution.rethrowexceptioninterceptor.execute(rethrowexceptioninterceptor.java:28) @ org.mule.execution.rethrowexceptioninterceptor.execute(rethrowexceptioninterceptor.java:13) @ org.mule.execution.transactionalerrorhandlingexecutiontemplate.execute(transactionalerrorhandlingexecutiontemplate.java:109) @ org.mule.execution.flowprocessingphase$1.run(flowprocessingphase.java:62) @ org.mule.transport.trackingworkmanager$trackeablework.run(trackingworkmanager.java:267) @ org.mule.work.workercontext.run(workercontext.java:286) @ java.util.concurrent.threadpoolexecutor.runworker(unknown source) @ java.util.concurrent.threadpoolexecutor$worker.run(unknown source) @ java.lang.thread.run(unknown source) below code call stored procedure database
<db:stored-procedure config-ref="generic_database_configuration" doc:name="cache database" streaming="true"> <db:parameterized-query><![cdata[{ call aviation.testproc_returnall() }]]></db:parameterized-query> </db:stored-procedure> and below code used create stored procedure in intersystems cache database
class aviation.testproc extends (%persistent, %populate, %xml.adaptor){ classmethod returnall() [ returnresultsets, sqlproc ]{ $$$resultset("select event aviation.aircraft") $$$resultset("select category aviation.crew") quit } } can tell me root cause of issue ?
it looks there jdbc feature jdbc driver doesn't support. i'd suggest capturing problem in log of jdbc connection (you can set jdbc connection log modifying connection string), , examining log.
as work around, i'd try separating 2 queries discrete stored procedures , call each of them.
you can contact support @ intersystems , assist you.
Comments
Post a Comment