List:General Discussion« Previous MessageNext Message »
From:Arthur Fuller Date:September 14 2002 1:04pm
Subject:Re: BeginTrans - Commit - Rollback on MySQL
View as plain text  
Unless you're using InnoDB or DBB tables, I don't think this can work. MySQL
ignores transaction syntax for MyISAM tables, the same way it ignores
Type=InnoDB in a create table statement if InnoDB is not installed.

Arthur

----- Original Message -----
From: "Christos Vorkas" <mysql@stripped>
To: <    >
Sent: Thursday, September 05, 2002 5:18 AM
Subject: BeginTrans - Commit - Rollback on MySQL


> Hi All,
>
> I am trying to establish a transaction-oriented method of posting
> changes on the MySQL database. I'm using MyODBC 3.51 and VB6.
>
> Using the ADO Controls, I use connection.BeginTrans to start the
> transaction, followed by a series of ado.updates, and finally a
> connection.committrans to close the group.
>
> However, breaking the program before the committrans, and stopping the
> application before the committrans is executed (i.e. trying to simulate
> a crash in the middle of the transaction), should result in NO updates
> done to the MySQL tables, but this is not the case. ALL updates done up
> to that moment have been recorded and finalized in the database.
>
> Any ideas why this is not working as it should?
>
> Any comments much appreciated.
>
> Best regards,
>
> Christos Vorkas
>
> ---------------------------------------------------------------------
> 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-thread118326@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-mysql=cyberia.com.cy@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-thread118775@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-artful=rogers.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
BeginTrans - Commit - Rollback on MySQLChristos Vorkas5 Sep
  • Re: BeginTrans - Commit - Rollback on MySQLArthur Fuller14 Sep