MySQL can handle multiple database transactions in a single connection as well.

The problem is that Class::DBI is forcing multiple connections, thus preventing the transaction from working properly.