Transaction support in Zend_Db

[Andrew Sledge]

Hi all,

I was wondering if there were plans to incorporate more robust transaction interfaces in Zend_Db.  It seems like with the plethora of database adapters available, one would want the ability to programmatically create transactions rather than writing the raw SQL for it.  Does anyone know if such a way exists (and I have just been overlooking it) or if there are plans to incorporate it?

--
Andrew Sledge

[Bill Karwin]

Andrew Sledge wrote:

I was wondering if there were plans to incorporate more robust transaction
interfaces in Zend_Db.

Methods to begin and commit or rollback transactions have been part of Zend_Db from the beginning.

http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.transactions

If you're talking about fancier features like checkpoints and nested transactions, this has been proposed, but since not all brands of database support them and there's no safe way to emulate them without database support, the proposals were rejected.

Regards,
Bill Karwin