Rails testing with sqlite

Just a quick note with an answer to an issue which has been bugging me for days.

The problem

Tests run OK within Eclipse but fail miserably from the command line with an error like…

Started
...E
../lib/sqlite3/errors.rb:94:in `check': cannot rollback - no transaction is active (SQLite3::SQLException)

The diagnosis

It seems that the test runner automatically loads fixtures even if not asked to do so. The template fixture files contain stubs for test records which cause sqlite3 to choke.

The solution

Just make sure that fixture files actually contain real fixtures that are needed for your testing!