java - Prevent session timeout during database update -

-

background

a web application calls stored procedure perform intensive database update. relevant portion of web.xml updated 4 hours:

<session-config>     <session-timeout>240</session-timeout> </session-config>

the technologies available solution include java 1.4.2, struts 2, tomcat 5.5, , apache commons. other technologies (such jquery) not permitted.

problem

the update takes hour run, configuration value of 4 hours against corporate standards (for reason). 4 hour timeout configuration not permitted in production.

question

what ensure request not time out while database update executes?

ideas

my concern in first 2 cases spawned process killed servlet container.

page refresh

  1. spawn database update process background task.
  2. have servlet continually refresh page check completion.

javascript ping

  1. spawn database update process background task.
  2. have javascript code ping server while.

similar preventing session timeout during long processing time in jsf, without jquery.

update server

write simple server listens requests:

  1. the servlet sends request listener.
  2. the listener runs update.

since server runs independently of tomcat, session timeout cannot occur. database update run completion without being killed. has numerous issues (error handling not least of concern) , option of last resort.

optimization

optimizing query finish in under 30 minutes (the maximum permitted timeout) possible, query cannot optimized sufficiently.

hardware

upgrading database hardware not option, unfortunately.

many thanks!

in opinion, no user want sit in front of screen monitoring background job 4 hours. few years ago, had implement report generation took hours. implemented solution following:

  • generate report in background thread. thread monitored , available via application context list. thread contained information owner , progress.
  • users can list own threads , see progress.
  • upon completion report thread store report offline access, send email notification owner link download generated report.

Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more