Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.
About: This components based on tOracleRow gives a new parameter the \"setQueryTimeout\". This parameter cancel the SQL execution when the timeout expires.
Revision 1.0 38 Downloads, Released on 2012-06-04
Compatible with: 5.1.1, 5.1.0, 5.1.0RC1, 5.0.2, 5.0.1, 5.0.0, 4.2.4, 4.2.3, 4.2.2, 4.2.1, 4.2.0
we use this option because we can't have a possibility to configure the database.
And so if one has a lock on a table, you avoid waiting for a response from the database and the job can be completed by posting a query timeout error
Probably better asking for an explain plan before starting query By jlolling on June 5, 2012
When it is a good idea to cancel an query?
Cancelling a query is not really possible for a client. Usually the Oracle server continues running the query, because of that, there is not advancement in cancelling a query. Then only secure way to cancel a query is using the Enterprise Manager.
Especcially for Oracle consider to retrieve the explain plan and use an upper limit for costs or time before starting the query.