Need to use connection pooling in Talend

One Star

Need to use connection pooling in Talend

We have designed the job for file loading in database. We pass the folder path to talend and talend pick the file open the database connection, load the file into database and close the connection. This process repeats many times and every time it acquire the port to establish the connection, after some time I think it stops loading files because of unavailability of ports.
To resolve this problem we need to use database connection pooling in Talend. My understanding is that We can only use the connection pooling while we are running job in talend tool. I want to use that job in java program, so can you please help me on how to use connection pooling?
Highlighted
Seventeen Stars

Re: Need to use connection pooling in Talend

Check out the custom component component tConnectionPool.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252...
This component emulates an JNDI datasource and you can use it with currently with Oracle, MySQL and MSSQL (all database connections which allows using datasources from a Talend runtime).

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog