Unlocking db objects in Session end

[Sundararajan]

Dear Folks,
in my web page i am locking some table, in DB. and i take care to
unlock it when a log out button is clicked before the session is abandoned.
however
if the page user, closes the browser window instead of clicking hte log out
button it does not work. will the code work if put in session end. but it
seems that it does not work. please suggest me some other way to achieve the
same.
Thanx in advance.
regards,
--
S.Sundararajan

[tperri]

Sundararajan,

It does work if you put the code in Session_End. However, if you do not
explicity set the Session.Timeout, the default is 20 minutes. So, your code
in the Session_End won't excute until there is 20 minutes of inactivity on
that session.

HTH
T

"Sundararajan" wrote:

Dear Folks,
in my web page i am locking some table, in DB. and i take care to
unlock it when a log out button is clicked before the session is abandoned.
however
if the page user, closes the browser window instead of clicking hte log out
button it does not work. will the code work if put in session end. but it
seems that it does not work. please suggest me some other way to achieve the
same.
Thanx in advance.
regards,
--
S.Sundararajan

[Andy Fish]

as a follow up I would say it's a really bad idea to leave a database table
locked between requests. you have no idea what the user is going to do or
how long it will take him to respond.

obviously I can't comment on your specific application, but I would
generally try to avoid this scenario

Andy

"tperri" <tp****@discussions.microsoft.com> wrote in message
news:43**********************************@microsof t.com...

Sundararajan,

It does work if you put the code in Session_End. However, if you do not
explicity set the Session.Timeout, the default is 20 minutes. So, your
code
in the Session_End won't excute until there is 20 minutes of inactivity on
that session.

HTH
T

"Sundararajan" wrote:

Dear Folks,
in my web page i am locking some table, in DB. and i take care to
unlock it when a log out button is clicked before the session is
abandoned.
however
if the page user, closes the browser window instead of clicking hte log
out
button it does not work. will the code work if put in session end. but it
seems that it does not work. please suggest me some other way to achieve
the
same.
Thanx in advance.
regards,
--
S.Sundararajan