Tutorials for Nexial

The Test Automation Platform for everyone!

View project on GitHub

Database Automation

Section 7: UPDATE database

Multiple SQL in one file, update queries can also be named

Transaction Error

transaction lock data

INSERT_new_customer.sql

transaction local script

transaction local output

Suppose there is concurrent access to the same table during the above test execution. This could possibly lead to database failure. In such case, sine we’ve defined our database without autocommit (see the above; myb_update.autocommit|false), error amidst in-progress transaction would rollback such transaction. Here’s how such condition would show up in test result:
transaction local error

Collective Result

rdmbs-07-sql

rdbms-07-multisql_rollback

rdbms-07-multisql_rollback_output

Transaction Support