tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mika Goeckel" <m...@stepstone.de>
Subject Re: Server crashes...
Date Thu, 08 Nov 2001 20:55:01 GMT
Hey Praveen,

that depends on the jdbc class you're using. Oracle for instance allows you
to specify how many records you want to take in one go into your resultset.
Afterwards you can reload further records. But anyway, what requirement do
you have that you need all the records, sounds odd :-)

Cheers, Mika

----- Original Message -----
From: "Praveen Potineni" <potineni39@hotmail.com>
To: "JSP_INTEREST" <JSP-INTEREST@JAVA.SUN.COM>;
<tomcat-user@jakarta.apache.org>
Sent: Thursday, November 08, 2001 9:22 PM
Subject: Server crashes...


Hi all,
I have a query which gets 1 million records. When i try to query from a bean
and access it from JSP(i'm using Tomcat 4.0 on win 2000), the application
takes forever and finally crashes on me. It says running out of virtual
memory.
I have a question:
What is the physical location of the resultset. When i do a query where is
the result set coming and storing all the values.What is the physical
location of the data that is being retrieved.

How can i make the data access quick.

Thanks
Praveen



--
To unsubscribe:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands: <mailto:tomcat-user-help@jakarta.apache.org>
Troubles with the list: <mailto:tomcat-user-owner@jakarta.apache.org>


Mime
View raw message