One Star

Context parameter used in Oracle connection

Hi,
Using context parameter in creation of  Oracle connection failed. Here is background
1. create Oracle connection (SID) use hard coded parameters such as Host, Schema, Username, Password - success
2. create context, read, load context, and use tJava to print them (context.Host, context.Schema, context.Username.....) - success
3. drop context to the job or context tab - success and show on list
4. replace any Oracle connection parameter (such as Host, or Username, or Schema....) with context.xxx parameter, failed in login to Oracle
See attached screenshot.
Please help and thanks.

Lan
3 REPLIES
Moderator

Re: Context parameter used in Oracle connection

Hi,
Thank you for your post! We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
What's the error message you are getting?
Have you already checked a related scenario in component reference:TalendHelpCenter:tContextLoad?
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: Context parameter used in Oracle connection

Hi Xiaodo,
I found the problem - the Id I used was wrong. After switch to new Id, the context parameters passed to Oracle worked fine.
Thanks.
Lan
Moderator

Re: Context parameter used in Oracle connection

Hi,
Great you found the problem. 
If this issue reolved, could you please mark this topic as resolved?
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.