poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 52203] New: java.lang.OutOfMemoryError: Java heap space when reading .xlsx file with 1million rows by using usermodel api
Date Thu, 17 Nov 2011 09:27:28 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=52203

             Bug #: 52203
           Summary: java.lang.OutOfMemoryError: Java heap space when
                    reading .xlsx file with 1million rows by using
                    usermodel api
           Product: POI
           Version: 3.7
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: vanlooon@126.com
    Classification: Unclassified


I try to read .xlsx file of 1 million rows by using usermodel api, the file
size is 11.2 MB, the jvm throw Exception :
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
    at java.util.Arrays.copyOf(Arrays.java:2786)
    at java.io.ByteArrayOutputStream.write(ByteArrayOutputStream.java:94)
    at
org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource$FakeZipEntry.<init>(ZipInputStreamZipEntrySource.java:115)
    at
org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:55)
    at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:82)
    at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:220)
    at SXSSFWorkbookTest.test2(SXSSFWorkbookTest.java:51)
    at SXSSFWorkbookTest.main(SXSSFWorkbookTest.java:37)

To resolve the issue, i use the eventmodel api, that is ok!.
But i want to know why the usermodel api take so much memory when parseing huge
rows file???

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message