OK, I used the below idea to change the default /tmp dir.
When I deploy the code at our Linux server, when I run the Excel operation, I
get below exceptions.
It appears it is missing some jar file.
FYI: We're using below poi jar files first
poi-3.11-beta2-20140822. poi-ooxml-schemas-3.11-beta2-20140822.jar
poi-ooxml-3.11-beta2-20140822.jar
After the error, I've added below jar files to see if it solves the error,
still no luck.
jar poi-ooxml-3.9-20121203.jar poi-3.6-20091214.jar
Any clue?
Thanks,
[10/16/14 17:55:08:343 EDT] 0000001e servlet E
com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught
exception created in one of the service methods of the servlet
ExportExcelServlet in application ORWS_04_01_00_0007_war. Exception created :
java.lang.NoSuchMethodError:
javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
at
org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:45)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:200)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:167)
at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161)
at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:65)
at org.apache.poi.openxml4j.opc.OPCPackage.create(OPCPackage.java:337)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:406)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:213)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:216)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:160)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:255)
at com.fmr.orws.excel.SendXLS2GUI.doPost(Unknown Source)
at com.fmr.orws.excel.SendXLS2GUI.doGet(Unknown Source)
-----Original Message-----
From: Dominik Stadler [mailto:[email protected]]
Sent: Sunday, October 12, 2014 5:54 AM
To: POI Developers List
Subject: Re: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the api
to dump large xml file at /tmp dir. Also does not compress & cleanup up causing
the /tmp/ disk space full
Hi,
SXSSFWorkbook uses class TempFile, which uses
DefaultTempFileCreationStrategy which uses the system property
java.io.tmpdir by default. So one option is to set this property
differently, however this can affect other frameworks/libraries and
JDK functionality itself as well. Alternatively you can set a
different strategy/dir via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(), e.g. you
can set a different directory via
org.apache.poi.util.TempFile.setTempFileCreationStrategy(new
org.apache.poi.util.TempFile.DefaultTempFileCreationStrategy(new
File("/var/tmp")))
Dominik.
On Mon, Oct 6, 2014 at 8:30 PM, Banerjee, Tapas <[email protected]> wrote:
> As suggested below, removing old (2.6) xerces jar, and linking the latest
> 2.11 xercesImpl.jars, solved the exception issue.
> Now I can export files at my local PC environment. We'll test with bigger
> files by deploying the code to Unix server.
>
> Question: Is there a way (API call?) we can change location of dumping Xml
> file ( currently /tmp) by the POI - SXSSF api?
>
> Thanks,
>
>
> -----Original Message-----
> From: Dominik Stadler [mailto:[email protected]]
> Sent: Friday, October 03, 2014 5:03 PM
> To: POI Developers List
> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing the
> api to dump large xml file at /tmp dir. Also does not compress & cleanup up
> causing the /tmp/ disk space full
>
> the root cause is a very outdated xml parser implementation which you are
> loading via the classpath. Ideally you should try to upgrade or remove
> xerces jar files or other old xml implementation from your classpath, jdk
> comes with the same features since a long time, however unfortunately some
> 3rd party libs still hard-depend on these old libs.
>
> Alternatively you can try a nightly build where this error is prevented for
> backwards compatibility.
>
> Dominik
> Am 03.10.2014 17:29 schrieb "Banerjee, Tapas" <[email protected]>:
>
>> Nick,
>>
>> I added code to print version. It shows it is pointing to 3/11 (dev)
>>
>> However, when I try to export to excel, I am getting below error.
>>
>>
>>
>> Core POI came from
>> file:/C:/ccrc/a475324_EBS_ORWS_UI_03.05.00_rtp_d/WFM/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/.../WEB-INF/lib/poi-3.11-beta2-20140822.jar!/org/apache/poi/poifs/filesystem/POIFSFileSystem.class
>>
>> Oct 3, 2014 11:18:59 AM org.apache.catalina.core.StandardWrapperValve
>> invoke
>>
>> SEVERE: Servlet.service() for servlet ExportExcelServlet threw exception
>>
>> java.lang.AbstractMethodError:
>> javax.xml.parsers.DocumentBuilderFactory.setFeature(Ljava/lang/String;Z)V
>>
>> at
>> org.apache.poi.util.DocumentHelper.trySetSAXFeature(DocumentHelper.java:62)
>>
>> at
>> org.apache.poi.util.DocumentHelper.<clinit>(DocumentHelper.java:56)
>>
>> at
>> org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshallRelationshipPart(ZipPartMarshaller.java:120)
>>
>> at
>> org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:464)
>>
>> at
>> org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1425)
>>
>> at
>> org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:201)
>>
>> at
>> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:830)
>>
>> at
>> com.fmr.orws.excel.SendXLS2GUI.doPost(SendXLS2GUI.java:55)
>>
>>
>>
>> I see this issue is listed in Poi dev mailing list.
>>
>> Any idea, how I can solve the issue?
>>
>>
>>
>>
>> http://mail-archives.apache.org/mod_mbox/poi-dev/201408.mbox/%3ccabdjj56oeqoaf7icuodl7e_1cgdqdqspeg+vkszudyrfof1...@mail.gmail.com%3E
>>
>>
>>
>> Thanks,
>>
>>
>>
>> -----Original Message-----
>> From: Nick Burch [mailto:[email protected]]
>> Sent: Wednesday, October 01, 2014 1:41 PM
>> To: POI Developers List
>> Subject: RE: [Bug 57042] Writing Large Excel Sheet (~150K rows) causing
>> the api to dump large xml file at /tmp dir. Also does not compress &
>> cleanup up causing the /tmp/ disk space full
>>
>>
>>
>> On Wed, 1 Oct 2014, Banerjee, Tapas wrote:
>>
>> > Is there way I can find which version of POI library (e.g. 3.10 or
>>
>> > 3.11..) my build is linking programmatically?
>>
>>
>>
>> Assuming you haven't renamed jars, try the code from the FAQ:
>>
>> http://poi.apache.org/faq.html#faq-N10006
>>
>>
>>
>> There's also org.apache.poi.Version
>>
>>
>>
>> Nick
>>
>>
>>
>> ---------------------------------------------------------------------
>>
>> To unsubscribe, e-mail: [email protected]<mailto:
>> [email protected]>
>>
>> For additional commands, e-mail: [email protected]<mailto:
>> [email protected]>
>>
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
