Forum Discussion

IBaxter's avatar
IBaxter
Occasional Contributor
10 years ago

Is this still true that you can only run a single statement per JDBC step?

REST API I create users via API and have to drop them after that so that this scenario can be automated. POST user makes entiries into four different tables. So I have to create four JDBC steps? O...
IBaxter's avatar
IBaxter
Occasional Contributor
10 years ago

I don't care about assertion of this step. This is not a testing step. This is a maintanance step.

nmrao's avatar
nmrao
Community Hero
10 years ago
Kindly note that, soapUI is tool for testing. And not sure what is maintenance step, not heard of it.
  • IBaxter's avatar
    IBaxter
    Occasional Contributor
    10 years ago

    If you need to test an API that creates an user. And you need to automate this step -  how are you going to get rid of this user at the end of you test? You need to add steps to do cleanup, to delete your user. That is what I call 'mainantanance' steps. And because users's properties are written in several tables - I have to delete it from several tables meaning create several sql statements. 

     

    • nmrao's avatar
      nmrao
      Community Hero
      10 years ago
      Ok.
      "Create several sql statements" - You mean, need to have multiple jdbc steps?
      How about having an sql file with all statements that are needed, and run this sql using tear down script of test case or suite (what ever fits you)