How to run multiple SQL(Insert) statements in JDBC Request?
How to run multiple SQL(Insert) statements in JDBC Request?
I am using Ready! API 1.9.0
Forum Discussion
10 Replies
- Well, there are two options.
1. Use data driven approach, run the jdbc step in a loop.
2. The same can be done in single step if groovy script step is used. Please find the sample code snippet:
http://grails.asia/groovy-sql-insert-operation-exampleIf we run the jdbc step in a loop, we are establishing the connection and disconnecting it for each SQL Statement right??
SBK : here's the documentation for Property Expansion. ReadyAPI Property Expansion
You could likely utilize property expansion and a data source to loop through a set of SQL queries.
how to utilize property expansion?
