Issue:
I built a simple report in iReport that has one parameter and calls an Oracle stored procedure for the query. The report runs in iReport but when I try to deploy the report to the report server, I get this error message: The selected JRXML could not be parsed. You might have selected the wrong file.
Reports that use an SQL query instead of a stored procedure are working. What do I need to do to get the stored procedure to work?
Resolution:
Add the following line to ..WEB-INFclassesjasperreports.properties:
net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory
Change the queryLanguages property in ..WEB-INFflowsqueryBeans.xml to include "plsql":
<property name="queryLanguages"> <list> <value>sql</value> <value>plsql</value> <value>hql</value> <value>domain</value> <value>sl</value> <value>HiveQL</value> </list> </property>
Add "plsql" and "PLSQL" to two sections of ..WEB-INFapplicationContext.xml:
<property name="supportedQueryLanguages"> <set> <value>sql</value> <value>plsql</value> <value>SQL</value> <value>PLSQL</value> </set> </property>
Copy ..ireportmodulesextjasperreports-extensions-3.5.3.jar to ..WEB-INFlib
Re-start server
Ref. Case #00024234 -- 19:55, 31 January 2012 (UTC)
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now