[resolved] tContextLoad_1 not working with tMysqlInput_1 in example

One Star

[resolved] tContextLoad_1 not working with tMysqlInput_1 in example

I am test something with the tContextLoad component using example 


Up to tContextLoad_1 it works fine and I can see in the logging;

[statistics] connecting to socket on port 3530
[statistics] connected
tContextLoad_1 set key "host" with value "localhost"
tContextLoad_1 set key "port" with value "3306"
tContextLoad_1 set key "database" with value "dempproject"
tContextLoad_1 set key "username" with value "root"
tContextLoad_1 set key "password" with value ""

but the tMysqlInput_1 does not seem to recognize the context.host, context.port etc.

I tried it severaltimes but am getting the same error;

Error in the component's properties:username cannot be resolved or is not a field
password cannot be resolved or is not a field
host cannot be resolved or is not a field
port cannot be resolved or is not a field
database cannot be resolved or is not a field

any idea what I am doing wrong or maybe something in the example is missing?
Moderator

Re: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

Hi,

How did you set your tMysqlInput component? Could you please give us your component setting screenshot into forum? Did you set Context vaule into your DB parameter?

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.
One Star

Re: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

see my screenprint. I added the context.     values in the same way as in the example. The example metioned to use F5 but for some reason this did not seem to work.
Moderator

Re: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

Hi,

Did you refer to component reference TalendHelpCenter:tContextLoad with related scenario?

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.
One Star

Re: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

Moderator

Re: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

Hi,

It seems your screenshots are missing. Could you please check it?

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: [resolved] tContextLoad_1 not working with tMysqlInput_1 in example

host cannot be resolved or is not a field
You must be specifying your parameter to tMySQLInput_1 as - host
You need to specify - context.host

2019 GARTNER 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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog