Oracle connection timeout while executing the query

One Star

Oracle connection timeout while executing the query

How to increase connection time out period for executing oracle queries against talend toraclerow?
our oracle query is running for a long time and connection is getting time out for every time.i know there are some additinal jdbc parameters to be passed ? but can anyone please provide me those details ?
and please give us more information why we are facing this issue ?
Moderator

Re: Oracle connection timeout while executing the query

Hi,
How did you set timeout for your oracle? In Listener.ora file in oracle?or something else?
There is a stackoverflow article about http://stackoverflow.com/questions/1914286/oracle-set-query-timeout
Hope it will help you.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.