You are not logged in.
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
Last edited by baris.evrim (2009-08-11 18:01:33)
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?
Last edited by baris.evrim (2009-08-11 17:40:12)