dcsimg
Long Back End Transaction
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   mario_mario
Posted On:   Wednesday, January 20, 2010 09:26 AM

Hello everybody, I am looking for solutions regarding the problem explained below: I have a three tier( web server, application server and database) application. The web tier uses servlets and the middle tier is using Spring for the business logic. One of the servlets is triggering a very long backend process which is using an Oracle database. It takes more than 3-6 minutes for this process to complete and the answer to return back on the web tier. There is nothing I can do to speed up this long process. The problems that I currently facing are: Sometime the web server times out,because the application server   More>>


Hello everybody,



I am looking for solutions regarding the problem explained below:

I have a three tier( web server, application server and database) application.

The web tier uses servlets and the middle tier is using Spring for the business logic.

One of the servlets is triggering a very long backend process which is using an Oracle database.

It takes more than 3-6 minutes for this process to complete and the answer to return back on the web tier.


There is nothing I can do to speed up this long process.



The problems that I currently facing are:


  • Sometime the web server times out,because the application server takes more time to answer than the time-out interval set on the web server (the current value is 5 minutes)
  • Even in the scenario in which the application server manages to send back the answer in less than 5 minutes, it is still very anoying for the user to wait for such a long time



Therefore I am looking for a solution to avoid the user to wait for such a long time after he starts the back end process.

Currently I am thinking to the following solution:

Instead of the servlet calling the middle tier object which performs this long task,
the servlet could send a message to a queue and have a Message Drive Bean to start the backend process.



Still I would like to know if anybody else has faced the same problem and how did you address it.




Thank you very much in advance and kind regards,
Mario



   <<Less

Re: Long Back End Transaction

Posted By:   Anonymous  
Posted On:   Monday, February 15, 2010 12:10 PM

yes, as u said its really annoying for user to wait for 5 mins looking at blank.....

If you have flexibility with go with MDB idea..u r lucky.. u can go ahead happily..that solves u problem forever...

Because , for now if u find any workaround to minimize in future logic might take much time due to changes to it....So its better to make tht process asynchronous in my opinion.
About | Sitemap | Contact