List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:August 14 2002 1:32pm
Subject:Re: Transactions not supported by database - Perl
View as plain text  
Send  the set autocommit=0  just as you send any other query in perl.

Bob Boden wrote:

>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.
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread117020@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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