topic Re: Context parameter used in Oracle connection in Talend Studio

Context parameter used in Oracle connection

Anonymous — Tue, 28 Jun 2016 19:07:44 GMT

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

Re: Context parameter used in Oracle connection

Anonymous — Wed, 29 Jun 2016 09:07:41 GMT

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

Re: Context parameter used in Oracle connection

Anonymous — Sat, 09 Jul 2016 06:06:37 GMT

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

Re: Context parameter used in Oracle connection

Anonymous — Mon, 11 Jul 2016 04:51:37 GMT

Hi,
Great you found the problem.
If this issue reolved, could you please mark this topic as resolved?
Best regards
Sabrina