> The default table handler in MySQL is MyISAM which doesn't support > transactions. InnoDB does support transactions.
Ahh, that makes sense, the tables in question are MyISAM. Thanks for the input. - jake On Wed, Jun 25, 2008 at 12:31 PM, James Dempster <[EMAIL PROTECTED]> wrote: > For transactions to work on MySQL the table handlers is required to support > transactions. > > The default table handler in MySQL is MyISAM which doesn't support > transactions. InnoDB does support transactions. > > Double check that you are using a table handler that supports transactions. > > /James Dempster > > On Wed, Jun 25, 2008 at 4:56 PM, Jake McGraw <[EMAIL PROTECTED]> wrote: >> >> Here's the code: >> >> http://rafb.net/p/GEpl5468.html (Code paste site) >> >> My problem is that the first insertion is always successfully >> committed to the database, even when I throw an exception. I've read >> up on the way pdo_mysql handles "transactions", none of my code >> performs any task on DDLs, so my question is: >> >> Does Zend_Db using pdo_mysql support transactions? >> >> - jake > >
