topic Connection pooling usind the tjdbc Components in Talend Studio

Connection pooling usind the tjdbc Components

Abhishek9 — Fri, 04 Mar 2016 20:21:31 GMT

Hi,

I am looking for a way to do connection pooling with my Talend job. The Talend Job is designed in such a way that it calls subjobs using Trunjob parallely using the Tparallelize component. Each job called within the TRunjob creates a new connection and commits and closes the connection once done using the tjdbccommit and tjdbcclose. Currently this whole structure is called in a loop so there are multiple connections created and closed if the job executes over a few hours. Performance needs to be improved and I believe connection pooling would be a good way to start tuning my Talend Job. I searched the forum and came upon a link where a custom connectionpool component was created but the link does not seem to work. Any suggestions on how I can implement connection pooling?

Abhishek

Re: Connection pooling usind the tjdbc Components

Anonymous — Tue, 08 Mar 2016 07:05:15 GMT

Hi,
For connection pool feature, it is not possible currently.
Have you checked component tJDBCConnection?
Is "Use or register a shared DB connection" feature helpful for your current use case?
Best regards
Sabrina

Re: Connection pooling usind the tjdbc Components

Abhishek9 — Wed, 27 Apr 2016 08:55:11 GMT

Hi Sabrina,
Thanks for the reply. I am calling multiple subjobs and each subjob requires at least 2 connections because there are tasks done in parallel here so shared connection was not an option for me.
Regards
Abhishek