I am trying to use
ActiveRecord::Base.transaction. I figured that rollback doesn't work by default using Rails 1.2.6 and mysql 5.0. Playing with it a little bit more I found out that
autocommit is not set to 0 in mysql connection.
1) How do I disable autocommit in rails for all connections?
2) Will it have some negative impact on the other code that doesn't have to be transactional?