topic Re: Talend - tmysqlcommit with tmysqloutput - error in Talend Studio

Talend - tmysqlcommit with tmysqloutput - error

Anonymous — Thu, 08 Jun 2017 14:16:03 GMT

Hi,

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

Re: Talend - tmysqlcommit with tmysqloutput - error

cterenzi — Thu, 08 Jun 2017 14:29:03 GMT

Configure a tMysqlConnection component with your connection details. For your input, output and commit components, check "Use an existing connection" and select your tMysqlConnection from the dropdown list that appears.

Re: Talend - tmysqlcommit with tmysqloutput - error

Anonymous — Thu, 08 Jun 2017 14:32:56 GMT

Thanks cterenzi.

So, will the tmysqlconnection remain floating in the design and would not be connected to any other component?

Re: Talend - tmysqlcommit with tmysqloutput - error

cterenzi — Thu, 08 Jun 2017 16:53:52 GMT

I typically make it the first component to execute by connecting it to the rest of the job with an OnSubJobOK connection, but I'm lazy. Probably the best practice is to connect a tPrejob component (OnComponentOK) to tMysqlConnection. Then connect a tPostjob component to tMysqlClose. This will ensure that your connection is established before the rest of the job runs and that it is closed, even if the main job experiences an exception.

Re: Talend - tmysqlcommit with tmysqloutput - error

Anonymous — Fri, 09 Jun 2017 07:19:37 GMT

Hi citerenzi,

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?

Thanks

Rathi

Re: Talend - tmysqlcommit with tmysqloutput - error

Anonymous — Fri, 09 Jun 2017 11:40:01 GMT

Hi,

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

Thanks

Rathi