RE: Transactioning with MySQL

Thomas Fischer <[email protected]> Thu, 8 Oct 2009 07:32:01 +0200

Newsgroups	gmane.comp.jakarta.turbine.torque.user
Message-ID	<OFC43D4939.81E0D3C5-ONC1257649.001E0757-C1257649.001E6701@seitenbau.net>

> Can someone explain why my transaction is being committed on
> loc.save(connection) when it should be rolled back?
> ...

- Check that you use a mysql engine that supports transactions (the default
engine MyISAM does NOT support transactions)
- check that autocommit is set false in your database properties (you can
also use connection.getAutocommit() to check)
- If that still does not work (which I doubt), please debug into the Torque
code and check when the commit occurs.

   Thomas