Re: locks

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 10 Aug 2006 21:26:57 GMT
Message-ID: <J3swwy.FKs@igsrsparc2.er.usgs.gov>

HansF wrote:
> On Thu, 10 Aug 2006 19:37:09 +0200, Sybrand Bakker wrote:
>

>> exiting *normally* will end the database connection and will issue a
>> commit.

>
> I always thought 'exiting *normally* without explicitly issuing a commit'
> will issue a rollback, and the 'commit on exit' syndrome was a 'feature'
> of the calling environment (such as SQLPlus).
>
> Has this changed?
>

It all depends on the application. Some applications will automatically commit while others will automatically rollback...assuming a "normal" exit.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Aug 10 2006 - 16:26:57 CDT