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

Recent Discussions

NPE trying to get StatisticVariable

ReadyAPI 3.60.0 returing errors for postgres JDBC steps

SSL Preferences: keystore with multiple certs

Related Content

If-else statement

Duplicate gherkin statements

NameMapping issues after IF Object statement returns false?