Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Pooja De
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2955
46
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
POI needs a lot of memory when dealing with sizable files. Try increasing the Permgen space using something like "XX:MaxPermSize=128m".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic