Forum Discussion

n_earnshaw's avatar
n_earnshaw
New Contributor
5 years ago
Solved

Can SOAPUI Pro only handle 1 Table Variable in a SQL Query used to Gather Data for my test

Hi All   I'm a newbie to SOAPUI Pro so please be gentle :-)   I’m using SOAPUI Pro and trying to run a Data driven test where we connect to a SQL Database and retrieve some data to then use i...
  • n_earnshaw's avatar
    n_earnshaw
    5 years ago

    Hi NBorovykh 

     

    Thanks for the extra info.  After speaking with our dev it actually turns out that the issue was that we are trying to do more than 1 insert into our table variables. 

     

    We found that when we did more than one insert, it didn't work but when we got this down to one insert it worked. 

    It might be a limitation with JDBC? We'll continue to have a dig around.  AS you guys have said, it doesn't sound like a limitation of SOAPUI.......