topic Re: How to call MySQL stored procedure from Talend java version in Installing and Upgrading

How to call MySQL stored procedure from Talend java version

Anonymous — Sat, 16 Nov 2024 14:37:15 GMT

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.

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

_AnonymousUser — Tue, 08 Sep 2009 14:25:52 GMT

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"

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

Anonymous — Fri, 20 Dec 2013 09:35:05 GMT

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

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

Anonymous — Fri, 20 Dec 2013 09:37:58 GMT

or how to call stored procedure in tmysqlrow component

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

Anonymous — Fri, 20 Dec 2013 09:56:11 GMT

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

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

Anonymous — Thu, 26 Dec 2013 03:13:32 GMT

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