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

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

    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

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIIDDES-2748 ‘Import => Teiid Designer => Web Service Source >> Source and View Model (SOAP)’ import wizard I am not getting columns for either my input or output wrapers methods.

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: