tJasperReportExec Error and a Template using PLSQL

Four Stars

tJasperReportExec Error and a Template using PLSQL

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


Accepted Solutions
Forteen Stars

Re: tJasperReportExec Error and a Template using PLSQL

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

 

-----------

All Replies
Forteen Stars

Re: tJasperReportExec Error and a Template using PLSQL

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

 

-----------
Four Stars

Re: tJasperReportExec Error and a Template using PLSQL

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog