plsql error using tJasperReportExec

One Star

plsql error using tJasperReportExec

I am using Talend Open Studio for Data Integration 5.6 using tJasperReportExec to create a report from a jasper jrxml file.  My report runs fine in Jasper studio 5.6 and it runs fine on jasper server 5.6. When I run it in Talend Open Studio for Data Integration using tJasperReportExec. I get the following error: net.sf.jasperreports.engine.JRException: org.xml.sax.SAXParseException; lineNumber: 18; columnNumber: 16; Error at line 18 char 16: No query executer factory registered for the 'plsql' language.
Moderator

Re: plsql error using tJasperReportExec

Hi,
tJasperReportExec is custom component developed by Talend Community user and shared on Talend Exchange.
You'd better contact to the author jlolling directly.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: plsql error using tJasperReportExec

Thanks will contact the developer.  However I also tried using tJasperOutput and got the same error message.
Dennis
Seventeen Stars

Re: plsql error using tJasperReportExec

Hi Dennis, I will check whats necessary to run PL/SQL queries. I am a bit surprised because it is a seldom use case.
One Star

Re: plsql error using tJasperReportExec

That is great much appreciated.
One Star

Re: plsql error using tJasperReportExec

I have worked around the plsql stored procedure for the short term, while you are looking into what it will take for tJasperReportExec to use plsql. I can make the report run using tJasperReportExec with hardcoding the value in the value column for tJasperReportExec. I need to use a variable in value column for the report parameters.  Like row1.centerid that I have used with other ETL components.  I am using tOracleInput to fetch rows from the database and want to use values coming back as input to tJasperReportExec.  How can this be done?
Seventeen Stars

Re: plsql error using tJasperReportExec

I guess you write the call to the stored procedure with the parameter as literals, right?
You can send the component parameters (the parameters you have defined in your report) and use them in the call.
I am not pretty much convinced you could not simply use the SQL type for the queries. I will try it in my own environment and get back to you this evening.

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

Downloads and Trials

Test drive Talend's enterprise products.

Downloads