Best practice in using shared DB connections

Highlighted
Four Stars

Best practice in using shared DB connections

hi,

 

We have many talend jobs that are mapped as Karaf end points.

 

The talend jobs all use shared db connections with the same DB connection name. 

The jobs have sub jobs, which also have use the same DB connection.

 

1. Is it right to close the connections, since we are sharing the DB connections?

2. In a multithreaded scenario (when karaf maps 2 routes to the talend job at the same instance in time), will the connection object be shared?

 

What is the best practice around this?

 

Thanks so much for you response.

 

Regards,

Flora

Highlighted
Moderator

Re: Best practice in using shared DB connections

Hello,

Sorry for delay!

We have redirected your issue to our experts and then come back to you as soon as we can.

Best regards

Sabrina

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

2019 GARTNER 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

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read