[ 
https://issues.apache.org/jira/browse/XMLBEANS-571?page=com.atlassian.jira.plugin.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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to