]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> changed the Status of [bug
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL:
https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: