Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Process a huge SQL procedure before timeout with JSP

Process a huge SQL procedure before timeout with JSP

From: Dane <junkmailblackhole_at_yahoo.com>
Date: 6 Jul 2001 14:44:30 -0700
Message-ID: <199a58b3.0107061344.2365f1c4@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US