E&S CVS Commit: PEAK - Sybase an Oracle: two-phase commit, read-only txns, and serializability.

pje at eby-sarna.com pje at eby-sarna.com
Tue Feb 3 18:53:00 EST 2004

Module Name:	PEAK
Committed By:	pje
Date:		Tue Feb  3 23:52:48 UTC 2004

Modified Files:
	PEAK/src/peak/storage: SQL.py

Log Message:
Sybase an Oracle: two-phase commit, read-only txns, and serializability.

Changed Oracle "outside transaction" semantics to allow read
operations only, and added a property to set Oracle transactions to
"serializable" (which effectively requires two-phase commits).  Note that
the current version of DCOracle2 doesn't properly support two-phase commit
except for empty (no-op) transactions, which isn't very useful.  However,
if a later release of DCOracle2 works correctly and doesn't change its API,
the current PEAK driver should then work correctly.  In the meantime, the
cx_Oracle driver apparently *does* provide working support for two-phase
commits.  The controlling properties are of the form
'DRIVER.twoPhaseCommit' and 'DRIVER.serializable', where 'DRIVER' is the
name of the DBAPI driver module, e.g. 'Sybase.twoPhaseCommit' or

To view diffs of this commit, you can use the following URL(s):

To generate a diff of this commit:
cvs rdiff -r1.129 -r1.130 PEAK/CHANGES.txt
cvs rdiff -r1.67 -r1.68 PEAK/src/peak/storage/SQL.py

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

More information about the source-changes mailing list