newbee ROLLBACK/ COMMIT

From: Steve A <spectre_at_hkstar.com>
Date: Wed, 11 Aug 1999 18:25:31 +0800
Message-ID: <1dwdxej.1l7vmyh7rb03eN@[201.1.1.73]>

Hi,
I'm a bit confused by the rollback command, I understand the function of commit ,rollback & savepoint

But have the following questions.
1. do I have to use the savepoint command? 2. if my client crashes during the transaction , how long does the "temp changes" sit around or is it dropped when I crash

3. if my client crashes, then re-logs in & then re-does the work and commits , will the server throw away the old crashed session or try to commit it when I issue a commit in a new session.

4. can anybody see any "temp" changes made to the database (including my client) before the commit has been issued.

5. how long between the commit & the changes becomming visible in the database

steve Received on Wed Aug 11 1999 - 05:25:31 CDT