My environment is Eclipse+tomcat 5.0[Tomcat is the local tomcat within eclipse]. I have a report query which can produce anywhere from 10000-70000 records. I dont have any problem displaying data in jsp when the records are 10,000. I have a record count of 64000 now and while displaying,running th query, the program exists with Out of memory error saying heap size.

java.lang.OutOfMemoryError: Java heap space

Corerct exception looks like this: Why ? is it because of 65000 records ?
How can I increase my heapsize ? In my program, I have a Statement object and a Resultset rs then I iterate thru while(rs.next()) -

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet execution threw an exception


root cause

java.lang.OutOfMemoryError: Java heap space


note The full stack trace of the root cause is available in the Apache Tomcat logs.