Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't parse cell tag jx:forEach org.apache.commons.digester.Digester

anhdhMay 19 2014 — edited May 20 2014

I'm using Jdeveloper Studio Edition Version 12.1.2.0.0 with jxls to export excel report:

+ jxls-1.0.2

with :

- POI : poi-bin-3.10-FINAL-20140208.zip

- Bean util : commons-beanutils-1.9.1-bin.zip

- Commons Collections: commons-collections4-4.0-bin.zip

- Commons JEXL 2.1.2 :http://mirrors.digipower.vn/apache//commons/jexl/binaries/commons-jexl-2.1.1-bin.zip

- Commons Logging 1.1.3 :http://mirrors.digipower.vn/apache//commons/logging/binaries/commons-logging-1.1.3-bin.zip

- Commons Digester : http://mirrors.digipower.vn/apache//commons/digester/binaries/commons-digester3-3.2-bin.zip

My code in bean :

String templateFileName = "", FulltemplateFileName = "";

templateFileName = "employees";

String destFileName = "", FulldestFileName = "";

destFileName = templateFileName + "_out.xls";

ApplicationModule ap = ADFUtils.getApplicationModuleForDataControl("AppModuleDataControl");

AppModuleImpl am = (AppModuleImpl) ap;

Statement st = null;

st = am.getDBTransaction().createStatement(1);

ServletContext context = getContext();

InputStream is = context.getResourceAsStream("/Resource/Report/report.xls");

Connection con = st.getConnection();

Statement stmt = con.createStatement();

Map beans = new HashMap();

ReportManager reportManager = new ReportManagerImpl(con, beans);

beans.put("rm", reportManager);

XLSTransformer transformer = new XLSTransformer();

Workbook wb = transformer.transformXLS(is, beans);

HttpServletResponse response = getResponse();

OutputStream out = response.getOutputStream();

response.setContentType(XLS_DIRECT_PRINT_CONTENT_TYPE);

String tmp = destFileName + "$$$$$$^^^^^^";

String val = tmp.replace(".xls$$$$$$^^^^^^", ".xlswebdirectprint");

response.setHeader("Content-Disposition", "attachment; filename=" + val);

wb.write(out);

is.close();

out.close();

return null;

In my xls file template :

<jx:forEach items="${rm.exec('SELECT Employee_Code,FirstName,BirthDay,Email,Salaried FROM hr_employee" var="hr_employee">
${hr_employee.Employee_Code}	${hr_employee.FirstName}	${hr_employee.Salaried}	$[C5*100]
</jx:forEach>

And i'm gettting eror :

javax.faces.el.EvaluationException: java.lang.RuntimeException: Can't parse cell tag <jx:forEach items="${rm.exec('SELECT Employee_Code,FirstName,BirthDay,Email,Salaried FROM hr_employee" var="hr_employee"> : fullXML: <jxls xmlns:jx="http://jxls.sourceforge.net/jxls/jx"><jx:forEach items="

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

at javax.faces.component.UICommand.broadcast(UICommand.java:315)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:130)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:134)

at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:107)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:130)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:461)

at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:134)

at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:101)

at oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:123)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1083)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:341)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:106)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:478)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:303)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:208)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:225)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3367)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3333)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2220)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2146)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2124)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1564)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:295)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:254)

Caused By: java.lang.RuntimeException: Can't parse cell tag <jx:forEach items="${rm.exec('SELECT Employee_Code,FirstName,BirthDay,Email,Salaried FROM hr_employee" var="hr_employee"> : fullXML: <jxls xmlns:jx="http://jxls.sourceforge.net/jxls/jx"><jx:forEach items="

at net.sf.jxls.parser.CellParser.parseTag(CellParser.java:306)

at net.sf.jxls.parser.CellParser.parseCellValue(CellParser.java:202)

at net.sf.jxls.parser.CellParser.parseCell(CellParser.java:56)

at net.sf.jxls.transformer.SheetTransformer.parseCells(SheetTransformer.java:204)

at net.sf.jxls.transformer.SheetTransformer.parseRow(SheetTransformer.java:275)

at net.sf.jxls.transformer.SheetTransformer.transformSheet(SheetTransformer.java:80)

at net.sf.jxls.transformer.XLSTransformer.transformWorkbook(XLSTransformer.java:248)

at net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:221)

at B4Uview.hr_department_list.ReportExcel(hr_department_list.java:86)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)