topic Cannot insert rows into a database in Talend Studio

Cannot insert rows into a database

Anonymous — Sat, 16 Nov 2024 08:20:36 GMT

Hi,

I have tried to insert a row into a database Mysql, Sqlite etc... and it does not work well. I did not receive any errors and I use "auto commit" and my table is empty all time

My Talend ESB is 6.5 in Ubuntu 16

thanks for your help

regards

Javier

Re: Cannot insert rows into a database

Anonymous — Thu, 26 Apr 2018 04:50:55 GMT

Can you provide a screenshot of the job, in particular interested in the components for the database and the schema of the data.

If no data is being saved but the job is running successfully it maybe that the database is generating an error that talend does not capture (i.e. out of bound date range on MS SQL Server). Check the schema for the data and the schema for the database, would be first steps.

Re: Cannot insert rows into a database

Anonymous — Thu, 26 Apr 2018 19:30:03 GMT

Thanks for the update

https://vimeo.com/266740780

I send the screen shot, I also used the SQlite

regards

Javier

Re: Cannot insert rows into a database

Anonymous — Thu, 26 Apr 2018 22:29:50 GMT

Javier,

Thanks for the vid. Very helpful..

The reason the database is not inserting any records is that the rows from the main job are not connected to the database subjob. If you simply connect the database output component to the xmlmap it should insert without any issues ( See attached). The video didn't show to the right of the job but if there is additional processing you can use the "On component Ok" link to continue, such as send an email in the attached example.

Hope this helps

talend.jpg