topic Re: Rollback on duplicate key in Talend Studio

Rollback on duplicate key

Anonymous — Sat, 16 Nov 2024 13:49:54 GMT

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

Re: Rollback on duplicate key

Anonymous — Tue, 11 Aug 2009 16:31:19 GMT

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

Re: Rollback on duplicate key

Anonymous — Tue, 11 Aug 2009 16:39:11 GMT

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

Re: Rollback on duplicate key

Anonymous — Tue, 11 Aug 2009 16:53:02 GMT

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

Re: Rollback on duplicate key

Anonymous — Tue, 11 Aug 2009 17:01:09 GMT

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