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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.1, 7.8
    • 7.7.1
    • Import/Export
    • None

    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

      Attachments

        Activity

          People

            rhn-engineering-tejones Edwin Jones
            rhn-engineering-tejones Edwin Jones
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: