java xml内存泄漏,Java Apache-poi，内存泄漏与excel文件

最新推荐文章于 2024-08-26 09:10:23 发布

徐光霞

最新推荐文章于 2024-08-26 09:10:23 发布

阅读量618

点赞数

文章标签： java xml内存泄漏

在处理大量Excel文件时，使用Apache POI遇到内存溢出问题。异常为'java.lang.OutOfMemoryError: GC overhead limit exceeded'。尝试使用OPCPackage.open()打开文件仍无法解决问题。解决方法是利用POI的SAX（事件API），在读取过程中不将整个工作簿加载到内存，而是逐行处理，降低内存占用。

摘要由CSDN通过智能技术生成

I need to read (15000) excel files for my thesis. I'm using apache poi to open and later to analyze them but after around 5000 files I'm getting the following exception and stacktrace:

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded

at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3044)

at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3065)

at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3263)

at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)

at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1822)

at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)

at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(Pi