Re: rollback on disconnect

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 5 Mar 2001 09:12:41 +0100
Message-ID: <ta6ifuartinff5@beta-news.demon.nl>

"Marcin Buchwald" <velvet_at_gazeta.pl> wrote in message news:3AA345C1.45E5F8FC_at_gazeta.pl...
> In ora817ntee sqlplus the default behavior is to commit on disconnect.
> So is in oo4o.
>
> How to enforce rollback on disconnect behavior?
>
> I need it for error handling. My users often shuts down
> their workstation durning processing transactions.
> Transactions are short but they sometimes got to reboot in wrong time...
>

If they just close the application (so leave illegally) PMON will roll back their current transaction automatically. In Oracle 8i you could consider to write an 'on logoff' trigger, which will perform the rollback for you.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Mar 05 2001 - 02:12:41 CST