Jump to content
Changes to the Jaspersoft community edition download ×

prp.bed

Members
  • Posts

    1
  • Joined

  • Last visited

prp.bed's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. I am calling stored procedure in iReport. Its working fine. reff below screen 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...