Re: Log off from web client, when log off from application!!! HELP

Frank,

Thanks for the info...

But how would I use a session cookie?!?

Frank <fbortel_at_home.nl> wrote in message news:<3DF8F5C0.5040502_at_home.nl>...
> Brij M wrote:
> > Hi All,
> >
> > I am at my tether's end...Please help me! I raised a iTAR on this
> > issue and received no help, and I cannot possibly imagine that someone
> > has not come across this before??!?!
> >
> > We are currently attempting to provide log-off functionality within
> > our
> > application which uses the mod_plsql gateway to access the app via a
> > browser.
> >
> > We know that when the browser is closed we can trigger an alter system
> > disconnet session command to disconnect the session, however the
> > problem is
> > that the ie5.5 to mod_plsql connection seems to persist, as when i
> > next try to
> > log on i get a 'your session has been killed error' and the following
> > time i
> > get a 'not logged on' error untill i physically restart the httpserver
> > service.
> >
> > What I need to know is
> >
> > a) is there a different method instead of alter system
> > kill/disconnect session that i should be using to log off users, or is
> > there a
> > way in mod_plsql for me to end the web client (browser) to web server
> > (http
> > server/mod_plsql) whenever a user logs off.
> >
> > I know that I can switch connection pooling off for the database
> > access descriptor, but this will cause serious performance
> > degredation, so is not really an option.
> >
> > Is there something I can do in Apache torefresh the authentication!?!?
> >
> > Your help is appreciated.
> >
> > Thanks in advance,
> >
> > Brij
>
> You can't have your cake and eat it. DAD connection pooling is
> doing exactly what you do not want - keeping open the database
> session (until timed out - 15 minutes later).
> Are you using basic authetication, and apache RequireValidUser?
> Else - use a session cookie, and remove that when "disconnecting".
>
> Grtz, Frank
Received on Mon Dec 16 2002 - 09:57:51 CET