Forum Discussion

dumbuser's avatar
dumbuser
Occasional Contributor
6 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
    6 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