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: 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: 46

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 46 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
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.
Submit review
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
9

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
144

validates minutes:seconds format

Validates 3:56, 59:59,...
Does not validate 60:59 or 59:60.

SQL

hotmail email

2.0 scorreia 2014-05-26
312

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
112

Postal Code format verfication (Netherlands)

Matches
9999AA|9999 AA
Non Matches
9999aa|9999Aa|9999 aa|9999 aA

Regex

Dutch Phone Number

2.0 fcweeber 2014-05-26
113

Phone Number format verfication (Netherlands)

Local: Dutch Phonenumber format is area code (3 or 4 digits), phone number ( 7 or 6 digits) - total length (10 digits)
International: country code 0031 and then remove zero from area code
Matches
0031121234567|+31123123456|0121234567|012-1234567|0123-123456
Non Matches
012 1234567|1234567
match 02.31.23.45.67.22 or 004923123467223

Regex

Names with unicode characters

2.0 scorreia 2014-05-26
110

Match people names with unicode characters.
Matches Jean-Marc, Jørn, Mc\'Neelan, Pz. López
Does not match I.B.M.

Regex

FR Phone Number (parenthesis allowed)

2.0 scorreia 2014-05-26
324

match French phone numbers in several format:
matches:
0033 1 47 25 00 00
+33 1 47 25 00 00
(33) 1 47 25 00 00
0033147250000
01-47-25-00-00
01 47 25 00 00
Does not match
0147 250 000

Regex

Email Address (with list of top-level domains)

2.0 mzhao 2014-05-26
172

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
91

match regular text

matches regular text such as \"hello Jean-Baptiste\".
does not match text with any special character such as \"# num\", \"test;\"

Regex

Text

2.0 scorreia 2014-05-26
69

match regular text with punctuation correctly placed.

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
595

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
399

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
737

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1127

Talendshop Demo (Demo Project)


56 ms