[teiid-issues] [JBoss JIRA] (TEIID-2699) virtual procedure with IN params get errors
Steven Hawkins (JIRA)
issues at jboss.org
Tue Apr 22 15:02:38 EDT 2014
[ https://issues.jboss.org/browse/TEIID-2699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-2699.
---------------------------------
> virtual procedure with IN params get errors
> -------------------------------------------
>
> Key: TEIID-2699
> URL: https://issues.jboss.org/browse/TEIID-2699
> Project: Teiid
> Issue Type: Bug
> Components: XML Planner/Processor
> Affects Versions: 8.3
> Environment: Windows XP, java 1.6.0_04
> Reporter: luca gioppo
> Assignee: Steven Hawkins
>
> I've creted a virtual procedure like this one:
> CREATE VIRTUAL PROCEDURE
> BEGIN
> IF(accident_proc.getaccident.id = null)
> BEGIN
> SELECT XMLELEMENT(NAME accidents, XMLAGG(XMLELEMENT(NAME accident, XMLFOREST(accident_view.accident.id, accident_view.accident.lat, accident_view.accident.lon, accident_view.accident.accident_date)))) AS result FROM accident_view.accident;
> END
> ELSE
> BEGIN
> SELECT XMLELEMENT(NAME accidents, XMLAGG(XMLELEMENT(NAME accident, XMLFOREST(accident_view.accident.id, accident_view.accident.lat, accident_view.accident.lon, accident_view.accident.accident_date)))) AS result FROM accident_view.accident WHERE accident_view.accident.id = accident_proc.getaccident.id;
> END
> END
> invoke it from squirrelsql like this
> select * from accident_proc.getaccident where id=1;
> the actual table has just 1 row that is exposed through the VDB and can be red correctly.
> I get this exception
> 14:56:42,573 ERROR [org.teiid.PROCESSOR] (Worker7_QueryProcessorQueue28) TEIID30019 Unexpected exception for request OFF
> fN2xoRDPn.8: java.lang.NoSuchMethodError: javax.xml.stream.XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory
> ;
> at org.teiid.query.function.source.XMLSystemFunctions$4.initialValue(XMLSystemFunctions.java:395) [teiid-engine-
> 8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.function.source.XMLSystemFunctions$4.initialValue(XMLSystemFunctions.java:393) [teiid-engine-
> 8.3.0.Beta2.jar:8.3.0.Beta2]
> at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:141) [rt.jar:1.6.0_04]
> at java.lang.ThreadLocal.get(ThreadLocal.java:131) [rt.jar:1.6.0_04]
> at org.teiid.query.function.source.XMLSystemFunctions$4.get(XMLSystemFunctions.java:398) [teiid-engine-8.3.0.Bet
> a2.jar:8.3.0.Beta2]
> at org.teiid.query.function.source.XMLSystemFunctions$4.get(XMLSystemFunctions.java:393) [teiid-engine-8.3.0.Bet
> a2.jar:8.3.0.Beta2]
> at org.teiid.query.function.source.XMLSystemFunctions$6.translate(XMLSystemFunctions.java:476) [teiid-engine-8.3
> .0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.function.source.XMLSystemFunctions.saveToBufferManager(XMLSystemFunctions.java:989) [teiid-en
> gine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.function.source.XMLSystemFunctions.xmlForest(XMLSystemFunctions.java:468) [teiid-engine-8.3.0
> .Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.eval.Evaluator.evaluateXMLForest(Evaluator.java:887) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Beta
> 2]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:648) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Beta2
> ]
> at org.teiid.query.eval.Evaluator.evaluateXMLElement(Evaluator.java:915) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Bet
> a2]
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:646) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Beta2
> ]
> at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:596) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.GroupingNode$ProjectingTupleSource.updateTuple(GroupingNode.java:84) [te
> iid-engine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.BatchCollector$BatchProducerTupleSource.nextTuple(BatchCollector.java:95) [teiid-en
> gine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.GroupingNode.groupPhase(GroupingNode.java:382) [teiid-engine-8.3.0.Beta2
> .jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.GroupingNode.nextBatchDirect(GroupingNode.java:322) [teiid-engine-8.3.0.
> Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:144) [teiid-engine-8.3.0.Beta2.j
> ar:8.3.0.Beta2]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:110) [teiid-engine-8.3.0.Beta2.jar:8.3
> .0.Beta2]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:70) [teiid-engine-8.3.0.Beta2.jar:8.3.0.B
> eta2]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:69) [teiid-engine-8.3.0.
> Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:85) [teiid-engine-8.3.0.Beta2.jar:
> 8.3.0.Beta2]
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:91) [teiid-engine-8.3.0.Beta2.ja
> r:8.3.0.Beta2]
> at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:579) [teiid-engine-8.3.0.Beta2.ja
> r:8.3.0.Beta2]
> at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java
> :68) [teiid-engine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:388) [teiid-engine-8.3.0.Bet
> a2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:315) [teiid-engine-8.3.0.Beta
> 2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:289) [teiid-engine-8.3.0.Beta2.jar:
> 8.3.0.Beta2]
> at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-eng
> ine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.LimitNode.nextBatchDirect(LimitNode.java:101) [teiid-engine-8.3.0.Beta2.
> jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:144) [teiid-engine-8.3.0.Beta2.j
> ar:8.3.0.Beta2]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:110) [teiid-engine-8.3.0.Beta2.jar:8.3
> .0.Beta2]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153) [teiid-engine-8.3.0.Beta2.jar
> :8.3.0.Beta2]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:400) [teiid-engine-8.3.0.Beta
> 2.jar:8.3.0.Beta2]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:296) [teiid-engine-8.3.0.Beta2.ja
> r:8.3.0.Beta2]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [teiid-engine-8.3.0.Beta2.jar:8
> .3.0.Beta2]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:224) [teiid-engine-8.3.0.Beta2.jar:8.
> 3.0.Beta2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:253) [teiid-engine-8.3.0.Beta2
> .jar:8.3.0.Beta2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-e
> ngine-8.3.0.Beta2.jar:8.3.0.Beta2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.3.0.Be
> ta2.jar:8.3.0.Beta2]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) [rt.jar:1.6.0_04]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) [rt.jar:1.6.0_04]
> at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list