This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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".
 
Don't get me started about those stupid light bulbs.
 
subject: Getting "java.lang.OutOfMemoryError: PermGen space" exception while reading xlsx file using POI 3.7
 
Similar Threads
Problem: Could not find the main class: weblogic.appc. Program will exit.
Exception in thread "main" java.lang.NoClassDefFoundError: Voice1
weblogic 10 web service Standalone client issue
"Unknown constant tag 108" error !! What is it about ?
Interface - AbstractClass Collision