I must do an application J2EE to execute stored procedures, that is a hugh problem, because I really know how can I do that, but my question is the following one:
There are stored procedures that delay long time in finishing processing, for example 5 minutes (I have one delays 20 hours), time in which my application could fall by timeout.
The call to the procedure I am doing it within bean, my question is if somebody knows some form to cause that the application leaves to bean running the procedure, while I show a "in progress" screen so that once it finishes the application shows a final window with the summary of the process.
It was thinking to use threads.
Some suggestion?
Albert