Rollback on duplicate key

One Star

Rollback on duplicate key

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

Six Stars

Re: Rollback on duplicate key

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

One Star

Re:Rollback on duplicate key

@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?

Six Stars

Re:Rollback on duplicate key

are you sure that you are not using auto-commit in the output component?

One Star

Re:Rollback on duplicate key

I have found the answer!
My table that I am trying to write is MyISAM which does not support transactions, what was I thinking?