topic Re: Sharing an Oracle DB database connection between a parent Job and a child Job in Talend Studio

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

Anonymous — Mon, 10 Jun 2019 12:13:27 GMT

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

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

javvaji — Mon, 10 Jun 2019 12:29:36 GMT

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.

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

Anonymous — Mon, 10 Jun 2019 12:38:08 GMT

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

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

Anonymous — Mon, 10 Jun 2019 12:40:09 GMT

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

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

javvaji — Mon, 10 Jun 2019 12:42:37 GMT

Hi,

please see the attachment once for order..

Capture.PNG

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

javvaji — Mon, 10 Jun 2019 13:00:04 GMT

Hi,

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

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

Anonymous — Mon, 10 Jun 2019 13:08:02 GMT

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

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

Anonymous — Mon, 10 Jun 2019 13:08:50 GMT

Yes context variable is created

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

javvaji — Mon, 10 Jun 2019 13:11:41 GMT

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.

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

Anonymous — Mon, 10 Jun 2019 14:28:23 GMT

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

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

Anonymous — Mon, 10 Jun 2019 14:28:53 GMT

Please refer to the attachment