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