tDBOutput not working

[Anonymous]

Hi there,

I am new to Talend Studio (7.2.1.20190620_1446) and I am trying to write data to a MySQL database. I managed to establish a connection, filter/map the data with tMap and supposedly write to another MySQL database without any errors showing on the console, but when I look into the DB only the table has been created, but no rows have been inserted. I thought, that maybe I am doing something wrong, so I decided to follow a simple tutorial (https://help.talend.com/reader/NNO~fmVQU4rlkF9Depfdxw/uj2eSVb5v6PKRMENQIBlVA), but even writing the current date to a db fails. So I wonder: what is the trick? Any suggestions?

Kind regards,

Erik 

[Anonymous · Accepted solution]

Are you committing your transaction(s)? If not then you'll need to use a tMySqlCommit or check 'Auto Commit' in the advanced options of the connection component.