Re: Transaction Errors

From: Rudy Lippan (rlippan_at_remotelinux.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 14:56:37 -0500 (EST)
To: Mike Blezien <mickalo@frontiernet.net>

On Tue, 30 Mar 2004, Mike Blezien wrote:

> Hello,
>
> I keep getting this error when attempting to utilize a database that has Innodb
> tables, and using transactions. This is from a Perl/DBI script too:
>
> Error:
> Transactions not supported by database at module..... bla..bla
>

What version of DBD::mysql are you using?

>
> MySQL Version: 4.0.17-standard - Official MySQL-standard binary
> and it has innodb enabled, the autocommit is set to 1 on the inital 'connect',
> no errors, then when the transaction is executed, the autocommit is set to 0
> until the commit is called, of if an error occurs, the rollback is called.
>
> Is there something in the variables I can check to make sure transaction have
> been enabled for this particular database ??
>

You can use transactions with non-innodb tables, IIRC. You will just get
warnings on rollback.

Rudy

Relevant Pages

  • Re: Scope of transaction processing wrapper
    ... Just pass the Database variable, and it will all rollback. ... This article illustrates transactions: ... My question is on the scope of what transaction ...
    (comp.databases.ms-access)
  • Re: global synchronization point
    ... I'm not thinking of the transaction begin/commit/rollback cycle, ... and rollbacks, and then do a global rollback to a given point of time. ... If you perform database+transaction log dumps for your database ... For ASE servers, @@verion is a server-wide, global variable that ...
    (comp.databases.sybase)
  • Re: Calling BeginTrans without Commit / RollBack
    ... That is correct, rollback is guaranteed ... > locks acquired by the transaction. ... >> Will there be any negative impact on the database if one ... >> commit/rollback commands, e.g. a sudden blackout. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Calling BeginTrans without Commit / RollBack
    ... > rights.Please do not send email directly to this alias. ... >> think sql server should rollback the transaction itself and release any ... >> locks acquired by the transaction. ... >> left on the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Update and Inserting Dataset
    ... The transaction is not a problema, all this process occurs within a ... My process does a rollback if anything goes wrong, ... >>I am using datasets and the command builder to update my database. ... But in the update method what can I do?, If I remove and add the ...
    (microsoft.public.dotnet.framework.adonet)