[teiid-issues] [JBoss JIRA] Updated: (TEIID-1216) Cannot pass xml result from one select as critera to another select
John Doyle (JIRA)
jira-events at lists.jboss.org
Tue Aug 17 13:42:11 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Doyle updated TEIID-1216:
------------------------------
Attachment: TEIID-1216.zip
VDB is in the attached project.
> Cannot pass xml result from one select as critera to another select
> -------------------------------------------------------------------
>
> Key: TEIID-1216
> URL: https://jira.jboss.org/browse/TEIID-1216
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 7.1
> Environment: Teiid 7.1 CR2 on RHEL 5
> Reporter: John Doyle
> Assignee: Steve Hawkins
> Attachments: TEIID-1216.zip
>
>
> I've created a VDB with procedures to create and parse XML, as wall as one to invoke the WS connector. SQL that unites them all into a single call passing the created XML into the invoke procedure is failing:
> SELECT t.* FROM table (EXEC cis.CountryInfoServiceXML.CapitalCity.create_CapitalCity('US')) AS request, table (EXEC CountryInfoService.invoke('SOAP11', '', request.xml_out, 'http://www.oorsprong.org/websamples.countryinfo/CountryInfoService.wso')) AS response, table (EXEC cis.CountryInfoServiceXML.CapitalCity.extract_CapitalCityResponse(RESPONSE.result)) AS t;
> 13:23:02,501 ERROR [PROCESSOR] Unexpected exception for request wHnSpxDdmkGB.5
> [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate request.xml_out: No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:389)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:629)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list