I have just started a Rails site. I got SQLite3 working sooner than
MySQL, so I went with the former.
Then I ran 'rake test', and received major spewage, including this:
cannot rollback - no transaction is active (SQLite3::SQLException)
Then I installed Salted Hash Login Generator, and README_USER_LOGIN
"Whatever DB you use, it must support transactions.
If it does not, the functional tests will not work properly..."
Then I googled for SQLite's situation, and got this:
"Although SQLite parses named transactions, the names are ignored.
SQLite does not support nested transactions."
So which is it? Will SQLite3 work, and support the functional tests, or
do the functional tests require named or nested transactions? Or is
something else going on?