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

[pje at eby-sarna.com]

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

Modified Files:
	PEAK: CHANGES.txt
	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
'cx_Oracle.serializable'.


To view diffs of this commit, you can use the following URL(s):
http://cvs.eby-sarna.com/PEAK/CHANGES.txt.diff?r1=1.129&r2=1.130
http://cvs.eby-sarna.com/PEAK/src/peak/storage/SQL.py.diff?r1=1.67&r2=1.68

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.