how to update key value in talend with tmysqloutput component

Six 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

 

 

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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads