java.lang.OutOfMemoryError: Java heap space

[Ganeshkumar cheekati]

Hi
i am getting java.lang.OutOfMemoryError: Java heap space in my code where i am exporting 20,000 records to excel sheet using POI...
Can anyone give me solution for this?
Thanks in Advance....

[Rene Larsen]

You could try to increase the heap memory size on the server

-Xms<size>        set initial Java heap size
-Xmx<size>        set maximum Java heap size

and maybe you also need to set

-XX:PermSize=<size>
-XX:MaxPermSize=<size>

Another very important issue is the code it self - does it preform god enough ??

[Remko Strating]

A different solution could be adjusting the code where the 20.000 lines are imported in parts to Excel and not al the records are read in memory at once.

[Ganeshkumar cheekati]

i am doing the samething like creating different sheets for each 250 records while exporting to excel using poi api but it is not working.

Eventhough i used the command to increase the heapsize in tomcat also not working.

In companies we are using tomcat with out installation that why command is not working..

Any suggestion

Thanks in Advance...