[JBoss JIRA] (TEIID-2699) virtual procedure with IN params get errors
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2699?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2699.
-----------------------------------
Resolution: Done
Will update the download page to specify 1.6.0_18 or later
> 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
11 years, 2 months
[JBoss JIRA] (TEIID-2705) Remove from standalone.cli and domain.cli, the adding of the resource adapters
by Van Halbert (JIRA)
Van Halbert created TEIID-2705:
----------------------------------
Summary: Remove from standalone.cli and domain.cli, the adding of the resource adapters
Key: TEIID-2705
URL: https://issues.jboss.org/browse/TEIID-2705
Project: Teiid
Issue Type: Enhancement
Components: Build/Kits
Affects Versions: 8.4.1
Reporter: Van Halbert
Assignee: Van Halbert
Remove the adding of the resource adapters in the cli configuration scripts. This is because:
1. They don't define a specific instance
2. When multiple instances are added, they each should have a different name, so that one can be removed without removing the other.
--
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
11 years, 2 months
[JBoss JIRA] (TEIID-2699) virtual procedure with IN params get errors
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-2699?page=com.atlassian.jira.plugin... ]
luca gioppo commented on TEIID-2699:
------------------------------------
Made the update and the problem is solved.
Is ok to solve it.
Thanks
> 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
11 years, 2 months
[JBoss JIRA] (TEIID-2699) virtual procedure with IN params get errors
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2699?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2699:
---------------------------------------
Hi Luca,
Given an update of the download page and other references to 1.6.0.18+, is it ok to resolve this?
> 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
11 years, 2 months
[JBoss JIRA] (TEIID-2704) DB2 sql/xml values must be read inline
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2704?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2704.
-----------------------------------
Resolution: Done
Added xmlserialize to clob for derby retrieval. And for both db2/derby will call getString to get the value. This is not ideal, but with our current architecture where the lob copying and other functions are handled at a higher level this is as good as we can do.
> DB2 sql/xml values must be read inline
> --------------------------------------
>
> Key: TEIID-2704
> URL: https://issues.jboss.org/browse/TEIID-2704
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.0
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.6
>
>
> With the DB2 9 driver and selecting an xml column. The resulting DB2Xml instance becomes invalid after the next row of the result is transitioned to.
> We can compensate for this by retrieving the value as a string.
--
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
11 years, 2 months
[JBoss JIRA] (TEIID-2704) DB2 sql/xml values must be read inline
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2704:
-------------------------------------
Summary: DB2 sql/xml values must be read inline
Key: TEIID-2704
URL: https://issues.jboss.org/browse/TEIID-2704
Project: Teiid
Issue Type: Bug
Components: JDBC Connector
Affects Versions: 7.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.6
With the DB2 9 driver and selecting an xml column. The resulting DB2Xml instance becomes invalid after the next row of the result is transitioned to.
We can compensate for this by retrieving the value as a string.
--
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
11 years, 2 months
[JBoss JIRA] (TEIID-2703) Refactor value retrieval to class based
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2703:
-------------------------------------
Summary: Refactor value retrieval to class based
Key: TEIID-2703
URL: https://issues.jboss.org/browse/TEIID-2703
Project: Teiid
Issue Type: Enhancement
Components: JDBC Connector
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Similar to Hibernate, we need to introduce encapsulated value retrieval methods. The current approach (which is legacy back to the mmx days) typically uses a switch block with other checks, which can largely be avoided and should improve performance.
--
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
11 years, 2 months
[JBoss JIRA] (TEIID-2702) Deploying google using example google.xml throws exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2702?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2702.
-----------------------------------
Fix Version/s: 8.6
Resolution: Done
Specifying a java.lang.Long with a long method will not work. Since there was no need to use a Long, updated all to Integer.
> Deploying google using example google.xml throws exception
> -----------------------------------------------------------
>
> Key: TEIID-2702
> URL: https://issues.jboss.org/browse/TEIID-2702
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.6
>
>
> Trying to deploy google using the example and the BatchSize config property is not recognized, error thrown:
> Caused by: java.lang.NoSuchMethodException: JBAS010474: Method setBatchSize not found
> at org.jboss.as.connector.util.Injection.inject(Injection.java:130)
> at org.jboss.as.connector.util.Injection.inject(Injection.java:83)
> at org.jboss.as.connector.services.resourceadapters.deployment.AbstractResourceAdapterDeploymentService$AbstractAS7RaDeployer.initAndInject(AbstractResourceAdapterDeploymentService.java:428)
> ... 8 more
--
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
11 years, 2 months
[JBoss JIRA] (TEIID-2702) Deploying google using example google.xml throws exception
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2702?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2702:
----------------------------------
Workaround Description: Remove the batchSize setting, which will use the default of 4096 or 2 x the working batch size which ever is smaller.
Workaround: Workaround Exists
> Deploying google using example google.xml throws exception
> -----------------------------------------------------------
>
> Key: TEIID-2702
> URL: https://issues.jboss.org/browse/TEIID-2702
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Trying to deploy google using the example and the BatchSize config property is not recognized, error thrown:
> Caused by: java.lang.NoSuchMethodException: JBAS010474: Method setBatchSize not found
> at org.jboss.as.connector.util.Injection.inject(Injection.java:130)
> at org.jboss.as.connector.util.Injection.inject(Injection.java:83)
> at org.jboss.as.connector.services.resourceadapters.deployment.AbstractResourceAdapterDeploymentService$AbstractAS7RaDeployer.initAndInject(AbstractResourceAdapterDeploymentService.java:428)
> ... 8 more
--
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
11 years, 2 months