Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1430

WSDL to Relational Source importer generates incorrect SQL for response (Windows only)

    Details

    • Steps to Reproduce:
      Hide

      Follow the Consume SOAP Web Service action guide.

      Show
      Follow the Consume SOAP Web Service action guide.
    • Workaround Description:
      Hide

      Once the SQL is generated, replace the instances of /ns: with the correct object name (and no colon). For example:

      COLUMNS SUPPLIER_NAME string PATH '/ns:'

      becomes

      COLUMNS SUPPLIER_NAME string PATH '/SUPPLIER_NAME'

      Show
      Once the SQL is generated, replace the instances of /ns: with the correct object name (and no colon). For example: COLUMNS SUPPLIER_NAME string PATH '/ns:' becomes COLUMNS SUPPLIER_NAME string PATH '/SUPPLIER_NAME'

      Description

      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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  pnittel Paul Nittel
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: