topic CSV to MySQL DB not updating in Talend Studio

CSV to MySQL DB not updating

JSey — Sat, 16 Nov 2024 03:04:14 GMT

I have a tfileoutputdelimited that creates a csv file, which goes to a tmap, then goes to a tdboutput which goes to a mysql db. When I run the job, it says 1 row is being sent to the mysql db, but when I query the mysql db the row is not being updated.

From the tfileoutdelimited schema, the id column (sql_id) is set as key.

Job design:

Tmap:

I'm positive the slight transformation for ID is fine, as the output matches the value in the id in the sql db.

tdboutput:

Schema:

Any suggestions would be appreciated, thanks.

Re: CSV to MySQL DB not updating

nivedhitha — Thu, 05 Mar 2020 18:08:49 GMT

@JSey , i see that you are using a connection component. Is the commit option checked?

Also Relational.ISNULL(columnname) works better than columname==null

Re: CSV to MySQL DB not updating

JSey — Thu, 05 Mar 2020 18:21:25 GMT

Hi Nive

Thank you for the suggestion. Do you mean on the tDBconnection, "Auto commit" should be set to true?

PS. Perfect, that worked, thanks!