Re: [Javtools-poolmngr] Craching server

[Isabelle M. <met...@pa...>]

Let's look at 3 scenarios :

(1) no crashes, but user forgets to commit their transaction. I'm saying
that's their problem.
(2) the user returns a connection to the pool and has forgotten to commit.
We should rollback.
(3) the client crashes - we need to find out whether the database will
notice and close the connection.Besides, there's no good way for us to know
that the client is no longer there, aside from implementing a heartbeat.

Isabelle

----- Original Message -----
From: "Stefaan Delanghe" <st...@ya...>
To: "Isabelle Muszynski" <met...@pa...>
Sent: Wednesday, July 31, 2002 9:26 PM
Subject: Re: [Javtools-poolmngr] Craching server


> I don't know what you mean with this. This issue taks about
> the application interupts which have nothing to do with the
> cache manager.
>
> Stefaan
>
>
> --- Isabelle Muszynski <met...@pa...> wrote:
> > I don't think the cache manager should commit or rollback, this is the
> > domain of whomever borrowed the connection from the pool. At most you
should
> > always rollback for in case they forgot to either commit or rollback.
> >
> > Isabelle
> >
> > ----- Original Message -----
> > From: "Stefaan Delanghe" <st...@ya...>
> > To: <jav...@li...>
> > Sent: Wednesday, July 31, 2002 3:54 PM
> > Subject: [Javtools-poolmngr] Craching server
> >
> >
> > >
> > > I though of another issue which may occure during the execution of
> > transactions.
> > >
> > > When a user request a transaction and this is being executed
(connection
> > taken) it
> > > could be that the user interupts the complete application (for example
> > craching pc
> > > or closing a web browser).
> > >
> > > This means that a transaction is executed while this is not neccessary
> > anymore for
> > > the user who requested it.
> > > In light of this matter the transaction MAY NOT be executed since the
> > application
> > > terminated in a abnormal manner.
> > >
> > > This occurence happens the most on a web application.
> > >
> > > For example:
> > >
> > > user request jsp page which executes several statements.
> > > But click on the stop button or closes the window.
> > > Then the transactions on the requested jsp page may not be executed.
> > >
> > > Your comments
> > >
> > > Stefaan
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > =====
> > > Stefaan Delanghe
> > > ICQ: 110055343
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Health - Feel better, live better
> > > http://health.yahoo.com
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by: Dice - The leading online job board
> > > for high-tech professionals. Search and apply for tech jobs today!
> > > http://seeker.dice.com/seeker.epl?rel_code=31
> > > _______________________________________________
> > > Javtools-poolmngr mailing list
> > > Jav...@li...
> > > https://lists.sourceforge.net/lists/listinfo/javtools-poolmngr
> > >
> >
>
>
> =====
> Stefaan Delanghe
> ICQ: 110055343
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
>