[ZODB-Dev] Supporting a DataManager without Two Phase Commit

2007-05-04 Thread Laurence Rowe
Hi, Several people have made SQLalchemy integrations recently. SQLAlchemy does not support Two Phase Commit (2PC) so correctly tying it in with zope's transactions is tricky. With multiple One Phase Commit (1PC) DataManagers the problem is of course intractable, but given the popularity of

Re: [ZODB-Dev] Supporting a DataManager without Two Phase Commit

2007-05-04 Thread Andreas Jung
--On 4. Mai 2007 22:33:05 +0100 Laurence Rowe [EMAIL PROTECTED] wrote: Following a discussion with several of the sqlalchemy integration authors on #plone today we came up with the following hack to implement this: http://dev.plone.org/collective/browser/collective.lead/trunk/collective/

Re: [ZODB-Dev] Supporting a DataManager without Two Phase Commit

2007-05-04 Thread Andreas Jung
--On 5. Mai 2007 02:46:58 +0200 Andreas Jung [EMAIL PROTECTED] wrote: If commit fails or another DataManager fails, data is not commited to the database. However I am not sure if this is completely true. Although this approach ensures that all SQL statements were execute properly it does