Hi Folks,
I would like to know if anybody was successful in retrieving more than
250 rows from an Oracle database and send them all to the browser and
display it.
I was able to only retrieve a maximum of 200 rows from my ResultSet
object and after that my whole system comes to a grinding halt. I know
it's pretty weird to display 250 rows of data to the user, but, I'm just
curious to know, where is the problem exactly. Is it because of the
Oracle Thin Driver's I use or is it JRun 2.3 cannot handle that large
ResultSet's and time out(or crashes).
To make it simple ,I just retrieved a large ResultSet from the database
in my Servlet and simply went through the "while" loop to just pump out
the rows to the browser. But, it couldn't go beyond a certain limit(250
rows in my case). Is there any obvious things I need to take care while
handling large Datasets.
Any suggestions would be welcome. I'm also wondering whether using an
Applet instead of the HTML for displaying, would help solve my problem.
Thanks for any help offered,
>
___________________________________________________________________________
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
