Automate Query Execution for multiple rows of data
Hi, In the middle of my test case I need to access the database and execute a query to set the value of a particular field in DB. for a single row i can hard code the userId in JDBC step and ...
Hi,
I think you've answered your own question in another post:
http://community.smartbear.com/t5/SoapUI-Open-Source/How-to-Automate-JDBC-Step/m-p/29442#U29442
As you said there, you would parameterize the update query in the JDBC TestStep using a property expansion.
Alternively, Groovy SQL (http://docs.groovy-lang.org/latest/html/api/groovy/sql/Sql.html) can provide a flexible means to execute SQL queries via a Groovy TestStep.
Let me know if I got the wrong end of the stick and you do need anything.
Thanks,
Rupert
