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

    • 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 Exists
    • 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) ...

      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)

            Unassigned Unassigned
            mmakovy@redhat.com Matus Makovy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: