I am trying to test talend's rollback mechanism but I cannot make it work.
I have searched forums, tried various things and I still cannot manage to make rollback procedure work.
I have 4 rows in a csv file and the 3rd is a duplicate row.
You can look at the screenshots for the details.
When I run the Father job I get:
Exception in component tMysqlOutput_1
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1' for key 'PRIMARY'
and when I look at the DB I see 2 rows inserted and not rolled back. What am I missing?
Thank you for your answers
Seems that you are using two different connections. Provide details.
Seems also that you need to rollback on the child job and not on parent unless you are using a "shared" connection ( new feature of talend ) between parent and child.
@emaxt6: Thank you for your quick answer. They are sharing the same connection.
I have included rollback mechanisms into the child job and run child job (not father), but I still get the same error and it does not roll back.
(MysqlOutput is using existing connection)
What details should I provide further?