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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.1, 7.8
    • 7.7.1
    • Web Services Support
    • None
    • Hide

      Follow the Consume SOAP Web Service action guide.

      Show
      Follow the Consume SOAP Web Service action guide.
    • 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

      Attachments

        Issue Links

          Activity

            People

              blafond Barry LaFond
              pnittel_jira Paul Nittel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: