topic Re: Oracle Connection timeout issue in Talend Studio

Oracle Connection timeout issue

Anonymous — Mon, 21 May 2018 16:27:13 GMT

Hello,

I am trying to run a job that has pretty huge amount of data unloaded using an Oracle SQL. However, the job runs for 15 mins and fails giving below error

----------------------------------------------------------
Error : exceeded maximum idle time, please connect again

----------------------------------------------------------

Is there any way we can increase the timeout period through talend ?

Thanks!

Re: Oracle Connection timeout issue

Anonymous — Wed, 23 May 2018 08:56:12 GMT

Hello,

How did you set timeout for your oracle? In Listener.ora file in oracle?or something else?

Here is an article about:https://stackoverflow.com/questions/1914286/oracle-set-query-timeout

Hope it will help.

Best regards

Sabrina

Re: Oracle Connection timeout issue

MHashem1693310621 — Tue, 29 Aug 2023 12:09:57 GMT

Hi did you find an answer?