unable to call Oracle storedproc from web app

[leslie-lim]

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?