[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1430) WSDL to Relational Source importer generates incorrect SQL for response (Windows only)

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