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

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 Thu Dec 12 2002 - 21:46:56 CET