Ruby DBI transaction support bug?

According to “Using the
Ruby DBI Module”, the following rollback should work but doesn’t:

$DBH[‘AutoCommit’] = false
sth = $DBH.prepare(“SELECT * FROM add_user_list(?)”)

where “add_user_list” is a stored procedure that inserts a row in a
table. As a result, user “blahblah” is inserted in the table – the
rollback didn’t work.

However, this works:

sth = $DBH.prepare(“SELECT * FROM add_user_list(?)”)

and user “blahblah” does not get added to the table.

Fun. Should I report this somewhere in particular?


I forgot to mention, this is of course with the last version of DBI,
0.1.1 on ruby 1.8.6 (2007-03-13 patchlevel 0) [x86_64-linux] and

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