Forum: Ruby Ruby DBI transaction support bug?

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.
2b62c9423436f40fefbc632d7dc80706?d=identicon&s=25 Pascal Meunier (Guest)
on 2007-04-27 17:38
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?

A87a69a8f504d5ac04cc77a065dabf86?d=identicon&s=25 Pascal Meunier (pmeunier)
on 2007-04-27 17:54
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 topic is locked and can not be replied to.