Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is it possible to use setQueryTimeout with a DB component?

Hi,
My customer wants to iterate on a list of tables in an oracle DB to query data, using the following schema
ListOfTables -> iterate -> tOracleInput -> tFileOutput ..
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.
In normal JDBC development, it is possible to use java.sql.Statement.setQueryTimeout(int Timeout)
Is there such a solution using talent ?

Labels (4)
2 Replies
Anonymous
Not applicable
Author

Anyone from R&D can answer this please ?
Luca10
Contributor
Contributor

did you try setting a timeout in component tOracleInput using JDBC additionnal parameters in advanced setting?