topic [resolved] delete on database using tMSSqlOutput not working in Talend Studio

[resolved] delete on database using tMSSqlOutput not working

Anonymous — Tue, 23 Oct 2012 10:24:27 GMT

I have a simple job that get an id value as parameter via an SOAP request and delete row on 2 tables according the id value as criteria.
When I run the job the execution works fine and there is no error but, the rows are not deleted in the database. It's like there is no commit.
Any idea?

Thanks for your help

Re: [resolved] delete on database using tMSSqlOutput not working

janhess — Tue, 23 Oct 2012 11:04:13 GMT

Have you used the reject link to a tLogRow on the database output to check errors? Does the deleted record have the key set for a record match?

Re: [resolved] delete on database using tMSSqlOutput not working

Anonymous — Wed, 24 Oct 2012 09:16:36 GMT

I have configured the tXMLMap in order to use the reject link that I have called join_errors (Catch output reject and catch lookup Inner join reject set to true) and nothing is catched. the tlogRow displays:
.-----------------.
| tLogRow_1 |
|=---------------=|
|processInstanceId|
|=---------------=|
'-----------------'

Does the deleted record have the key set for a record match? What do you exactly mean?
Thank you.

Re: [resolved] delete on database using tMSSqlOutput not working

Anonymous — Wed, 24 Oct 2012 11:34:17 GMT

Thanks Janhess. Such as you I have found. The deleted record must have the key set for the record match indeed.
On the tMSSqlRow component:
1. Simple parmeters
2. edit schema
3. swich to built-In mode
4. on the right panel, the one corresponding to the output, check the key box on the field you want to match the delete