Mysql transactions via ruby

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 forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs