in reply to turning off Autocommit (MySql)

$dbh->{AutoCommit} = 0;
But maybe your database did not support transactions.
Boris