I am trying to load .xlsx file. I think there is some conflicts with Axis2 and poi-ooxml-3.8 jar file. I got the below error :

org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:62)
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:403)
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:408)
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:155)
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:190)
2013-08-29 13:07:10,142 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.xorail.cactus.ptc.PtcTableBackingBean.importAssetData(PtcTableBackingBean.java:171)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.xorail.cactus.ptc.PtcTableBackingBean.submitImportData(PtcTableBackingBean.java:774)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at java.lang.reflect.Method.invoke(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.el.parser.AstValue.invoke(AstValue.java:170)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at javax.faces.component.UICommand.broadcast(UICommand.java:315)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:329)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.component.AjaxViewRoot.broadcastEventsForPhase(AjaxViewRoot.java:304)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:261)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:474)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:349)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at java.lang.Thread.run(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2) Caused by: java.lang.reflect.InvocationTargetException
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at java.lang.reflect.Constructor.newInstance(Unknown Source)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:60)
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  ... 53 more
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2) Caused by: java.lang.LinkageError: loader constraint violation: when resolving method "org.apache.xmlbeans.XmlOptions.setLoadReplaceDocumentElement(Ljavax/xml/namespace/QName;)Lorg/apache/xmlbeans/XmlOptions;" the class loader (instance of org/jboss/classloader/spi/base/BaseClassLoader) of the current class, org/apache/poi/xssf/usermodel/XSSFDrawing, and the class loader (instance of org/jboss/classloader/spi/base/BaseClassLoader) for resolved class, org/apache/xmlbeans/XmlOptions, have different Class objects for the type javax/xml/namespace/QName used in the signature
2013-08-29 13:07:10,158 ERROR [STDERR] (http-localhost%2F127.0.0.1-8080-2)  at org.apache.poi.xssf.usermodel.XSSFDrawing.<init>(XSSFDrawing.java:81)

I have to use webservice as well as loading xlsx file in my application. These are the jar files i have it in my application

poi-3.8.jar
poi-ooxml-3.8.jar
poi-ooxml-schemas-3.8.jar
xalan-2.7.0.jar
xml-resolver-1.2.jar
geronimo-annotation_1.0_spec-1.1.jar
geronimo-jaxws_2.1_spec-1.0.jar
geronimo-jta_1.1_spec-1.1.jar
geronimo-saaj_1.3_spec-1.0.1.jar
geronimo-ws-metadata_2.0_spec-1.1.2.jar
gson-1.6.jar
httpcore-4.0.jar
javassist-3.12.1.GA.jar
jaxb-api-2.1.jar
jaxb-impl-2.1.7.jar
jaxb-xjc-2.1.7.jar
jaxen-1.1.1.jar
jaxrpc-api-1.1.jar
dom4j-1.1.jar"
axiom-api-1.2.8.jar
axiom-dom-1.2.8.jar
axiom-impl-1.2.8.jar
axis2-jaxws-1.5.1.jar
axis2-kernel-1.5.1.jar
axis2-metadata-1.5.1.jar
axis2-saaj-1.5.1.jar
axis2-transport-http-1.5.1.jar
woden-api-1.0M8.jar
woden-impl-dom-1.0M8.jar
wsdl4j-1.6.2.jar
wstx-asl-3.2.4.jar
XmlSchema-1.4.3.jar
stax-api-1.0-2.jar

Please help me to figure out the issue. Thanks in Advance.

1

There are 1 answers

1
centic On

This is likely caused by XMLBeans providing it's own version of classes from package javax, your best option is to remove these class-files from the xmlbeans jar-file.

There is discussion on the POI mailing list to do an atttic-release of Apache XMLBeans to get this fixed, but this is still ongoing see also https://bz.apache.org/bugzilla/show_bug.cgi?id=59268