[resolved] tMySQLOutput creates table but does not insert rows

Highlighted
One Star

[resolved] tMySQLOutput creates table but does not insert rows

I've got a simple job that extracts 7 rows using a tSalesforceInput and sends that data to a tMySQLOutput. I have the tMySQLOutput set to "Drop table if exists and create" and "Action on data" is "Insert". The chain of components is like this:
tSalesforceConnection --OnSubjobOk--> tMySQLConnection --OnSubjobOk--> tSalesforceInput --main--> tMySQLOutput --main--> tLogRow
The connections succeed. The Salesforce query succeeds. The table gets created in the MySQL DB. However, the rows do not get inserted. I also get all rows output to the tLogRow.
I've checked permissions for the MySQL user account - they seem correct. They're obviously good enough to create a table, and I see I've granted all the other DML rights, too (INSERT, DELETE, EXECUTE, etc. - all of them). I've also executed an insert using the MySQLWorkbench client, which succeeded - from the same client workstation upon which I run the Talend job in-question.
I'm stumped - any suggestions out there? Thanks in-advance.
-Ben

Accepted Solutions
One Star

Re: [resolved] tMySQLOutput creates table but does not insert rows

Solved. This was pretty damn infuriating. It turned out to be the "Auto Commit" setting on the tMySQLConnection component. It's off by default, and if you don't set it, any components that use the connection will not commit their transactions.
There went a whole day of troubleshooting. Anyway, glad I found this post:
http://www.talendforge.org/forum/viewtopic.php?id=31128
Thanks zootal and alevy!
-Ben

All Replies
One Star

Re: [resolved] tMySQLOutput creates table but does not insert rows

Solved. This was pretty damn infuriating. It turned out to be the "Auto Commit" setting on the tMySQLConnection component. It's off by default, and if you don't set it, any components that use the connection will not commit their transactions.
There went a whole day of troubleshooting. Anyway, glad I found this post:
http://www.talendforge.org/forum/viewtopic.php?id=31128
Thanks zootal and alevy!
-Ben
One Star

Re: [resolved] tMySQLOutput creates table but does not insert rows

Thanks, I had the exact same problem, and this solved it.
Four Stars

Re: [resolved] tMySQLOutput creates table but does not insert rows

Thanks you all,
I faced the same issue and it's resolved now.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read