Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Ruby Programming Language

mysql transactions via ruby


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

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc