List:General Discussion« Previous MessageNext Message »
From:Bob Boden Date:August 13 2002 10:45pm
Subject:Transactions not supported by database - Perl
View as plain text  
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.

Thread
Transactions not supported by database - PerlBob Boden14 Aug
  • Re: Transactions not supported by database - PerlGerald Clark14 Aug
    • RE: Transactions not supported by database - PerlShao Ming16 Aug
      • Re: Transactions not supported by database - PerlMark Stringham16 Aug
      • email marketing softwareMark Stringham16 Aug
      • Re: email marketing softwareWee Keat16 Aug
      • Re: email marketing softwareCurtis Maurand16 Aug
      • Re: email marketing softwareMark Stringham16 Aug
        • Re: email marketing softwareW. D.16 Aug
      • Re: email marketing softwareCurtis Maurand16 Aug
RE: email marketing softwareArt Fore16 Aug