mysql transactions via ruby

P

paolo

Hi,
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')")
mSql.query("rollback")

the record remains in the table.


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

any suggestion?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top