Error when deploying JRXML file that uses Oracle stored procedure

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:

1. 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>
   

2. 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>
   

3. Copy ..ireportmodulesextjasperreports-extensions-3.5.3.jar to ..WEB-INFlib

4. Re-start server

Ref. Case #00024234 -- 19:55, 31 January 2012 (UTC)