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

WSDL to Source Importer - Namespace Prefix not Added to XPath in Generated Transformation

    Details

      Description

      When importing the WSDL: http://www.itis.gov/ITISWebService.xml , the generated request transformation is missing the ns prefixes in the xpath. Also, the namespaces that are added are inconsistent. On one import it they may all be added and on the next, one may be missing.

      Generated:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://metadata.itis_service.itis.usgs.org/xsd' AS ax26, 'http://data.itis_service.itis.usgs.org/xsd' AS ax24), '/getCommonNamesFromTSNResponse/return/commonNames' PASSING ITISServiceView.getCommonNamesFromTSN_response.xml_in COLUMNS commonName string PATH '/commonName', "language" string PATH '/language', tsn string PATH '/tsn') AS t;
      END

      Should be:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      SELECT t.* FROM XMLTABLE(XMLNAMESPACES(DEFAULT 'http://itis_service.itis.usgs.org', 'http://data.itis_service.itis.usgs.org/xsd' AS ax26), '/getCommonNamesFromTSNResponse/return/ax26:commonNames' PASSING xml_in COLUMNS commonName string PATH '/ax26:commonName', "language" string PATH '/ax26:language', tsn string PATH '/ax26:tsn') AS t;
      END

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                tejones Ted Jones
                Reporter:
                tejones Ted Jones
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: