Forum Discussion

dumbuser's avatar
dumbuser
Occasional Contributor
7 years ago

Multiple sql statements in one JDBC step with Oracle

Is there a way to use multiple sql statements with JDBC step while using Oracle database? I can have multiple inserts, updates etc. in one test step while working with Postgres, but with oracle I get...
  • MoUddin's avatar
    MoUddin
    7 years ago

    One way to achieve this is to use a groovy step and script the db queries, you should find the information you need to get started with groovy sql coding in the documentaion here

     

    NOTE: The objects that are returned from the sql query methods are ArrayLists and so to retrieve a specific element (column name) from within the object (sql result object) you would use something like

    object.specificElement

     

    Hope this was helpful,

    Mo

     

    EDIT: You can also find some usage examples here

MoUddin's avatar
MoUddin
Contributor

One way to achieve this is to use a groovy step and script the db queries, you should find the information you need to get started with groovy sql coding in the documentaion here

 

NOTE: The objects that are returned from the sql query methods are ArrayLists and so to retrieve a specific element (column name) from within the object (sql result object) you would use something like

object.specificElement

 

Hope this was helpful,

Mo

 

EDIT: You can also find some usage examples here

dumbuser's avatar
dumbuser
Occasional Contributor
7 years ago

Thanks, this was very helpful. Had to google some other examples as well for my case, but this was probably the best at explaining the principle.