how to update key value in talend with tmysqloutput component

[Anonymous]

My scenario is like, I have the tMysqloutput component is like as follows

tmysqloutput---> Basic settings --->Action on table is Default  and Action on Data is Update

 tmysqloutput---> Advanced settings-----> Use field options 

You can find the image in the attachment 

In the image you can observe, I want to update indicator (indicator is key column also), but i am unable to update the indicator

Thanks in Advance,

Abhi529

[Anonymous]

Hello,

You have a primary key defined in the schema?

In Java project, there is a 'die on error' option on the compopnent. Please check it to see if you can catch some error when try to update your key value in your job?

Best regards

Sabrina

[Anonymous]

hi  @xdshi,

thanks for giving answer 

it did not throw any errors but required column is not updated....

Thanks

Abhi529

[Anonymous]

Hello,

Have you already defined a primary key in the schema? Could you please also post your basic settings of your tMySqlOutput component screenshot here(please mask your sensitive data)

Best regards

Sabrina

[cterenzi]

If you want to update indicator, you'll have to specify a different column to use as the key in your output component.

[Anonymous]

Hello,

Is your issue fixed now? Feel free to post your issue here.

Best regards

Sabrina