I am using Talend 6.4 and have a master job which has child jobs.
I am trying to utilize the shared Oracle DB connection between the jobs using tOracleConnection.
tOracleInput and tOracleOutput is used to transfer data from source table to destination table.
Mapping has been established with tOracleConnection and tOracleIntput with option "Use an existing connection" onSubJob OK.
I am not able to establish mapping between tOracleConnection and tOracleOutput
As per screen shot you cannot give directly from tOracleConnection_2 to tOracleOutput_1 because you have already given on subjob ok from tOracleConnection_1 to tOracleInput_1. To resolve your issue connect like below
tOracleInput_1 ---> tOracleOutput_1.
Don't forget to give kudos If a reply is helpful and click Accept the solution when you think you're good with it.
Thanks Bharath for the quick response.I have changed the order of invocations as suggested, but getting a null pointer exception as below. The revised job order as attached
Exception in component tOracleConnection_1 (testjob)
at java.util.Hashtable.put(Unknown Source)
Have you created context variable when you mapped connection components from Repository?
Thanks Bharath this worked.Appreciate your response.
Hope this is the right option to include another jobs after succesful execution of this job?
No problem if you think if this gave you the solution please accept this as solution and close this topic.
Kudos are accepted.
Thanks. I was trying to establish the mapping between jobs using shared connection.Though I am getting job sucess via tool no data is inserted to the database.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables