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.


tOracleRowWithQueryTimeout


  • Author: aymenroma
  • Categories: Java, Component
  • First revision date: 2012-06-04
  • Latest revision date: 2012-06-04
  • Compatible with: Data Integration releases 4.2.0, 4.2.1, 4.2.2, 4.2.3, 4.2.4, 5.0.0, 5.0.1, 5.0.2, 5.1.0, 5.1.0RC1, 5.1.1
  • Downloads: 37

About: This components based on tOracleRow gives a new parameter the \"setQueryTimeout\". This parameter cancel the SQL execution when the timeout expires.

this component is being developed for the Credit Agricole SA need.

Revision list

expand/collapse all

Revision 1.0 37 Downloads, Released on 2012-06-04
Download revision 1.0

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

This components based on tOracleRow gives a new parameter the \"setQueryTimeout\". This parameter cancel the SQL execution when the timeout expires.

this component is being developed for the Credit Agricole SA need.

Reviews (2)

 When we have a lock table By aymenroma on June 5, 2012
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
Was this review helpful to you? Yes No Report
 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.
Was this review helpful to you? Yes No Report
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*



Warning: implode() [function.implode]: Invalid arguments passed in /home/www/talendforge.org/exchange/tos/include/functions.multi.inc.php on line 1182

Warning: implode() [function.implode]: Invalid arguments passed in /home/www/talendforge.org/exchange/tos/include/functions.multi.inc.php on line 1223
Version Author Released on Rating Downloads
Regex

number1-10

 3.2.3 mhallam 2010-01-27
35

match 1 .. 10

Regex

semester

 3.2.3 mhallam 2010-01-27
22

1 or 2

Regex

Quarter

 quarter mhallam 2010-01-27
32

accept only 1 or 2 or 3 or 4

French vehicle registration plate number

 0.1 mgainhao 2009-10-28
65

French vehicle registration plate number

Match : AA-098-BA
not match : A2-093-BB, AB-09G-CD, AR-93-BB ...

Regex

Random email

 1.0 scorreia 2009-10-22
131

detect random emails

SQL

hotmail email

 1.0 scorreia 2009-09-02
274

filters email from hotmail.com

Regex

Numeric

 1.0 scorreia 2009-08-12
372

Matches all numbers

Regex

Longitude Validation

 3.1.2 mhallam 2009-07-07
193

-98.092391

Longitude validation (similiar to Latitude Validation) and inspired by the same code
Regex

Istat Code

 3.1.2 mhallam 2009-07-07
116

22.12.0|18.24.C||22.12_D|12.56| 1A.56.1

This pattern match the Italian Istat Ateco Code (Codice Istat) updated to Istat Declaration Ateco 2004

Regex

Valid UK Post Codes Upper and Lower Case

 3.1.2 mhallam 2009-07-07
102

SW112LE | SW11 2LE | sw112le12CR0LE | 12CR 0LE | SWLE05

Matches valid UK post codes in both upper and lower case, allowing for one or zero spaces between outcode and incodes.

Version Author Released on Rating Downloads
Export

Product Demo

 3.0 ctoum 2012-05-31
427

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

 1.0 jaymce 2010-11-22
283

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm
Data-Model

D* Demo Model

 1.0 ctoum 2010-08-13
512

Model used in the D* Demo.

Export

Talendshop Demo

 1.0 ctoum 2010-08-04
1062

Talendshop Demo (Demo Project)


53 ms