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 ?
did you try setting a timeout in component tOracleInput using JDBC additionnal parameters in advanced setting?