Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / July 2005

Tip: Looking for answers? Try searching our database.

Unlocking db objects in Session end

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sundararajan - 22 Jul 2005 05:04 GMT
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,
Signature

S.Sundararajan

tperri - 22 Jul 2005 09:15 GMT
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

> Dear Folks,
>      in my web page i am locking some table, in DB. and i take care to
[quoted text clipped - 6 lines]
> Thanx in advance.
> regards,
Andy Fish - 22 Jul 2005 09:41 GMT
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

> Sundararajan,
>
[quoted text clipped - 20 lines]
>> Thanx in advance.
>> regards,

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.