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?