Sharing an Oracle DB database connection between a parent Job and a child Job

[Anonymous]

Hi Team,

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

[javvaji]

Hi Priyag,

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

tOracleConnection_1

|sunbjob ok

|

tOracleConnection_2

|subjob ok

|

tOracleInput_1 ---> tOracleOutput_1.

Regards,

Bharath.

Don't forget to give kudos If a reply is helpful and click Accept the solution when you think you're good with it.

[Anonymous]

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)
java.lang.NullPointerException
at java.util.Hashtable.put(Unknown Source)
at testmig.testjob_0_1.testjob.tOracleConnection_1Process(testjob.java:568)
at testmig.testjob_0_1.testjob.runJobInTOS(testjob.java:6275)
at testmig.testjob_0_1.testjob.main(testjob.java:6022)

Capture1.PNG

[Anonymous]

tOracleConnection_1 & tOracleConnection_2 are mapped to Repository which is mapped to Source and Destination schemas

[javvaji]

Hi,

please see the attachment once for order..

Capture.PNG

[javvaji]

Hi,

Have you created context variable when you mapped connection components from Repository?

[Anonymous]

Thanks Bharath this worked.Appreciate your response.

Hope this is the right option to include another jobs after succesful execution of this job?

Capture2.PNG

[Anonymous]

Yes context variable is created

[javvaji]

No problem if you think if this gave you the solution please accept this as solution and close this topic.

Regards,

Bharath.

Kudos are accepted.

[Anonymous]

Hi Bharath,

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. 

Capture4.PNG