One Star

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 ?

2 REPLIES
One Star

Re: Is it possible to use setQueryTimeout with a DB component?

Anyone from R&D can answer this please ?
Five Stars

Re: Is it possible to use setQueryTimeout with a DB component?

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