It's not a secret anymore!*
The moose likes Performance and the fly likes Getting Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "Getting "java.lang.OutOfMemoryError: PermGen space" exception while reading xlsx file using POI 3.7 " Watch "Getting "java.lang.OutOfMemoryError: PermGen space" exception while reading xlsx file using POI 3.7 " New topic
Author

Getting "java.lang.OutOfMemoryError: PermGen space" exception while reading xlsx file using POI 3.7

Pooja De
Greenhorn

Joined: Dec 01, 2011
Posts: 1
This is very intermittent problem and does not occur regularly.

I am reading an xlsx file using POI 3.7 and I have code as follows,


When I do xssfReader.getStylesTable() I get a stacktrace as follows,



I tried searching for this on forums and on Google but did not come across anyone who has run into this. Does anyone know why I got this and how I should proceed with a resolution?

Thanks.
Tim Moores
Rancher

Joined: Sep 21, 2011
Posts: 2408
POI needs a lot of memory when dealing with sizable files. Try increasing the Permgen space using something like "XX:MaxPermSize=128m".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting "java.lang.OutOfMemoryError: PermGen space" exception while reading xlsx file using POI 3.7