https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284905#M58527 <P>did you try setting a timeout in component tOracleInput using JDBC additionnal parameters in advanced setting?</P> Thu, 26 Oct 2017 13:14:06 GMT Luca10 2017-10-26T13:14:06Z https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284903#M58525 <P>Hi,<BR />My customer wants to iterate on a list of tables in an oracle DB to query data, using the following schema<BR />ListOfTables -&gt; iterate -&gt; tOracleInput -&gt; tFileOutput ..<BR />The problem is sometimes that one of the tables might take too much time (many days) to get data from the DB. My customer wants to put a timeout to the select statement so that it proceeds with the next tables if it is stuck.<BR />In normal JDBC development, it is possible to use&nbsp;<FONT color="#131212"><FONT size="3"><FONT face="monospace">java.sql.Statement.setQueryTimeout(int Timeout)</FONT></FONT></FONT><BR />Is there such a solution using talent ?</P> Thu, 05 Jan 2017 16:29:24 GMT https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284903#M58525 Anonymous 2017-01-05T16:29:24Z https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284904#M58526 Anyone from R&amp;D can answer this please ? Wed, 11 Jan 2017 18:55:27 GMT https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284904#M58526 Anonymous 2017-01-11T18:55:27Z https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284905#M58527 <P>did you try setting a timeout in component tOracleInput using JDBC additionnal parameters in advanced setting?</P> Thu, 26 Oct 2017 13:14:06 GMT https://community.qlik.com/t5/Talend-Studio/Is-it-possible-to-use-setQueryTimeout-with-a-DB-component/m-p/2284905#M58527 Luca10 2017-10-26T13:14:06Z