Five Stars

how to update key value in talend with tmysqloutput component

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

 

 

  • Data Integration
5 REPLIES
Moderator

Re: how to update key value in talend with tmysqloutput component

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: how to update key value in talend with tmysqloutput component

hi  xdshi,

thanks for giving answer 

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

 

Thanks

Abhi529

Tags (1)
Moderator

Re: how to update key value in talend with tmysqloutput component

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Ten Stars

Re: how to update key value in talend with tmysqloutput component

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

Re: how to update key value in talend with tmysqloutput component

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.