Service Virtualization

Expand all | Collapse all

Store the JDBC result set

  • 1.  Store the JDBC result set

    Posted 05-16-2019 09:29 AM

    Hi All,

     

    I want to store and use the entire JDBC result set. Please find the below requirement.

     

    Based on the SQL query in JDBC step, it'll retrieve the 'n' number of rows. So I want to store the values, and use in further steps. So please help me to achieve it.

     

    Note:- number of rows are dynamic

     

    DevTest Version: 10.3



  • 2.  Re: Store the JDBC result set

    Posted 05-16-2019 10:43 AM


  • 3.  Re: Store the JDBC result set

    Posted 05-24-2019 07:40 AM

    Thanks for your reply Marcy. My requirement is, In a request message the Address details will be triggered to VS, then based on the Address details, it should search the customer details in DB and respond to it. (Note:- the no. of customer details varies with the address. The result set is dynamic). So to achieve this, i tried with the above two methods and didn't get the expected response. Can you please help me to achieve this.