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