cancel
Showing results for 
Search instead for 
Did you mean: 

Issues datasource looping for a SQL server JDBC request

SOLVED
Highlighted
Occasional Contributor

Issues datasource looping for a SQL server JDBC request

Hi,

 

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Hero

Re: Issues datasource looping for a SQL server JDBC request

Otherwise, you can try on a different sample excel data source, and see if the behaviour is reproducible without your project artifacts. That will also help in case if you want to take it to SmartBear support team when the issue is persistently reproducible.


Regards,
Rao.

View solution in original post

7 REPLIES 7
Highlighted
Community Hero

Re: Issues datasource looping for a SQL server JDBC request

Not sure, really got the problem being faced.

In the screen shot, it was showing there is no value for TrackingNumber.

May you want to precise the exact issue?


Regards,
Rao.
Highlighted
Occasional Contributor

Re: Issues datasource looping for a SQL server JDBC request

Hi Rao, 

 

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) 

Highlighted
Occasional Contributor

Re: Issues datasource looping for a SQL server JDBC request

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

Highlighted
Occasional Contributor

Re: Issues datasource looping for a SQL server 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

Highlighted
Community Hero

Re: Issues datasource looping for a SQL server JDBC request

Can't comment on it. Because, do not know how it is looping thru the source file in your case. May be you can check the condition or the steps you have in the test case.


Regards,
Rao.
Highlighted
Community Hero

Re: Issues datasource looping for a SQL server JDBC request

Otherwise, you can try on a different sample excel data source, and see if the behaviour is reproducible without your project artifacts. That will also help in case if you want to take it to SmartBear support team when the issue is persistently reproducible.


Regards,
Rao.

View solution in original post

Highlighted
Occasional Contributor

Re: Issues datasource looping for a SQL server JDBC request

This has resolved it  thanks

New Here?
Join us and watch the welcome video:
Top Kudoed Authors