Running oracle procedure in separate thread separate, Running, oracle, spring

amy

Hi all, I'm using the spring class StoredProcedure to execute my oracle procedures called from my webpage. I can do it fine without problem. But I have one large procedure, the process take 1 hour and I can't 'break' the webpage per 1 hour. Have an alternative to run this procedure like in a separate thread to enable the user to navegate in other pages or start others procedures?

Thanks in advance!

Hello:

I guess you can do a JMS queue that you can send from your web tier to your model tier a task (processing your StoreProcedure) by this queue.

I guess the use of a asynchrnoned queue can help you to solve this problem...

I think there may be a good solution for this problem.

One option would be to use Spring's TaskExecutor abstraction or the Java 5 Executor framework to launch your stored procedure asynchronously. See here for more details:

sp...-task-executor
j2se/1.5.0/docs/.../Executor.html
j2se/1.5.0/docs/...nt/Future.html

neketsushonen,Mike Bingham thanky you!!!!

I did with TaskExecutor and it works fine!!!amazing! thank you!