Contributions
Re: How to loop row response from JDBC Request to send Soap Request
Hirichie, I really appreciate from your reply. I will answer your questions insequence. 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, hvo5 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.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,Solved5 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.4KViews0likes5Comments