[resolved] Standalone tMysqlRow component with INSERT query does not insert row

Anonymous — Sat, 16 Nov 2024 11:01:27 GMT

Hi there,
I have a job with two components on it. A tMysqlConnection and a tMysqlRow. The tMysqlRow uses the tMysqlConnection.
The tMysqlRow has an INSERT query that I have tested on the db outside of Talend and it works fine.
When I run the job, I get now errors, but when I look in the database after the job has run, there is no new record in the target table.
Is there something I have to do to get the tMysqlRow component to fire?
Regards,
Scott

Re: [resolved] Standalone tMysqlRow component with INSERT query does not insert row

Anonymous — Tue, 29 Sep 2015 10:23:57 GMT

Ok, just worked this out. I had to tick Auto Commit in the Advanced Settings of the tMysqlConnection. I also added a OnComponentOk connection between the tMysqlConnection and the tMysqlRow components, however that part is not needed to make it work.
Hopefully this helps someone.
Regards,
Scott

topic [resolved] Standalone tMysqlRow component with INSERT query does not insert row in Talend Studio

[resolved] Standalone tMysqlRow component with INSERT query does not insert row

Re: [resolved] Standalone tMysqlRow component with INSERT query does not insert row