Subject:WSDL's, XML Mappings To DB fields, and Code Generation Author:Richard Herring Date:28 Sep 2006 01:16 PM
I am new to Stylus and after watching the Seminar today, I have a few questions.
In a current project were using Progress/Webspeed and SonicMQ to do web services. We are using Stylus to verify the WSDL and that we can hit the web service in question and get good responses for various inputs.
A time consuming part of the process is mapping the XML fields to database fields in the request and in the response. For small WSDL's it is not that bad, but for large ones it takes quite a while.
Overall process: Web request via Webspeed, d.b. fields turned into XML, SOAP header and SOAP trailer is wrapped around the XML and shot off to SonicMQ for processing.
Can Stylus be used to generate a piece of code or a map that be called eternally by another language ?
It would like this: A developer would connect to the Progress database table (how about a temp table definition ?) and map the WSDL to the a table. The code/map that would get produced would be used by an external function/internal procedure in the request flow.
New Process flow: Web request via Webspeed, d.b. fields are sent to code/map and an XML package returned, SOAP header and SOAP trailer is wrapped around the XML and shot off to SonicMQ for processing.
How would a map work that required more than one level of detail ? PO Hdr / multiple PO detail lines ?