topic tMysqlOutput doesn't populate table if using existing connection in Talend Studio

tMysqlOutput doesn't populate table if using existing connection

Anonymous — Sat, 16 Nov 2024 11:56:49 GMT

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.....

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

alevy — Sun, 11 Aug 2013 05:26:56 GMT

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.

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

benu — Thu, 07 Aug 2014 23:50:54 GMT

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