Forum Discussion

Roxit_Support's avatar
Roxit_Support
New Contributor
12 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
SmartBear Alumni (Retired)
12 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
    7 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.

     
     
     
    • BrennaLanhart's avatar
      BrennaLanhart
      New Contributor
      7 years ago

      I have the same issue. I run an update statment to my database using a data connection step and then have another data connection step to commit the update. AFter that, I execute a command that generates a file based on the update to the DB, but it never reflects the update. As soon as the entire test case is finished running, then the update takes place. Is there a way around this or somehting that I am missing to make it update as soon as the statement is run?