Cannot parse JRXML

[randallsims]

Hello!

I'm pretty new to Jasper products. Here's what's happening. I have a report that uses plsql. I made the changes to iReport so that this would be possible, as well as connecting to an Oracle server. I setup a JasperServer so I can test my reports in something other than previews, but when I go to import the JRXML file, I get the following error:

The selected JRXML could not be parsed. You might have selected the wrong file.

The error file shows the following:

ERROR Digester,http-8080-2:1132 - End event threw exception java.lang.reflect.InvocationTargetException

(Lots of lines...)

Caused by: net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the 'plsql' language.

These are the steps I have taken to try to get this running, but I still get the same error:

Put a copy of ojdbc6.jar in the ..\jasperreports-server-cp-4.5.0\apache-tomcat\lib directory

Successfully created a data source to the oracle database

Put the following line in the jasperReports.properties file: 

net.sf.jasperreports.query.executer.factory.plsql=com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory

Edited queryBeans.xml and applicationContext.xml, adding values of "plsql" anywhere I found values of "sql".

Your help is greatly appreciated!

Randy 

 

 

[tkavanagh]

Hi Randy,

There is actually a JasperForge.org project so support PL/SQL. I don't think there is any actual code required, it is just configuration.

[elizam]

Actually, you do need to download some code, which is also available on the same page.  Click on the "Source" menu item and you will find downloadable source there. Then use the doc mentioned above to help you configure it.