I managed to get this working yesterday on one of our projects.
I’ve written up detailed explanation here[1]
I hope this is of some use to someone else; let me know either way
(especially if I’ve screwed up).
Chris
[1]
http://blog.seagul.co.uk/articles/2006/02/08/in-memory-sqlite-database-for-rails-testing