Re: Transaction Errors

From: Mike Blezien (mickalo_at_frontiernet.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 14:18:08 -0600
To: Rudy Lippan <rlippan@remotelinux.com>

I think this maybe the problem,... I didn't realize that the DBI version was so
old... this is on a client's server which I don't have root access too:

Versions:
DBI: - 1.14
DBD::mysql: - 2.0415

Does the DBI module need to be updated ??

TIA 

-- 
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: mickalo@thunder-rain.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Rudy Lippan wrote:
> 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: ADOBD / JET Transaction Problems
    ... I think it's probably more relevant to post the transaction-related code ... > using ADODB to open the database to use record level locking. ... > Rollback, the Rollback does not Rollback the transactions - all 3 are ...
    (microsoft.public.vb.database.dao)
  • Re: ADOBD / JET Transaction Problems
    ... I think it's probably more relevant to post the transaction-related code ... > using ADODB to open the database to use record level locking. ... > Rollback, the Rollback does not Rollback the transactions - all 3 are ...
    (microsoft.public.data.ado)
  • Re: Perl, DBI, and Transactions
    ... When I do a rollback, Informix tells me that I'm not in a ... out how to get a version of the DBI and DBD we're using... ... using different database connections. ...
    (comp.databases.informix)
  • Re: Using SqlTransaction with MSSQL Trans?
    ... I believe you will get separate transactions and transaction from the ... application will not be able to rollback changes in a database. ... Val Mazur ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Do Transactions guard against corruption?
    ... when the database is opened and closed. ... meant by 'corruption'. ... Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ...
    (microsoft.public.access.modulesdaovba)