Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > If server process is running, return last page state w/ msg AND w/o allowing page code to run (db activity)

Thread Tools

If server process is running, return last page state w/ msg AND w/o allowing page code to run (db activity)

Posts: n/a
Not sure how to go about this?

If we have a sql agent job running, we would like to keep a user from
hitting the database via our web app while this 1-2 minute job runs.
Ideally we could catch this at a higher level (httpmodule or
httphandler ?) and let them know that a job is running.

A user has made a few requests in the app and on their next request for
a page, the app checks to see if the job is running, and if so, returns
the exact same page (state and all) that they were just on with a
message alerting them that the database is offline for processing. At
that point it would try re-submitting the request again for the user or
at least would allow them to try again themselves. A behind-the-scenes
AJAX call would maybe work well here?

I could add some code to my basepage in the init, but I am not sure how
to finish the request but also prevent other events (that may hit the
database) from firing. My only thought is something with an httpmodule
or httphandler. Any help is much appreciated.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Read .msg attachment from a mail(.msg) akila_natarajan Java 0 05-13-2011 07:35 AM
[ANN] ruby-msg-1.3.1 (outlook msg lib) and ruby-ole-1.2.1 Charles Lowe Ruby 0 08-22-2007 01:13 AM
[ANN] ruby-msg-1.2.17 (converter for outlook msg files) Charles Lowe Ruby 0 05-13-2007 06:55 AM
OnBeforeUnload event...where to run code BEFORE return msg? Kathy Burke ASP .Net 0 08-04-2003 06:13 PM
spawnv/spawnl do not return an "R" process state code nushin Python 0 07-29-2003 09:18 PM