Unable to load context from database

[Anonymous]

Hi,

I have a job as below

 I am trying to load the context of tmssqlinput from database. So the context details sit in loadcontext table in mysql. The table has the rows as shown below

Now, my when I get to the extra tab of the job the implicit job details are as follows..

And now when I go the contexts tab of the tmssqlcomponent, the details are as follows

Now when I run the job I get the error,

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
***cannot be resolved to a variable
****cannot be resolved to a variable
***cannot be resolved to a variable
*** cannot be resolved to a variable 

The *** is the username, password, databasename, and port, that I have hidden due to privacy guidelines

Any help on why I'm unable to get the context from database would be of great help

Thanks
Rathi

[Anonymous]

Have you defined the context variables in contexts tab?

[Anonymous]

Yes chirgal, I have defined them as context.host, context.port, context.database, context.username, context.password

[Anonymous]

The *** is the username, password, databasename, and port, that I have hidden due to privacy guidelines.

Referring to your above statements, I want to ask is, have you used double quotes while entering above value?

I suspect, you r missing double qoutes

[Anonymous]

Hi chirgal,

Yes, I had missed the double quotes. Thanks for that 🙂

But, I still get the same error when I run the job

Thanks
Rathi

[Anonymous]

It means you still missing somewhere.
How many errors are you getting now?

Which variables are unresolved now?

[Anonymous]

Hello,

Have you already checked this online document about:TalendHelpCentercenario: Reading data from different MySQL databases using dynamically loaded connec...?

Best regards

Sabrina