poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "KHZ (SAW)" <karl-heinz.zenge...@sawag.com>
Subject AW: Large Excel Files and java.lang.OutOfMemoryError
Date Wed, 17 Nov 2004 17:36:33 GMT
Hi Dave.

Then you'ld have to use the event model which is quite different from
the user model.

Regards,	Karl-Heinz.


-----Urspr√ľngliche Nachricht-----
Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com] 
Gesendet: Mittwoch, 17. November 2004 18:30
An: POI Users List
Betreff: RE: Large Excel Files and java.lang.OutOfMemoryError

Yes.  This is my greatest concern.

- Dave 

-----Original Message-----
From: Pravin Pillai [mailto:Pravin.Pillai@neoforma.com] 
Sent: Wednesday, November 17, 2004 10:29 AM
To: POI Users List; karl-heinz.zengerle@sawag.com
Subject: RE: Large Excel Files and java.lang.OutOfMemoryError

If ur memory setting is so high, none of the other processes on ur
machine will be able to run. U might end up crashing something else. 

-----Original Message-----
From: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]
Sent: Wednesday, November 17, 2004 6:33 AM
To: POI Users List; karl-heinz.zengerle@sawag.com
Subject: RE: Large Excel Files and java.lang.OutOfMemoryError

Karl-Heinz,

Thank you.  This suggestion worked.  However, I remain concerned that it
will not be a wholly reliable solution, because I've yet to attempt the
largest file that I have to work with to meet the requirements of my
application.  My largest file must support about 65K rows  (32 columns
wide) spread across 5 tabs.

In order to meet the memory needs of 41K of these rows, I had to set the
-Xmx setting to 2048m!!!  Thoughts?

It seems that the next version of POI-HSSF needs to invest some time in
memory management.

Thanks again,

David 

-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
Sent: Wednesday, November 17, 2004 2:42 AM
To: 'POI Users List'
Subject: AW: Large Excel Files and java.lang.OutOfMemoryError

Hi Dave.

E.g. -Xmx256m (or more). In Eclipse you would declare it per main(). In
Tomcat it would be in a configuration file.

In other systems it would surely work similar.

Regards,	Karl-Heinz.


-----Urspr√ľngliche Nachricht-----
Von: Hamu, Dave [mailto:Dave.Hamu@Avnet.com]
Gesendet: Dienstag, 16. November 2004 23:11
An: poi-user@jakarta.apache.org
Betreff: Large Excel Files and java.lang.OutOfMemoryError

I have noticed that several people have run into this problem, but I
have not found any solutions.

In short, I receive a java.lang.OutOfMemoryError when I am writing
particularly large Excel Files (several thousand rows of data).  Has
anyone found a clean solution to this problem that does not involve
adding more memory (I have 3Gig on my workstation).


- Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message