Hey hvo
I'm sorry - I'm struggling to understand from your description
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?
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?
Sounds to me like a JDBC step script assertion might do this.....but that's outside my skillset
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?
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.).
Anyway - if you know the number of returned rows in your response you can actually do this a rubbish way (which is what I've done before) - I've created 2 transfers for each row of data returned and then populated a grid datasource to use later - but this only works (and is a tedious, non-elegant way of doing it) if you know the number of rows returned and it's not in the multiples of 10 or 100s as thats a rubbish inefficient way of doing this.
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?
As I say - I think this is a job for a scripter (and that's completely outside my skillset) - but hopefully the above will clarify your position abit
Cheers,
rich
