[
https://issues.jboss.org/browse/TEIID-1835?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1835.
-----------------------------------
Resolution: Rejected
There is no source query that should be executed. You are calling to xmltable to extract
results from the input document. It looks like you are calling the procedure that should
be called on your result document with your input document.
Note that your procedure is defined as:
CREATE VIRTUAL PROCEDURE BEGIN SELECT t.* FROM XMLTABLE( XMLNAMESPACES( DEFAULT
'') ,'/SuppInfo_Output/SuppInfo_Output_Instance' PASSING xml_in COLUMNS
"SUPPLIER_ID" string, "SUPPLIER_NAME" string,
"SUPPLIER_STATUS" bigdecimal, "SUPPLIER_CITY" string,
"SUPPLIER_STATE" string, "PART_ID" string, "QUANTITY"
bigdecimal, "SHIPPER_ID" bigdecimal) AS t; END
So it will successfully extract values from something that has the from
/SuppInfo_Output/SuppInfo_Output_Instance - which of course does not match the input
document.
Querying a table built from WSDL Importer has no source query?
--------------------------------------------------------------
Key: TEIID-1835
URL:
https://issues.jboss.org/browse/TEIID-1835
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4.1
Environment: SOA-P 5.2 GA
Reporter: Paul Nittel
Assignee: Steven Hawkins
Attachments: QueryPlan_WSDL_to_Rel.txt, WsdlRel_CommandLog.txt,
WsdlToRel_MPS.zip
I had previously deployed a Web service and figured I'd import the WSDL to make a
relational model. The Designer process went well. The create procedure, called by: exec
PartsWebXML.getSuppInfo.create_SuppInfo_Input('S106')
generates a result <SuppInfo_Input
xmlns="http://www.metamatrix.com/SuppInfo_Input"><SUPPLIE...
which goes into my query:
exec PartsWebXML.getSuppInfo.extract_SuppInfo_output_Instance('<SuppInfo_Input
xmlns="http://www.metamatrix.com/SuppInfo_Input"><SUPPLIE...)
The result set consists of zeros rows (only column headings). The query plan (attached)
seems to be lacking a source query. The command log entries (also attached) support that
theory, AFAICT.
I'm also attaching the Model Project Set.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira