Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend using maximum number of Oracle Connections

Hi,
Talend using by defualt maximum number of connections .
How can we avoid this kind of situation.
is it possible to specify how many connections need to be used.
Labels (2)
9 Replies
Anonymous
Not applicable
Author

hi
It is the first time i hear that Talend use the maximum number of connections. It might be a design issue in your job, some screenshots of job will be helpful.
Shong
Anonymous
Not applicable
Author

Hi Shong,
Thanks for quick reply.The Packages are very confidential and i cannot share them on a Forum.
Can you please suggest some basic tips to avoid the scenario.
Thanks in Advance.
Anonymous
Not applicable
Author

Basically it is holding these many connections 24/7 irrespect to the Job Schedule.
Anonymous
Not applicable
Author

Hi
Do you use iterate link with enable parallel execution in the job?
Shong
Anonymous
Not applicable
Author

Nope Shong.
Iam using Iterate Links but not using Parallel execution.
Anonymous
Not applicable
Author

Hi
If you create the db connection on output component tOracleOutput, it will close the connection after tOracleOutpu t finishes. If youe use tOracleConnection to create the db connection, don't forget to use tOracleCommit or tOracleClose to close the db connection. As I don't view your job, I can't point out the true reason.
Shong
Anonymous
Not applicable
Author

Nope iam not using tOraclConnection.I am just using TOracleInput and TOracleOutput.
Anonymous
Not applicable
Author

Nope iam not using tOraclConnection.I am just using TOracleInput and TOracleOutput.

Try to use tOracleConnection to create DB connection, and use the same connection on tOracleInput and tOracleOutput components. This way can void creating too many db connections to Oracle server.
Shong
Anonymous
Not applicable
Author

I would strongly suggest using tOracleConnection in conjuction with the option "Use Shared Connection".
Unfortunately Talend does not provide an connection pool. A shared connection is ONE connection retrieved by its name.
Of cource you can run out of possible count of connections in an Oracle database. The typicall maximum count is 100 but it is a good adhok solution to increase this count in the Oracle configuration (initora file). You can increase the number without any problems to a value of 1000.