Forum Discussion

newMonk's avatar
newMonk
Occasional Contributor
10 years ago
Solved

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 ...
rupert_anderson's avatar
rupert_anderson
Valued Contributor
10 years ago

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