Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Process a huge SQL procedure before timeout with JSP
I'm running a SQL stored procedure on JSP server Resin 1.2.5. The stored procedure takes two columns of data and merges them into a third. It times out after an hour of processing time. I've tried increasing the "usertimeout" variable in Resin's <database name>.properties file. That worked to get me from a one minute timeout to a one hour timeout, but there must be another timeout counter somewhere that's not letting me past one hour. Is there any way that I could either lengthen that indefinitely or else process the stored procedure outside of the JSP page and then send the results to the JSP page when it's finished? Thanks
Dane Received on Fri Jul 06 2001 - 16:44:30 CDT
![]() |
![]() |