CSV to MySQL DB not updating

[JSey]

Hi

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.

[nivedhitha · Accepted solution]

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

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

[JSey]

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!