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

View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      Hide

      1. Click File -> Import -> Web Service Source >> Source and Viewm model (SOAP)
      2. Create new connection profile with this url: http://ws-dvirt.rhcloud.com/dv-test-ws/soap?wsdl (It doesn't matter what WS you use)
      3. Go through the whole wizard
      4. Resulting View model has errors
      5. Note transformation SQL is incorrect

      Show
      1. Click File -> Import -> Web Service Source >> Source and Viewm model (SOAP) 2. Create new connection profile with this url: http://ws-dvirt.rhcloud.com/dv-test-ws/soap?wsdl (It doesn't matter what WS you use) 3. Go through the whole wizard 4. Resulting View model has errors 5. Note transformation SQL is incorrect
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Edit transformation SQL like this:
      ... XMLNAMESPACES('http://qe.dv.jboss.org/' AS tns) ...
      or
      ... XMLNAMESPACES(NO DEFAULT) ...

      Show
      Edit transformation SQL like this: ... XMLNAMESPACES('http://qe.dv.jboss.org/' AS tns) ... or ... XMLNAMESPACES(NO DEFAULT) ...

      Description

      Transformation SQL on xxx_response procedures looks like this:

      CREATE VIRTUAL PROCEDURE
      BEGIN
      	SELECT t.* FROM
      		XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in 
      	COLUMNS 
      		continentCode string PATH '/continentCode', 
      		capitalCity string PATH '/capitalCity', 
      		currencyIsoCode string PATH '/currencyIsoCode', 
      		isoCode string PATH '/isoCode', 
      		name string PATH '/name', 
      		phoneCode string PATH '/phoneCode') AS t;
      END
      

      XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works. (I copied this from TD 9.0.4)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              mmakovy Matus Makovy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: