> Hi,
>
>
> My problem is that the browser (or is is the servlet/webserver) goes in
> timeout after about 70 secs. The execution of the method generating the
> report is then stopped, and the user is presented with a blank white page.
I had the same problem working with JDBC. When trying to retrive a lot of info
from a table (more than 200, 300 rows), JRun launches TimeoutException and stops
the execution. The code I used was similar to:
StringBuffer sb = new StringBuffer();
//makes the statement...
ResultSet pp = stmt.executeQuery(sql);
while (pp.next()) {
//retrieve the row and converit into a HTML string
...
sb.append(HTMLString+"\n");
}
//closes the connection
...
res.getOutputStream.print(sb.toString());
...
You can print the info as soon as it is retrieved:
//makes the statement...
ResultSet pp = stmt.executeQuery(sql);
while (pp.next()) {
//retrieve the row and converit into a HTML string
...
res.getOutputStream.print(HTMLString}
//closes the connection
...
The server is no longed interrupted and the user can see the query results
sooner.
Hope this helps.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
