Attempts to disable auto-commit mode in Perl using the DBI command
$dbh->{AutoCommit} = 0; returns the following message, "Transactions not
supported by database".
I am using the latest version of MySQL-Max (3.23.51) as well as the latest
version of DBD::mysql.
Executing the following command at the mysql prompt verifies that BDB
Transaction enabled tables are supported and turned on.
mysql> SHOW VARIABLES LIKE "have_%";
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_bdb | YES |
| have_gemini | NO |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
+---------------+----------+
6 rows in set (0.00 sec)
Executing SET AUTOCOMMIT=0; at the mysql prompt works fine as well. However,
I can not get Perl scripts to recognize the disable auto-commit command.
These symptoms are occurring in a Linux/apache web server as well as a
Windows 2000 environment running as "localhost".
Any suggestions would be greatly appreciated.
