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
Have you reviewed the documentation on JDBC Result Sets?
If you want to save the result set to a file:
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.