Jump to content
We've recently updated our Privacy Statement, available here ×

prp.bed

Members
  • Posts

    1
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by prp.bed

  1. I am calling stored procedure in iReport. Its working fine. reff below screen

    converted-file.png.f1abb6d88423d350a76b1b83452c11c2.png

     

    But if tried from my Application , Its give error like....

    18:26:22,063 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/reports].[abc]] (http-localhost-127.0.0.1-8080-1) Servlet.service() for servlet abc threw exception: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.
        at net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getExecuterFactory(JRQueryExecuterUtils.java:114) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1110) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:287) [jasperreports-5.6.1.jar:5.6.1]
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:760) [jasperreports-5.6.1.jar:5.6.1]
        at com.report.export.ExportData.service(ExportData.java:159) [classes:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]
        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]
        at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27]
     

    JavaCode

     parameterMap.put("@fromDate","05/08/2013");
     parameterMap.put("@toDate", "29/09/2014");
     parameterMap.put("@tripType",null );
     parameterMap.put("@trStatus", null);
     connection = DbConnection.connect();  
     String reportName = "D:/Prashant/projects/TG2.1-Reports25.09.2014/tr_status.jasper";

    OutputStream ouputStream = res.getOutputStream();
     JasperPrint print = JasperFillManager.fillReport(reportName, parameterMap, connection);                
     JasperExportManager.exportReportToPdfStream(print, ouputStream);
     System.out.println("#### Exported to PDF ####");

     

    I am struggling since from 1 week. Plz provide me a solution soon

×
×
  • Create New...