You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Hamu, Dave" <Da...@Avnet.com> on 2004/11/16 23:11:22 UTC
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
Re: Large Excel Files and java.lang.OutOfMemoryError
Posted by "Espen Ø. Pedersen" <ep...@corena.no>.
Hmm .... we have a similar problem with PowerPoint files.
We ha a realtime freetext indexer (based on apache lucene) and when we
add several ppt files for indexing the app eventually get's an
java.lang.OutOfMemoryError exception.
-Espen
Hamu, Dave wrote:
> 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
AW: AW: Large Excel Files and java.lang.OutOfMemoryError
Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Espen.
How does the stack trace look like? Can "infinite" recursion (just
stopped because of memory issues) be excluded as the cause?
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: "Espen Ø. Pedersen" [mailto:epe@corena.no]
Gesendet: Mittwoch, 17. November 2004 11:01
An: POI Users List
Betreff: Re: AW: Large Excel Files and java.lang.OutOfMemoryError
I thought so too, until I tried it and it did'nt have any effect on the
java.lang.OutOfMemoryError exception.
I can also see that I have plenty of free memory availble when this
happens, so I'm not truly convinced that memory is the core of the
problem.
-Espen
KHZ (SAW) wrote:
> 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
>
--
Espen Ø. Pedersen
Company: CORENA Norge AS
Address: Industritunet, Dyrmyrgt. 35, N-3611 Kongsberg
Phone: +47 32 71 72 29
Skype:
E-mail: epe@corena.no
http://www.corena.com
---------------------------------------------------------------------
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
Re: AW: Large Excel Files and java.lang.OutOfMemoryError
Posted by "Espen Ø. Pedersen" <ep...@corena.no>.
I thought so too, until I tried it and it did'nt have any effect on the
java.lang.OutOfMemoryError exception.
I can also see that I have plenty of free memory availble when this
happens, so I'm not truly convinced that memory is the core of the problem.
-Espen
KHZ (SAW) wrote:
> 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
>
--
Espen Ø. Pedersen
Company: CORENA Norge AS
Address: Industritunet, Dyrmyrgt. 35, N-3611 Kongsberg
Phone: +47 32 71 72 29
Skype:
E-mail: epe@corena.no
http://www.corena.com
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
AW: Large Excel Files and java.lang.OutOfMemoryError
Posted by "KHZ (SAW)" <ka...@sawag.com>.
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