How to call MySQL stored procedure from Talend java version

One Star

How to call MySQL stored procedure from Talend java version

Hello ,
How can I call a MySQL procedure from the talend . I think I have to use the tMySQLRow to do this. But I dont know how to call this. My Procedure may have some out parameters which I want to use in my transformation. How should I go about it. Is the tMySQLRow something like tJavaRow. Can you please explain me what is the use of tMySQLrow and how to use it in case of procedures and other wise.
One Star

Re: How to call MySQL stored procedure from Talend java version

Hi,
You can search Talend Documentation and you'll find a good tutorial.
Just search for the following:
"Scenario: Checking number format using a stored procedure"
One Star

Re: How to call MySQL stored procedure from Talend java version

Hi
i have the same problem, my job is o list files from a folder and with listed file name i should check in database table for some status value and insert or update operation based on the status.
tfilelsit tmysqlsp tlogrow
i tried using this component and my procedure should take file name as input how to pass filename to procedure
One Star

Re: How to call MySQL stored procedure from Talend java version

or how to call stored procedure in tmysqlrow component
One Star

Re: How to call MySQL stored procedure from Talend java version

how to call this in tmysqlrow "call file_check_update('"+((String)globalMap.get("tFileList_1_CURRENT_FILE"))+"',@out);"
and capture @out value to tmysqlrow schema
Moderator

Re: How to call MySQL stored procedure from Talend java version

Hi,
What's your current job requirement? Call stored procedure?
Did you checked the online document TalendHelpCenter:Calling a stored procedure or function.
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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now

Data Integration Success Stories

Take a look at some Data Integration success stories

Read