Forum Discussion

Roxit_Support's avatar
Roxit_Support
New Contributor
13 years ago

[Resolved] commit my delete statement in JDBC step

when i run my JDBC steps with content like: "delete from domain_object where id in (select id from zaak where extern_zaaknummer = :extern)" the records are still available. When i run the queries ...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
13 years ago
Hi,

No, there is no way to automatically delete data created by previous test steps.

One thing that you could check is if you have accidentally turned off auto-commit mode. It should be on by default which means that no commit step would be necessary.

Some JDBC drivers can set the auto-commit mode in the JDBC connection string, you could check the documentation for your driver to see if that is possible.
If not, you probably have to use separate test steps for commits.

Regards,
Anders
SmartBear Sweden
tomptomp's avatar
tomptomp
Occasional Contributor
8 years ago

Talk to me about auto-commit.  It is a setting in ReadyAPI-Soapui?  when i run an update sql statement, then, in a different test step, i run a select to verify that the update committed, it fails verification, until the testcase completes.  so it seems that the commit doesn't 'commit' until after the soapui runtime is complete.