[JBoss JIRA] (TEIIDDES-1233) Teiid cannot handle child elements belonging to a different namespace
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1233?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-1233:
---------------------------------------------------
Ted Jones <tejones(a)redhat.com> made a comment on [bug 785713|https://bugzilla.redhat.com/show_bug.cgi?id=785713]
Given the response example provided by the customer:
<ns1:searchMidbWSResponse … >
< ns1:return>
< ns1:Site>
<ns2:PropOne>…</ ns2:PropOne>
< ns2:PropTwo>…</ ns2:PropTwo>
etc…
</ ns1:Site>
</ ns1:return>
</ ns1:searchMidbWSResponse>
the transformation would look something like this:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM XMLTABLE(XMLNAMESPACES('http://www.namespace1.org/' AS ns1, 'http://www.namespace1.org/' AS ns2), '/ns1:searchMidbWSResponse/ns1:return/ns1:Site' PASSING ViewModel.operation_response.xml_in COLUMNS PropOne string PATH '/ns2:PropOne', PropTwo string PATH '/ns2:PropTwo') AS t;
END
> Teiid cannot handle child elements belonging to a different namespace
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-1233
> URL: https://issues.jboss.org/browse/TEIIDDES-1233
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 7.6
> Reporter: Debbie Steigner
> Assignee: Ted Jones
> Fix For: 7.7.1, 7.8
>
> Attachments: foo.zip
>
>
> In the case where a web service is returning a response similar to the
> following:
> <ns1:searchMidbWSResponse ... >
> < ns1:return>
> < ns1:Site>
> <ns2:PropOne>...</ ns2:PropOne>
> < ns2:PropTwo>...</ ns2:PropTwo>
> etc...
> </ ns1:Site>
> </ ns1:return>
> </ ns1:searchMidbWSResponse>
> Notice that all of the Site property elements belong to a different namespace
> (alias=ns2) whereas the outer elements belong to the namespace with the ns1
> alias. It looks like EDS cannot handle child elements belonging to a different
> namespace.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 11 months