In summary the aim of this part of an end to end test in SOAPUI NG is to run a SQL statement 5 times (and then stop) for the 5 different values in the Datasource and capture the data.
I have the below steps setup as part of a test case:
1) Datasource - Excel
2) JDBC Request - uses a SQL server driver to run a SQL statement. In the SQL statement the where clause is populated from the Datasource in step 1 (uses a field called Tracking Number)
3) Datasink - is setup to capture a number of datapoints from the SQL JDBC request
4) Datasourceloop - to loop back to the JDBC request again
However when I run it ...it loops to run the 5 queries as required then continues to loop around and runs SQL time. In the Datasink the datafield I am using for the where clause is being captured to <trackingnumber>. I have attached some screenshot to illustrate what I mean by this.
can anyone help please?
Solved! Go to Solution.
That is the issue, I don't understand why it is still running the SQL with no tracking number an additonal number of time. I was only expecting it to loop 5 times and this to be reflected in the DataSink i.e not show the blank tracking numbers just the 5
(Note that in the Datasource options I have put in a start row of A1 & an end row of A5)
I have just tried this by using a grid datasource which i have populated manually and this does not have an issue. The problem appears to be with using excel as a datasource for a JDBC request
Hi Rao, any ideas why this is an issue for excel but not grid? I really need to be able to use a excel datasource