[
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