List:General Discussion« Previous MessageNext Message »
From:Shao Ming Date:August 16 2002 12:42am
Subject:RE: Transactions not supported by database - Perl
View as plain text  
I have expereience the same behaviour when using the ppm from
activestate. Try using the one below, seem to work for me...
ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd

-----Original Message-----
From: Gerald Clark [mailto:gerald_clark@stripped] 
Sent: Wednesday, August 14, 2002 9:33 PM
To: Bob Boden
Cc: mysql@stripped
Subject: Re: Transactions not supported by database - Perl


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
>
>



---------------------------------------------------------------------
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-thread117066@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-shaoming=signetique.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