1
0
-1

Hi Team,

I am trying to read an uploaded excel file(.xlsx) by user using plugin.

Once the user upload the file in the form, I will try to read the file using Apache POI 3.17. But I am getting the below errors.

 

Code snippet:

    

File file = FileUtil.getFile(fileName, tableName, recordId);


System.out.println(file.getPath());

FileInputStream fip = new FileInputStream(file);

System.out.println("Before the file xls");

XSSFWorkbook workbook = new XSSFWorkbook(fip);

LogUtil.info("", workbook.getSheetAt(0).getSheetName());

 

 

ERROR 22 Jul 2019 11:45:08 org.joget.commons.spring.web.CustomDelegatingFilterProxy - An exception occurred processing JSP page [/WEB-INF/jsp/ubuilder/v5view.jsp] at line [11]__8: %>_9: _10: <c:if test="${!empty processer}">_11: <c:set var="html" value="${processer.html}"/>_12: _13: <c:if test="${!empty processer.redirectUrl}">_14: <c:redirect url="${processer.redirectUrl}"/>___Stacktrace:
org.apache.jasper.JasperException: An exception occurred processing JSP page [/WEB-INF/jsp/ubuilder/v5view.jsp] at line [11]

8: %>
9:
10: <c:if test="${!empty processer}">
11: <c:set var="html" value="${processer.html}"/>
12:
13: <c:if test="${!empty processer.redirectUrl}">
14: <c:redirect url="${processer.redirectUrl}"/>


Stacktrace:
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:588)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:467)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:392)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:168)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:304)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1286)
at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1041)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:984)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

.

.

.

Caused by: java.lang.ClassCastException: org.apache.xerces.stax.XMLEventFactoryImpl cannot be cast to javax.xml.stream.XMLEventFactory
at javax.xml.stream.XMLEventFactory.newInstance(XMLEventFactory.java:30)
at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:41)
... 180 more

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, if you are using an OSGi plugin it should be caused by mismatching classloaders. Perhaps you can try the solution found in https://stackoverflow.com/questions/7380753/how-to-perform-xslt-transformation-with-java-extension-from-within-osgi-bundle/7381176#7381176

        CommentAdd your comment...