I'm struggling with why ActiveRecord isn't rolling back my transactions. I've ran the same code at my home machine and it works but on my work machine it doesn't and I'm hoping someone will see the glaringly obvious configuration problem that I can't see. I can connect to the database and perform actions just fine.
I'm running Ruby on Windows XP and connecting to SQL Server 2005.
ruby 1.8.6 (2008-08-11 patchlevel 287) [i386-mswin32]
gem list --local
*** LOCAL GEMS ***
actionmailer (2.3.5, 1.3.6) actionpack (2.3.5, 1.13.6) actionwebservice (1.2.6) activerecord (2.3.5, 1.15.6) activerecord-sqlserver-adapter (2.3) activeresource (2.3.5) activesupport (2.3.5, 1.4.4) autotest (4.2.3) dbd-odbc (0.2.4) dbi (0.4.1) deprecated (2.0.1) echoe (4.1) ezcrypto (0.7.2) fxri (0.3.7, 0.3.6) fxruby (1.6.16) gemcutter (0.3.0) hpricot (0.6.164) json_pure (1.2.0) log4r (1.0.5) mocha (0.9.8) ptools (1.1.6) rack (1.0.1) rails (2.3.5, 1.2.6) rake (0.8.7, 0.8.1) ruby-opengl (0.60.0) rubyforge (2.0.3) rubygems-update (1.3.5) rubyzip (0.9.1) test-unit (2.0.1) thoughtbot-shoulda (2.10.2) win32-api (1.2.1, 1.2.0) win32-clipboard (0.4.4) win32-dir (0.3.2) win32-eventlog (0.5.0) win32-file (0.5.5) win32-file-stat (1.3.1) win32-process (0.5.9) win32-sapi (0.1.4) win32-sound (0.4.1) windows-api (0.2.4) windows-pr (0.9.3)
The script I'm using to test transactions is:
class TestRollback < ActiveRecord::Base end
ActiveRecord::Base.establish_connection( :adapter => 'sqlserver', :username => 'user', :password => 'pass', :database => 'testdb', :host => 'localhost' )
TestRollback.transaction do TestRollback.create(:name => 'Test') raise ActiveRecord::Rollback end
TestRollback.find(:all) # returns [#<TestRollback name: "Test">]
The only difference between this configuration and my one at home is I don't have version 1.15.6 of the activerecord gem installed on my home machine. However, this script needs to use that version of activerecord because of some legacy code that I inherited and haven't had a chance to rewrite. I'm hoping there's a way around this without having to rewrite the code.