I am unable to call the stored procedure using Jasper Reports in my web app. The log file reports:
Caused by: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.
net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 17; columnNumber: 16; Error at line 17 char 16: No query executer factory registered for the 'plsql' language
.
From what I have searched, I'm supposed to add the jasperreports-extension jar, and register the plSQL query executor factory. No one has actually shown how to do this. When I tried, it failed because the problem I am facing here looks like this (code snippet follows):
JasperDesign jasperDesign = JRXmlLoader.load(reportInputStream);//fails!
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
jasperReport.setProperty( "net.sf.jasperreports.query.executer.factory.plsql"
,"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");
Before I can set the PlSqlQueryExecuterFactory, the program has already failed when it tries to load the jrxml file.
Can anyone help?
