• Post Reply Bookmark Topic Watch Topic
  • New Topic

Stored procedures in Servlets and Session  RSS feed

 
Raghavendra Joshi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I want to kknow if i am executing a stored procedure from the servlet and the stored procedure takes 1 hour or more to complete its job then what do i have to show the user in the front end and till the stored procedure executes the session will expire or not?
Please let me know ASAP.
Thanks in advance
 
Chris Mathews
Ranch Hand
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a classic case for asynchronous processing using JMS. I definitely would never consider executing a procedure that takes upwards of an hour in a Servlet, that is crazy.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!