Re: Log off from web client, when log off from application!!! HELP
From: Frank <fbortel_at_home.nl>
Date: Tue, 17 Dec 2002 11:01:18 +0100
Message-ID: <3DFEF5EE.9080501_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
>
Date: Tue, 17 Dec 2002 11:01:18 +0100
Message-ID: <3DFEF5EE.9080501_at_home.nl>
Brij M wrote:
> 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
>
owa_util.get_cgi_env(http_cookie) and
PlsqlCGIEnvironmentList http_cookie='a distinct value';
Check tahiti.oracle.com for more docu.
Grtz, Frank Received on Tue Dec 17 2002 - 11:01:18 CET