I want to call a MySQL stored proc. So I have started developing a couple of Proof Of Concept jobs to work out how this is done. I found the tMysqlSP component and have the following scenario I want to do:
Call stored proc that has one IN param and a couple of OUT params and produces no result data.
To do this I have created a job with the following:
The tFixedFlowinput has the following schema:
It has a single value of "5" assigned to the param_ID column.
The tMysqlSP has the following schema:
Column Type ---> Column Type
param_ID Integer param_ID Integer
The tMysqlSP has the following parameters defined:
Schema Column Type
The SP Name is "etl_test_out_param_proc"
In the db the "etl_test_out_param_proc" has the following:
DROP PROCEDURE IF EXISTS etl_test_out_param_proc$$
CREATE DEFINER = 'root'@'localhost'
PROCEDURE etl_test_out_param_proc (IN param_ID int, OUT param_Login varchar(255), OUT param_Active varchar(255))
-- Simulate Looking Up User Details
'Active' INTO param_Login, param_Active;
I have tested this procedure using the db directly and it works fine.
The tLogRow was just connected to tMysqlSP and the "Sync columns" was pressed.
When I run this job I get the following error:
Starting job StoredProcDemo at 15:26 05/10/2015.
[statistics] connecting to socket on port 3986
Exception in component tMysqlSP_2
Job StoredProcDemo ended at 15:26 05/10/2015. [exit code=1]
What I have done wrong here?
Thanks for your time,
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks