topic Re: DB Connection Re-try in Talend Studio

DB Connection Re-try

Anonymous — Mon, 20 Jun 2016 08:30:15 GMT

Hi,

I have a requirement where I have to re-try DB Connection for 5 times untill it connects. A flow like this:
start->Db Connect-> if connection succeeds->go to next component
->if connection fails->sleep for 5 seconds->re-try for 5 more times->if connection succeeds-> go to next component
->if connection fails -> die

Please help.

Re: DB Connection Re-try

Anonymous — Mon, 20 Jun 2016 08:46:12 GMT

Hi,
Could you please take a look at this scenario: TalendHelpCentercenario: Job execution in a loop to see if it is satisfying your needs?
Best regards
Sabrina

Re: DB Connection Re-try

Anonymous — Mon, 20 Jun 2016 08:48:25 GMT

You need to establish a loop, try your connection. determine if it was successful. break loop on success. sleep and retry on failure. break loop when you've tried x (5) times.
Test for success and failure after loop.

You may be able to use OnSubjobOk and OnSubjobError to determine success or failure.

If these connectors do not cut it, you can also set-up your own Exception Handler, using tJavaFlex. Sometimes you want to know a little more able why it's failed. There's no point in retrying if your password is wrong, as you may simply lockout the account and have more headaches to sort out.

http://www.talendbyexample.com/talend-tjavaflex-component-reference.html