Programming the Perl DBI

Rolling Back Changes

The corollary operation to committing data to the database is to roll it back. The DBI defines a method called rollback(), which can be used to roll back the most recent uncommitted database changes.

Like commit(), the rollback() method is executed against a database handle:

$dbh->rollback();

Similarly, if rollback() is invoked while AutoCommit is enabled, a warning will be displayed similar to:

rollback ineffective with AutoCommit

signifying that the database changes have already been committed. This warning will also be displayed when rollback() is invoked against a database that has no transaction support because, by definition, AutoCommit will be enabled.