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
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.