I have a talend job, with the following sequence
tmssqlinput --> tmap --> tmysqloutput |onsubjobok tmssqlrow
I do want the autocommit option in tmysqloutput. I want to use the tmysqlcommit, but how should I used it? I have already determined the connection details in tmysqloutput.
If I connect tmysqloutput to tmysqlcommit, I get an error in the 'Component list' of tmysqloutput. It is expecting a value there and its drop down with no values in it
How do I use tmysqlcommit in this scenario?
Thanks in advance Rathi
Solved! Go to Solution.
So, will the tmysqlconnection remain floating in the design and would not be connected to any other component?
Thanks for the explanation, that is one complete solution!!
However, I have 20 - 25 jobs running in parallel and each job is similar to the job I have described in the main topic.
So, for each of these parallel jobs, should I open and close the connection to mysql? Will this cause any issue in mysql?
I guess I will start the above comment as a separate discussion.
The answer to this topic was given and has been accepted as solution
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema