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 set the value in DB, But it's difficult to for multiple rows of data.
Kindly help.
Thanks
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
