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

Question

REST APII 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? Or even more if I want to add 'select' steps in between 'delete' to make sure that users were dropped.&nbsp;

nmrao · Answer

Are you surprised with that?If there are multiple queries allowed, how do you assert result?

ibaxter · Answer

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

nmrao · Answer

Kindly note that, soapUI is tool for testing. And not sure what is maintenance step, not heard of it.

ibaxter · Answer

If you need to test an API that creates an user. And you need to automate this step - &nbsp;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.&nbsp;&nbsp;

nmrao · Answer

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)

Forum Discussion

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

5 Replies

Related Content

Duplicate gherkin statements

If-else statement

if statement issue

If ... then else statements

Loop statements

Recent Discussions

How to hit update service multiple time with different data set.

How do I prevent a file path from being altered when being parsed by JsonSlurper in Groovy Script?

Darshan Hiranandani : Exploring ReadyAPI Integration with Azure Git

Multipart requests getting blocked by the Azure WAF 200003

Parameterising JDBC Connection Settings..Can you do it?