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.
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"
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
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
