topic Re: Talend using maximum number of Oracle Connections in Talend Studio

Talend using maximum number of Oracle Connections

Anonymous — Mon, 10 Dec 2012 13:54:36 GMT

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.

Re: Talend using maximum number of Oracle Connections

Anonymous — Mon, 10 Dec 2012 14:04:57 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Mon, 10 Dec 2012 14:39:51 GMT

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.

Re: Talend using maximum number of Oracle Connections

Anonymous — Mon, 10 Dec 2012 16:33:28 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Tue, 11 Dec 2012 12:45:02 GMT

Hi
Do you use iterate link with enable parallel execution in the job?
Shong

Re: Talend using maximum number of Oracle Connections

Anonymous — Wed, 12 Dec 2012 09:22:04 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Wed, 19 Dec 2012 11:37:55 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Wed, 19 Dec 2012 12:23:14 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Sat, 22 Dec 2012 11:34:55 GMT

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

Re: Talend using maximum number of Oracle Connections

Anonymous — Sun, 23 Dec 2012 11:29:22 GMT

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.