mani_tapori
15 years agoOccasional Contributor
DB query works fine when testcase is run individually but fails othewise
Hi Everyone,
I'm trying to figure out a peculiar issue that I'm facing. I'm using SoapUI 2.5 beta1 PRO version. In my test case, I'm querying a few tables in the DB and everything works great when the test case is run individually. But when I run a few cases in loop, one of my SQL query returns blank result.
I'm creating the query dynamically using some values from Properties. I've checked and printed the SQl query before it is executed and query is being correctly formed. Also, I've tried putting in 'Delay' steps to make sure it gets sufficient time to execute. Also. after the test case execution, if I run the query manually it returns correct result. It just gives blank output when the test case is executed in conjunction with others. What might be the issue? Any help will be greatly appreciated.
Regards,
mani.
I'm trying to figure out a peculiar issue that I'm facing. I'm using SoapUI 2.5 beta1 PRO version. In my test case, I'm querying a few tables in the DB and everything works great when the test case is run individually. But when I run a few cases in loop, one of my SQL query returns blank result.
I'm creating the query dynamically using some values from Properties. I've checked and printed the SQl query before it is executed and query is being correctly formed. Also, I've tried putting in 'Delay' steps to make sure it gets sufficient time to execute. Also. after the test case execution, if I run the query manually it returns correct result. It just gives blank output when the test case is executed in conjunction with others. What might be the issue? Any help will be greatly appreciated.
Regards,
mani.