On Oct 18, 1:38 am, Stefan Rohlfing <[email protected]> wrote: > Hi, > > I have some difficulties getting transaction to work. I wrote a small test > case using RSpec that I expected to result in a complete rollback of all > data already inserted into the database, but in fact there was no rollback:
Most likely the MySQL database you are connecting to uses MyISAM tables by default, which do not support transactions. Switch to a better database such as PostgreSQL if you can. If you can't, pass the :engine=>:InnoDB option to Database#create_table, or change your MySQL server default table engine to InnoDB. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
