leonardomartinez Posted February 20, 2015 Share Posted February 20, 2015 Hello, hope you can help me,I'm trying to compile a report from Coldfusion, this is my script:<cfscript>system = CreateObject("java", "java.lang.System");classpath = system.getProperty("java.class.path");if (FindNoCase("jasperreports", classpath) LTE 0){ classpath = classpath & ";C:ColdFusion8wwwrootWEB-INFlibReporteVentasCliente.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-beanutils-1.8.0.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-collections-2.1.1.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-digester-2.1.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-javaflow-20060411.jar;C:ColdFusion8wwwrootWEB-INFlibcommons-logging-1.1.1.jar;C:ColdFusion8wwwrootWEB-INFlibgroovy-all-2.0.1.jar;C:ColdFusion8wwwrootWEB-INFlibiText-2.1.7.js2.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-javaflow-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-fonts-6.0.0.jar;C:ColdFusion8wwwrootWEB-INFlibjasperreports-javaflow-5.5.0.jar;C:ColdFusion8wwwrootWEB-INFlibjcommon-1.0.15.jar;C:ColdFusion8wwwrootWEB-INFlibjfreechart-1.0.12.jar;C:ColdFusion8wwwrootWEB-INFlibMerlia.jar;C:ColdFusion8wwwrootWEB-INFlibpng-encoder-1.5.jar;C:ColdFusion8wwwrootWEB-INFlibpoi-3.7-20101029.jar;C:ColdFusion8wwwrootWEB-INFlibservlet-api.jar;C:ColdFusion8wwwrootWEB-INFlibjxl-2.6.10.jar"; system.setProperty("java.class.path",classpath);}clazz = CreateObject("java", "java.lang.Class");clazz.forName("com.inet.tds.TdsDriver");driverManager = CreateObject("java", "java.sql.DriverManager");conurl = "jdbc:inetdae7:172.30.20.3:2717?database=db_ua_mex2";//VALIDAR login = "user";password = "password";connection = driverManager.getConnection(conurl, login, password); parameters = CreateObject("java", "java.util.HashMap"); parameters.put("empId", "1"); parameters.put("fecha1", "20140801"); parameters.put("fecha2", "20140802"); parameters.put("cliente", "0"); parameters.put("sitio", "0"); parameters.put("userId", "1");//// COMPILE ////jasperCompileManager = createObject("java", "net.sf.jasperreports.engine.JasperCompileManager");jasper = jasperCompileManager.compileReportToFile("C:ColdFusion8wwwrootjasperReportreporte_ventas_cliente_v2.jrxml");//// FILL //// jasperFillManager = createObject("java", "net.sf.jasperreports.engine.JasperFillManager");jasperPrint = jasperFillManager.fillReportToFile(jasper, parameters, connection);//// EXPORT ////jasperExportManager = createObject("java", "net.sf.jasperreports.engine.JasperExportManager");//JasperExportManager.exportReportToPdfFile(jasperPrint, "C:ColdFusion8wwwrootjasperReportsimpleTest3.pdf");//connection.close();</cfscript>[/code]<H3>Success!</H3><A HREF="C:ColdFusion8wwwrootjasperReportsimpleTest3.pdf">SimpleTest.pdf</A>... I have the libraries into C:ColdFusion8wwwrootWEB-INFlibI'm using jasperreports 6.0 I get this error: Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBoxThe error occurred in C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm: line 4846 : 47 : jasperCompileManager = createObject("java", "net.sf.jasperreports.engine.JasperCompileManager"); 48 : jasper = jasperCompileManager.compileReportToFile("C:ColdFusion8wwwrootjasperReportreporte_ventas_cliente_v2.jrxml"); 49 : 50 : [/code]Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36Remote Address 192.168.1.75Referrer Date/Time 20-Feb-15 12:08 PM Stack Traceat cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 8; Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.startElement(Digester.java:1364) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.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.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:240) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:227) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:215) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:169) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:153) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:87) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)Caused by: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:70) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) at org.apache.commons.digester.Digester.startElement(Digester.java:1361) ... 52 moreNESTED BY :net.sf.jasperreports.engine.JRException: Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:244) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:227) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:215) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:169) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:153) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:81) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:87) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cfcoldFusionJasperReportsModParamLibs2ecfm1826676198.runPage(C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm:48) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)Caused by: org.xml.sax.SAXParseException; lineNumber: 19; columnNumber: 8; Error at line 19 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at org.apache.commons.digester.Digester.createSAXException(Digester.java:2919) at org.apache.commons.digester.Digester.createSAXException(Digester.java:2945) at org.apache.commons.digester.Digester.startElement(Digester.java:1364) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.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.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:240) ... 42 moreCaused by: java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:70) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:389) at org.apache.commons.digester.Digester.startElement(Digester.java:1361)[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now