tJasperReportExec Error and a Template using PLSQL

[Ulonis]

Hello,

I've got a problem with the tJapserReportExec module.

As the subject already told, I tried to run a job using this module. I implemented a report template using a SQL procedure in plsql.

I already tried it with a dummy-SQL request and it worked. When I run the actual Report in Jaspersoft Studio it works as well. Only the module throws the following error:

Exception in component tJasperReportExec_1
net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 20; columnNumber: 16; Error at line 20 char 16: No query executer factory registered for the "plsql" language.

(This is only a little extract. The complete error got like 70 rows and I dont want to fill this post unnecessarily. If u need the complete error, then pls ask for it.)

Can somebody help me here?

Thank you,

Ulonis

[vapukov · Accepted solution]

if search by this error code - You find a lot of Jasper links about similar problems (including and jasper Server)

https://www.google.com/search?client=safari&rls=en&q=no+query+executer+factory+registered+for+the+%2...

https://community.jaspersoft.com/wiki/config-stored-procedures-jasperreports-server-55

https://community.jaspersoft.com/questions/843923/no-query-executer-factory-registered-plsql-languag...

This is component designed by one of community member, may be he could help You

as bypass solution - could You realise the same without stored procedure?
Variants:

- plain query in Report
- use the same stored procedure but on 1 step before and store data to XML 
- same as XML - but prepare temp tables on server and design report from this tables

[Ulonis]

Thank you for your help/ suggestions.

In the meantime I experimented a bit with creating a CSV file and using it.

Last but not least I found the following "Solution":

I use the SQL Script of the procedure in a tMSSqlInput and extract the needed Data to a temp Oracle table.

(tMSSqlSP doesnt work with this procedure as well)

After that I read the Data of this new table in Jaspersoft Studio and create the report with this.

With a tOracleConnection the tJasperResportExec now is working as well.

(After a few restarts of the Jobs because of the known "The method **** is undefined for **** exception.)

I still took a look after your links and variants. They shoudlve worked as well for me. So ill accept your answer as possible Solution

Edit: Typo