Reconnect on lost connection

Four Stars

Reconnect on lost connection

We are using a persistent always open connection that commits data from incoming webserice. It can happen that the connection can drop so we are looking how to reconnect if this happens. Simplified job is attached into the picture but the issue here is that the if statement happens at the end of the subjob. How could we implement a recconect?
Thank you.
Seventeen Stars

Re: Reconnect on lost connection

I would suggest you use a Talend Runtime to run this job and here you can use for the database connection a pool. Database pools usually check it connections and reconnect if needed.
Moderator

Re: Reconnect on lost connection

Hi,
Do you want to run the job in infinite loop?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Reconnect on lost connection

jlolling: we were thinking about pools but we have just one connection that has to be established. Nevertheless pooling would probably solve this issue.
xdshi: job is used with a rest web service (tRestRequest) which is conceptually similar to an infinite loop. If I solve this problem I solve the main one.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download