hvo
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to loop row response from JDBC Request to send Soap Request
Hi richie, I really appreciate from your reply. I will answer your questions in sequence. Are you saying that your JDBC step retrieves multiple records which you then want to pass onto the subsequent SOAP step - but currently your test just picks up the first record (row) of data from your query? Answer: Correct so essentially you want your test to cycle through each row of data retrieved in your JDBC response to pass onto the subsequent SOAP step? is that it? Answer: Correct Some questions: Q1. What's the property Transfer step in your 'Initial SOAP Data' test case doing? Is it grabbing the first row of data only (rowNumber1's <CALCULATOR.INTA/> and <CALCULATOR.INTB/> tag values), rather than all of the rowNumber's data? Answer: the property Transfer step is getting the first row of table. I don't know how to get all rows. I have attached the image. Please take a look for me. Q2. Is the number of returned rows constant (never changing)? if not, but you don't need more than x number of rows you can always control the number returned in the JDBC step by adding a clause to your SQL in the JDBC step (you haven't mentioned which RDBMS you're querying and controlling the number of returned rows can be way different depending on your RDBMS - i.e. Oracle you can do it one way (actually many ways), SQLServer uses something top X or i think latest versions support Fetch too, etc.). Answer: I used My SQL Workbench and I don't userstand what you mentioned is "by adding a clause to your SQL in the JDBC step". My test case is that verify the additional of numbers. I configured a table Calculator (id, IntA, IntB) which has 10 rows with different number types (ex: postive or negative numbers, null...) and I want to verify all rows but currently it just get the first row in the table. Q3. whats the 'Datasource' doing in your 'Add 2 Numbers' test case - is it a grid being populated by the property transfer step in your 'Initial SOAP Data' test case? Answer: Correct. I am using Datasource from Excel file. Please see ExcelFile.png attached. Thank you very much, hvo3.4KViews0likes3CommentsHow to loop row response from JDBC Request to send Soap Request
Hi, I am new of ReadyAPI. I have a JDBC Request to get data from table using 2 columns (IntA, IntB). I can put the variable to Soap request to get the first row in the table. But I want to loop all rows to verify many cases. So how can I do it? Thanks,Solved3.6KViews0likes5Comments