[Zope-DB] TPC for ZOracleDA
chris at simplistix.co.uk
Mon Nov 3 18:12:54 EST 2003
Matthew T. Kromer wrote:
> Having said that, if you want to monkey with the DA code a little bit,
Well, I'm monkeying a lot now, so would be good to do this...
> there IS support for two-phase commit in DCOracle2, just not in
> ZOracleDA. What you'll need to do is catch the tpc_vote call and then
> do a connection.prepare(),
so, something akin to:
> and then I think you also need to change the
> connection.commit() to connection.commit(twophase=1) [n.b. I'm not sure
> if you don't have to commit twice, once with twophase=1 and once without].
How can I find out what code needs to be called in tpc_finish()?
> The tpc_vote phase is allowed to raise an error, and the
> connection.prepare() should see that the connection to Oracle is down
> just like the commit/rollback sees.
More information about the Zope-DB