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?
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
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
