Updated context variable value for toracleinput component

[Anonymous]

Hi,

tOracleInput component is not taking context variable updated value. Context variable default value updated in tjava component and connect to toracleinput component with 'OnComponent Ok' link. After updating the context variable value,tjava component is printing updated value and same updated value needs to be used in toracleinput component. However updated context variable value is not passing to toracleinput component and throwing error.

My graph design is :

tsystem -> tjavarow -> tjava -> toracleinput

Please assist.

Regards,

Vivek

[Anonymous]

Can anybody assist on this issue please ?

[fdenis]

tOracleIput create connection before job main execution.
if you want to set context to tOracle Input, the best way is to use tRunJob
to set context previously to calling subjob.
so:
create on job with tOracleInput and ….
create a job calling previous one with tRunJob

[Anonymous]

Used tRunjob and transmit that part to another graph. However still getting the same error.

Regards,

Vivek

[Anonymous]

Hi,

Can u please share the screen shot of tjava and tOracleInput?

Regards,
Ragu

[Anonymous]

Cannot upload graph screenshot. However following are the components used in graph.

tSystem - row (main)-> tJavaRow  -On Component Ok -> tJava   -On Component Ok-> tOracleinout

Regards,

Vivek

[Anonymous]

Hi Vivek,

      Is there any specific reason for using the On Component Ok in your flow? Could you please try below flow and let us know whether there are any changes?

      I have used On SubJob Ok in the skeleton flow.

Warm Regards,

Nikhil Thampi

[Anonymous]

Hi Nikhil,

Thanks .There is no specific reason to use 'oncomponent ok ' however after changing graph according to your design .toracleinput component is throwing same error like below.

Exception in component tOracleInput_1

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Scenario is that tsystem will return db pwd and that db pwd should be updated to old context.password value.Bec context.password is used in toraclecomponent to connect to db.The issue is toracleinput component is not taking the updated context variable value,which is printing correctly in previous tJava component.

Regards,

Vivek

[Anonymous]

Hi Vivek,

     Could you please share the screen shots of tjava and tOracleInput Components for further validation?

      You can mask any sensitive information. But I believe you are using variables everywhere without hardcoding. So in ideal case, it should not be a problem.

      If the security aspects of your company is not allowing you to take screen shots, I would advise you to raise a Talend support ticket so that they can help you through official channels.

Warm Regards,

Nikhil Thampi