topic plsql error using tJasperReportExec in Talend Studio

plsql error using tJasperReportExec

_AnonymousUser — Mon, 19 Jan 2015 03:50:33 GMT

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.

Re: plsql error using tJasperReportExec

Anonymous — Tue, 20 Jan 2015 08:59:46 GMT

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

Re: plsql error using tJasperReportExec

_AnonymousUser — Tue, 20 Jan 2015 15:02:59 GMT

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

Re: plsql error using tJasperReportExec

Anonymous — Tue, 20 Jan 2015 20:14:22 GMT

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

Re: plsql error using tJasperReportExec

_AnonymousUser — Wed, 21 Jan 2015 05:25:06 GMT

That is great much appreciated.

Re: plsql error using tJasperReportExec

_AnonymousUser — Mon, 26 Jan 2015 21:29:06 GMT

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?

Re: plsql error using tJasperReportExec

Anonymous — Tue, 27 Jan 2015 07:07:55 GMT

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.