> When clients crash, or applications don't take proper care of
> transactions
> when users log out, the server will eventually detect the lost connection
> and any transactions left incomplete will be rolled back There
> is no more
> garbage than usual with rollbacks and it will just be
> garbage-collected in
> the normal course of events.
>
>
> > > Will the server automatically rollback the transaction in both
> > > scenario?
> > >
> >
> >this depends on what component layer you use in your
> application. Most have
> >a default close action - and you can set it to either commit or
> rollback -
> >whichever suits your applciatopin best.
>
> No. Application interfaces can't auto-rollback transactions if the
> connection is lost. The server takes care of the abnormal
> disconnects. There will be a time-lag during which the unfinished
> transactions are just unfinished transactions. The server waits for a
> period of time before deciding that a connection is "dead".
>
> ,/heLen

I was referring to the situation when the application does not take explicit
action on application.close

Alan