If you are using SQL server there is a line you need to put into the connect string so that it doesn't hold onto the results. We ran into this as well for MSSql 7. I will try and dig up the correct option.
Kevin -----Original Message----- From: Micael Padraig Og mac Grene [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:20 AM To: Tomcat Users List Subject: Re: Out Of Memory Error My guess, though, is that you are trying to do a database job with objects. Don't know what database you are using, but whichever one it is, it usually has some ways to do it better than you can using objects to order the data. I learned that the hard way. Micael At 05:54 AM 5/13/02 +0100, you wrote: >Hi All, >I am generating a report using servlets which has >70000 records. While processing it gives an >OutOfMemory Error. Can any one tell me how and where >to add memory? My RAM is 512MB > > >URGENT!!! > >Thanks >Amit Lonkar > >________________________________________________________________________ >Everything you always wanted to know about cars and bikes,now > at: http://in.autos.yahoo.com/cricket/tracker.html > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>