Thread: Streaming data to html problem

Hi,

I am retriving a large queryset back to a vector that needs to stream to html but when the vector has over a few hundred records the page is timing out, can anyone advise of the best solution would be, is there a way of paging a vector.

I am looping through each element in the vector and doing an out.println() with the results in to a table.

It works if I only loop 50 times but not 500.

See a bit of the errorlog below

ClientAbortException: java.io.IOException
at org.apache.catalina.connector.OutputBuffer.realWri teBytes(OutputBuffer.java:358)
at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(B yteChunk.java:434)
at org.apache.tomcat.util.buf.ByteChunk.append(ByteCh unk.java:293)

I am studying servlet now. As I know, your problem might be caused by limit of outputbuffer size. You can also set max rows for each query and run query for serveral times, not only one time.

I hope this will be useful.