Forum: Ruby mysql transactions via ruby

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
Dfa72cc046ba6eb39191414ed210b931?d=identicon&s=25 paolo (Guest)
on 2007-06-06 15:32
(Received via mailing list)
I'm trying to use transactions via "ruby mysql module" but there is no
effect, just like the autocommit mode on.

for example:

    mSql.query("set autocommit=0")
    mSql.query("start transaction")
    mSql.query("insert into TEST values ('ABCD')")

    the record remains in the table.

I'm using Mysql 5.0, Ruby 1.8, table engine InnoDB. The same sql
works fine on mysql console.

any suggestion?
This topic is locked and can not be replied to.