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 ?
1 REPLY
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.