Shared DB Connection autocommit

Four Stars

Shared DB Connection autocommit

Hi,

I have a question about the shared DB connection between differents Jobs and the advanced option Auto commit.

For exemple, i open a connection in the parent job with a shared db connection and  whith th option Auto Commit.

in the child job , i use the shared connection, but i uncheck the option auto commit and validate the transaction at the end of the child job.

 

in this case i would like to know if the parent job will be save without transaction and if the child job will use the transaction.

 

Thanks for your help

Erwann


Accepted Solutions
Eleven Stars

Re: Shared DB Connection autocommit

Share Db connection is static instance for a JOB .

So any change in Child job will persist.
Regards
Abhishek KUMAR

All Replies
Eleven Stars

Re: Shared DB Connection autocommit

Share Db connection is static instance for a JOB .

So any change in Child job will persist.
Regards
Abhishek KUMAR
Four Stars

Re: Shared DB Connection autocommit

Hi,

thanks for your answer,

So if I well understand, i have to modify the commit option after my sub job like this

 

Capture.PNG

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog