[JasperServer set a dynamical image]

Hi, I'm trying to display a dynamic image. In JasperStudio I added a image with custom expression like this: "repo:/Images/" + $P{name} + ".jpg". In my JasperServer repository have severeal images and when I run the report, I send a image name with P{name} parameter and I got this error "Byte data not found at : repo:/Images/name1.jpg"

Any idea? thanks

[JasperServer how consult multiple data bases]

Thanks for the answer, if I understood correctly, the parametrize JDBC URL take the parameters from the attributes defined from the user, organization or server, but I have to take the parameter "database" dynamically from a report parameter

 

Thanks

[JasperServer how consult multiple data bases]

Hi, I have a report in jasperserver that have a datasource point to a database "dbA", in my report I have a query that calls a stored procedure in that data base "exec SP Parameter1, Parameter2..."

and works fine, but now I have to call the same report but consulting others databases dbB, dbC... that have the same stored procedure "SP", i.e. the same report with diferent data depending of what database is consulting, in my web application I have acces to a parameter that tells me what database is used, Any idea how can I achievement this?

 

Thanks!

[JasperServer how to change location]

I need to change the location to Español (Mexico) for a correct numer format, if I click in regional configuration in login page, show just  "es_ES(Español España)" ..and others, but not Español, Mexico. Actually I changed my system regional configuration but nothing happened.

 

Thanks for your help!

[JasperServer default XLS Export]

Thanks! it works with &output=xls parameter in the HTTP API Call

 

Regards.

[JasperServer default XLS Export]

Hi, I have a report in JasperServer embedding via iFrame like this:

<iframe height=100% width=100% seamless id="frame1" name="frame1" frameborder="0" marginheight="0" marginwidth="0" src="server:port/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2FReporte_Ventas_Cliente_Under_Armour_Mexico&j_acegi_security_check&j_username=jasperadmin&j_password=jasperadmin&decorate=no</cfoutput>">

Ant that give me the standard view of jasperserver where I can export to pdf, xls, etc,  but i'd like to access direct to xls view, is there a way for accomplish it?

 

Thanks.

[How to pass a variable parameter to iFrame]

Thanks for the reply. Thats what i'm doing

 

http.......&empId=1&fecha1=20140801&fecha2=20140802&cliente=0&sitio=0&userId=1

 

and it works, but my parameter empId, fecha1,... are variables in my web application, non static, so if I try something like that in my html page application:

 

empIdVar=#URL.empId#

..

[How to pass a variable parameter to iFrame]

Hi, I have my report on jasperserver, and i call it on my web application via iFrame like this:

<iframe height=750px width=1500px seamless id="frame1" name="frame1" scroll="no"        frameborder="0" onload='javascript:resizeIframe(this);'         src="http://server:port/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2Fventas_cliente_v2&j_acegi_security_check&j_username=jasperadmin&j_password=jasperadmin&decorate=no&empId=1&fecha1=20140801&fecha2=20140802&cliente=0&sitio=0&userId=1" ></iframe>[/code]

that works fine, but my parameters empId, fecha1, etc, needs to be variables, any idea?

Thaks!

[Error creating SAX parser]

Hi,

I need to compile and fill a JRXML file with Coldfusion, so i made a java proyect (packet in jar file) that do that, and the jar file placed it into application/wwwroot/web-inf/lib in that folder I placed jasper-reports-6.0 common-logging-1.1.1 common-digester-2.1 common-collections-3.2 common-beanutils1.9.0 xalan xerces-Impl-2.10.0
but when i call the compile method, I get this stack trace:

thank for your suggests

net.sf.jasperreports.engine.JRRuntimeException: Error creating SAX parser at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:99) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1504) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1480) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:262) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:218) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:193) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:184) at net.sf.jasperreports.engine.JasperCompileManager.compileToFile(JasperCompileManager.java:224) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:539) at report_compile.CompilingJrxml.compilar(CompilingJrxml.java:13) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:97) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfcoldFusionJasperReportsModParamLibs2ecfm2056129461.runPage(C:ColdFusion11cfusionwwwrootcoldFusionJasperReportsModParamLibs.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.xml.sax.SAXNotSupportedException: Property 'http://java.sun.com/xml/jaxp/properties/schemaLanguage' must be set before setting property 'http://java.sun.com/xml/jaxp/properties/schemaSource'. at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.setProperty(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl.setProperty(Unknown Source) at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.configureParser(BaseSaxParserFactory.java:134) at net.sf.jasperreports.engine.xml.BaseSaxParserFactory.createParser(BaseSaxParserFactory.java:94) ... 59 more[/code]

 

[net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox]

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-INFlib

I'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.JRBox

The error occurred in C:ColdFusion8wwwrootcoldFusionJasperReportsModParamLibs.cfm: line 48

46 : 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.36 Remote Address   192.168.1.75 Referrer     Date/Time   20-Feb-15 12:08 PM

 

Stack Trace

at 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]

[Error creating SAX parser - compiling with coldfusion]

Hi, i'm trying to compile a .jrxml with jasperreports api on coldfusion. Before, I made a java class that works fine, generate the .jasper file, all allright, but I need to do this on coldfusion, then I made a .jar that contain my compile class in java, I imported that .jar in my coldfusion script classpath and call to compile method like this:

<cfscript>

 

system = CreateObject("java", "java.lang.System");

classpath = system.getProperty("java.class.path");

if (FindNoCase("jasperreports", classpath) LTE 0)

{

 classpath = classpath & ";C:ColdFusion11cfusionwwwrootWEB-INFlibMerlia.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibjasperreports-6.0.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-beanutils-1.9.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-collections-3.2.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-digester-2.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-javaflow-20060411.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibcommons-logging-1.1.1.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibxercesImpl-2.10.0.jar;C:ColdFusion11cfusionwwwrootWEB-INFlibReporteVentasCliente.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 = "usuario";

password = "password";

 

connection = driverManager.getConnection(conurl, login, password);

 

//////////////////////////////////////////////

// PROYECTO JAR TEST 

 

reportXml = createObject("java", "report_compile.CompilingJrxml");

jasperReport = reportXml.compilar("C:ColdFusion11cfusionwwwrootjasperReportsimpleTest3.jrxml");

 

...

</cfscript>

 

I got this error: 

Error creating SAX parser The error occurred in C:/ColdFusion11/cfusion/wwwroot/coldFusionJasperReportsModParamLibs.cfm: line 30 Stack Trace at cfcoldFusionJasperReportsModParamLibs2ecfm2056129461.runPage(C:/ColdFusion11/cfusion/wwwroot/coldFusionJasperReportsModParamLibs.cfm:30)

 

[Stored Procedure Exception: La instrucción no devolvio un conjunto de resultados]

yes, i tested with sql and plsql and the result is the same

[Stored Procedure Exception: La instrucción no devolvio un conjunto de resultados]

Hi, i'm trying to call a stored procedure from JasperSoft Studio 5.6.2, The stored procedure is allocated in a bd SQL SERVER, i'm using sqljdbc4 connector

The parameters of sp are: @emp_id tinyint, @fecha1 char(8),  @fecha2 char(8), @cliente int,  @sitio varchar(200), @usu_id int

and i'm calling the sp like this:

execute rep_dr_ventas_cli_sec_nx 1,'20140801','20140802',0,'0',1

i get this Exception:

La instrucción no devolvió un conjunto de resultados

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Blank_A4_Landscape

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)

at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:67)

at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:75)

at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:359)

at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:54)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: La instrucción no devolvió un conjunto de resultados.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:408)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)

... 5 more

 

 

..Any idea?, Thanks!