Talend using maximum number of Oracle Connections

One Star

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.
Community Manager

Re: Talend using maximum number of Oracle Connections

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend using maximum number of Oracle Connections

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.
One Star

Re: Talend using maximum number of Oracle Connections

Basically it is holding these many connections 24/7 irrespect to the Job Schedule.
Community Manager

Re: Talend using maximum number of Oracle Connections

Hi
Do you use iterate link with enable parallel execution in the job?
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend using maximum number of Oracle Connections

Nope Shong.
Iam using Iterate Links but not using Parallel execution.
Community Manager

Re: Talend using maximum number of Oracle Connections

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend using maximum number of Oracle Connections

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

Re: Talend using maximum number of Oracle Connections

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Seventeen Stars

Re: Talend using maximum number of Oracle Connections

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.