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