Out of Memory Error

["Mili Aggarwal, Noida" <mi...@noida.hcltech.com>]

Hey I am getting an out of memory error after the following execution:
 I have a Java program that creates an Excel Workbook having 2 sheets using
POI. The total number of Styles being used in both the sheets is 8.The
problem that I am facing is after generating the Excel for about 140
workbook it gives an Out OF Memory Error and the program crashes. But when I
re execute the program with the -Xmx18m i.e. I increase the heap size, it
runs perfectly fine. But the problem is, is there no other alternative to
reduce the amount of emery used by POI to generate Excel? I am explicitly
calling Rutime.gc() to collect garbage but to no avail. Any ideas?


Warm Regards,
Mili Aggarwal
HCL TECHNOLOGIES LTD.
Noida, India.
Email: milia@noida.hcltech.com

----------------------------------------------------------------------------
-----------------------------DISCLAIMER-------------------------------------
----------------------------------------------------------------------------
--------

This message and any attachment contained here are information that is
confidential, proprietary to HCL Technologies and its customers. Contents
may be privileged or otherwise protected by law. The information is solely
intended for the individual or the entity it is addressed to. If you are not
the intended recipient of this message, you are not authorized to read,
forward, print, retain, copy or disseminate this message or any part of it.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and delete it from your computer.






Disclaimer: 

This message and any attachment(s) contained here are information that is
confidential,proprietary to HCL Technologies and its customers, privileged
or otherwise protected by law.The information is solely intended for the
individual or the entity it is addressed to. If you are not the intended
recipient of this message, you are not authorized to read, forward,
print,retain, copy or disseminate this message or any part of it. If you
have received this e-mail in error, please notify the sender immediately by
return e-mail and delete it from your computer.

Re: Out of Memory Error

[Vyom Tewari <vy...@cybage.com>]

This is because of OLE 2.0 , ole 2.0 don't support partial file writing so
if u want to write big file which have multiple sheet all the sheet should
have in more memory that's why u get out of memory problem. and POI itself
lack in memory management capabilities.


----- Original Message ----- 
From: "Mili Aggarwal, Noida" <mi...@noida.hcltech.com>
To: <po...@jakarta.apache.org>
Sent: Wednesday, April 06, 2005 9:23 AM
Subject: Out of Memory Error


> Hey I am getting an out of memory error after the following execution:
>  I have a Java program that creates an Excel Workbook having 2 sheets
using
> POI. The total number of Styles being used in both the sheets is 8.The
> problem that I am facing is after generating the Excel for about 140
> workbook it gives an Out OF Memory Error and the program crashes. But when
I
> re execute the program with the -Xmx18m i.e. I increase the heap size, it
> runs perfectly fine. But the problem is, is there no other alternative to
> reduce the amount of emery used by POI to generate Excel? I am explicitly
> calling Rutime.gc() to collect garbage but to no avail. Any ideas?
>
>
> Warm Regards,
> Mili Aggarwal
> HCL TECHNOLOGIES LTD.
> Noida, India.
> Email: milia@noida.hcltech.com
>
> --------------------------------------------------------------------------
--
> -----------------------------DISCLAIMER-----------------------------------
--
> --------------------------------------------------------------------------
--
> --------
>
> This message and any attachment contained here are information that is
> confidential, proprietary to HCL Technologies and its customers. Contents
> may be privileged or otherwise protected by law. The information is solely
> intended for the individual or the entity it is addressed to. If you are
not
> the intended recipient of this message, you are not authorized to read,
> forward, print, retain, copy or disseminate this message or any part of
it.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and delete it from your computer.
>
>
>
>
>
>
> Disclaimer:
>
> This message and any attachment(s) contained here are information that is
> confidential,proprietary to HCL Technologies and its customers, privileged
> or otherwise protected by law.The information is solely intended for the
> individual or the entity it is addressed to. If you are not the intended
> recipient of this message, you are not authorized to read, forward,
> print,retain, copy or disseminate this message or any part of it. If you
> have received this e-mail in error, please notify the sender immediately
by
> return e-mail and delete it from your computer.
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/