Details
-
Bug
-
Resolution: Done
-
Blocker
-
7.7.1
-
None
Description
I've got a deployed WAR which queries just fine through soapUI.
I've modeled it in Designer and am trying to preview the data. All I get
is column headings. After deploying the VDB, I get the same results from SQuirreL when I query:
SELECT * FROM (EXEC getSuppInfo(SUPPLIER_ID='S105', PART_ID='P305')) c
The soapUI request and response are below.
This request:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sup="http://www.metamatrix.com/SuppInfo_Input"> <soapenv:Header/> <soapenv:Body> <sup:SuppInfo_Input> <!--Optional:--> <SUPPLIER_ID>S104</SUPPLIER_ID> <!--Optional:--> <PART_ID>P305</PART_ID> </sup:SuppInfo_Input> </soapenv:Body> </soapenv:Envelope> Should respond with: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <SuppInfo_Output:SuppInfo_Output xmlns:Q1="http://www.metamatrix.com/metamodels/SimpleDatatypes-instance" xmlnss="http://www.w3.org/2001/XMLSchema" xmlnssi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SuppInfo_Output="http://www.metamatrix.com/SuppInfo_Output"> <SuppInfo_Output_Instance> <SUPPLIER_ID>S104</SUPPLIER_ID> <SUPPLIER_NAME>Adams</SUPPLIER_NAME> <SUPPLIER_STATUS>10</SUPPLIER_STATUS> <SUPPLIER_CITY>Atlanta</SUPPLIER_CITY> <SUPPLIER_STATE>GA</SUPPLIER_STATE> <PART_ID>P305</PART_ID> <QUANTITY>100</QUANTITY> <SHIPPER_ID>20</SHIPPER_ID> </SuppInfo_Output_Instance> </SuppInfo_Output:SuppInfo_Output> </soap:Body> </soap:Envelope>
Ted Jones sees a problem with namespace declarations.
Attachments
Issue Links
- is related to
-
-
- Closed
-
