[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    [jira] [Commented] (XMLBEANS-571) Excel file read failure using xmlbeans 3.0.0 whereas it works on x
From:       "Andreas Beeker (Jira)" <jira () apache ! org>
Date:       2021-09-27 19:41:00
Message-ID: JIRA.13403184.1632497444000.1066512.1632771660265 () Atlassian ! JIRA
[Download RAW message or body]


    [ https://issues.apache.org/jira/browse/XMLBEANS-571?page=com.atlassian.jira.plugi \
n.system.issuetabpanels:comment-tabpanel&focusedCommentId=17420993#comment-17420993 ] \


Andreas Beeker commented on XMLBEANS-571:
-----------------------------------------

although this thread was already quite entertaining, I wonder if JDK6 is something \
which keeps you from upgrading beyond POI 3.X. If so, security seems not so important \
... otherwise POI 4.x and 5.x have a baseline of JDK8 and provide support for JPMS \
(JDK9+). You are better off using a current POI/XmlBeans version - of course you need \
to test those first! - as we try to be compatible with current JDKs and also update \
our dependencies + fix findings of Sonar. Sticking around with that old version means \
also sticking with the old dependencies.

You haven't actually mentioned what blocks you apart of "dependencies", maybe we can \
help you there, if it's related to POI/XmlBeans

> Excel file read failure using xmlbeans 3.0.0 whereas it works on xmlbeans 2.6.0
> -------------------------------------------------------------------------------
> 
> Key: XMLBEANS-571
> URL: https://issues.apache.org/jira/browse/XMLBEANS-571
> Project: XMLBeans
> Issue Type: Bug
> Affects Versions: Version 3.0.0
> Environment: linux
> Reporter: Sateesh
> Priority: Blocker
> Fix For: Version 3.0.0
> 
> Attachments: XLSXReaderExample.java, test.xlsx
> 
> 
> I have an Excel file cell with note processing successfully with Apache POI 
> 3.14 + xmlbeans 2.6.0. 
> But when we moved to xmlbeans 3.0.0 it fails with following exception. If 
> I delete the note in the Excel file it processes successfully with 3.0.0. Attached \
> the testcase Source_File,0: org.apache.poi.POIXMLException: 
> java.lang.reflect.InvocationTargetException
> at 
> org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:65)
> at 
> org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:601)
> at 
> org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:613)
> at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:174)
> at 
> org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:249)
> .......
> Caused by: java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native 
> Method)
> at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
>  at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
>  at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
> at 
> org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
> at 
> org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:62)
> ... 12 more
> Caused by: org.apache.xmlbeans.XmlException: error: Content is not allowed 
> in trailing section.
> at 
> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
> at 
> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1271)
> at 
> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1258)
> at 
> org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
>  at org.apache.xmlbeans.XmlObject$Factory.parse(XmlObject.java:747)
> at 
> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:128)
> at 
> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.<init>(XSSFVMLDrawing.java:116)
> ... 18 more
> Caused by: org.xml.sax.SAXParseException: Content is not allowed in 
> trailing section.
> at 
> org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown 
> Source)
> at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown 
> Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown 
> Source)
> at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown 
> Source)
> at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown 
> Source)
> at 
> org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown \
>  Source)
> at 
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown 
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown 
> Source)
> at org.apache.xerces.parsers.XML11Configuration.parse(Unknown 
> Source)
> at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
> at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown 
> Source)
> at 
> org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
> at 
> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3413)
> ... 24 more



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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


[prev in list] [next in list] [prev in thread] [next in thread]