This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I've got the following code that calls a stored procedure from a web based servlet application.
The above statement calls a PL\SQL stored procedure in the database. The stored procedure takes about 2 hrs to complete.
When my servlet calls this procedure, the relevant webpage on the front end is showing that its waiting for the stored procedure to return something.
How can i call the stored procedure and have it run in the background while the servlet returns e.g. a message saying that the stored procedure is running in the background.
I just need an idea or references as to how i can do this. Does the servlet have to call the PL\SQL in another thread? Is there something in CallableStatement that i can use to tell the servlet not to wait for a response from the PL\sqL?