AnsweredAssumed Answered

JDBC CA LISA Service Virtualization, how to implement following scenario's in LISA 9.5.1

Question asked by VineetTevetiya on Apr 25, 2017
Latest reply on Apr 25, 2017 by Kumar Gaurav Jain

I have a request.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <Request
         <Name>BruceWayne</Name>
      </Request>
   </soapenv:Body>
</soapenv:Envelope>

 

The response for this is :-

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<soapenv:Body>
      <Response>
         <Superhero>Batman</Superhero>
      </Response>
   </soapenv:Body>
</soapenv:Envelope>

 

 

Now I have a database in which I have following two columns : -

Name                            Superhero

BruceWayne                 Batman

 

How can I implement this query in CA LISA 9.5.1 : - select superhero from Movies where Name='BruceWayne'; ??


How can I pass the the  value which is in request into the SQL query, so that the value I am sending in the response can be read from it ??

Outcomes