aspose file tools*
The moose likes Other Open Source Projects and the fly likes Exeption while writing huge data to excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Exeption while writing huge data to excel sheet" Watch "Exeption while writing huge data to excel sheet" New topic
Author

Exeption while writing huge data to excel sheet

haripriya kaligotla
Greenhorn

Joined: Jul 21, 2010
Posts: 3

Joined: Jul 21, 2010
Posts: 1

[Post New] posted Today 3:44:37 PM private message
Quote
Hi,
We are tryiing to write 60k rows and 100 cols to an excel sheet but getting the below exception:

"Exception in thread "main" java.lang.OutOfMemoryError: Java heap space"

Any help to get rid of this would be appreciated. Thanks.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Increase the heap space? Don't keep everything in memory?
haripriya kaligotla
Greenhorn

Joined: Jul 21, 2010
Posts: 3
We tried increasing the heap and it did work, but we can have many such reports running parallely in the server, and if each report conusmes more than normal heap space the entire server response would slow down, hence looking for a better solution.

Reg: release the memory, tried calling System.gc() after reaching a certain number, but this is taking time to finish off the complete process.
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

Well, if you *must* keep everything in memory, I'm not sure what else you could do.
 
Don't get me started about those stupid light bulbs.
 
subject: Exeption while writing huge data to excel sheet