No query executer factory registered for the 'plsql' language

[prp.bed]

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

[ghudson_1]

Hi, searching the community for "net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language", then filtering by 'wiki' shows a few helpful results, like:

http://community.jaspersoft.com/wiki/config-stored-procedures-jasperreports-server-55

So essentially you need to add a jar and a value to your .properties