tMysqlOutput doesn't populate table if using existing connection

One Star

tMysqlOutput doesn't populate table if using existing connection

Here is a weird one for you. I have a simple job:
tMysqlConnection -> tSalesforceInput -> tMysqlOutput -> tLogRow
If I use the existing connection from the tMysqlConnection, then the tMysqlOutput will create the table, but there will be no data in it. If I don't use an existing connection but specify connection parameters in the tMysqlOutput, then the table gets created and there is data in it. In both cases the tLogRow shows the exact same row set that comes from the tSalesforceInput.
This tells me that the login credentials from the tMysqlConnection are correct because the tMysqlOutput creates the table - it could not do that if the host/userid/password/database were incorrect. It just won't put any data in it.
At this point I'm totally stumped.....
Seven Stars

Re: tMysqlOutput doesn't populate table if using existing connection

Unless you've checked "Auto-commit" in the advanced settings of tMysqlConnection or used a tMysqlCommit, the rows you attempt to insert will not be committed to the database when using an existing connection. The table creation is always automatically committed.
One Star

Re: tMysqlOutput doesn't populate table if using existing connection

This really helped me out - thanks folks! My post for this issue: http://www.talendforge.org/forum/viewtopic.php?id=37636
-Ben