Paul Nittel <pnittel@redhat.com> made a comment on bug 829735

Tested with ER4 and JBDS 5.0GA with SOA-tooling CR1.

The generated transformation SQL:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns), '/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:', SUPPLIER_CITY string PATH '/ns:', QUANTITY bigdecimal PATH '/ns:', PART_ID string PATH '/ns:PART_ID') AS t;
END

does not validate. Validation requires dropping the colon from the paths, for example: SUPPLIER_NAME string PATH '/ns'

However, the results returned from previewing have NULL instead of the expected values.

Reassigning...
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira