Re: Question about commit
Date: Sat, 18 Sep 2004 00:43:50 GMT
Message-ID: <Xns9567B45DDEF27SunnySD_at_68.6.19.6>
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in
news:4PmdnevrfIVHc9fcRVn-gw_at_comcast.com:
>
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:Xns956745E1C17DDSunnySD_at_68.6.19.6...
>| Markus Breuer <markus.breuer_at_gmx.de> wrote in
>| news:cie4qd$s30$1_at_pentheus.materna.de:
>|
>| > I have a question about oracle commit and transactions. Following
>| > scenario:
>| >
>| > Process A performs a single sql-INSERT into a table and commits the
>| > transaction. Then he informs process B (ipc) to read the new date.
>|
>| As strange as this may sound PRIOR to issuing the SELECT,
>| Process B needs to issue a COMMIT.
>|
>
> That does sound strange... the only reason for this would be if B is
> in a read-only transaction... (see my other post).
>
> Issuing a COMMIT to see other user's changes is never a requirement.
Never, say "never". ;-)
>
> If B is in a read-only transaction, then a COMMIT or ROLLBACK should
> only be entered when the read-only transaction is completed (per the
> business functionality specification), not as a work around to a
> scenario that is not yet fully analyzed.
>
> ++ mcs
>
>
You are free to disagree & provide proof to the contrary. Received on Sat Sep 18 2004 - 02:43:50 CEST