How to Try Catch openning MySQL Connections?

Anonymous — Sat, 16 Nov 2024 05:49:16 GMT

Hi, I have a job that gets N connectionStrings and opens a connection for each one, then get some data from them and create a Json file.

My problem comes when I have two connectionStrings. If I don't have any problem with them works perfectly, but if the first connection fails, the job stops, and I need that the second connection does this job even if the first one fails.

I attach a pic of my project.

The javaFlex code is:

At the begin:

try {

In the end:

} catch (Exception ex) {
System.out.println(ex.getLocalizedMessage());
}

Re: How to Try Catch openning MySQL Connections?

vapukov — Fri, 17 May 2019 09:37:47 GMT

Hi,

as I know - you can not disable job dying when a database connection error

but you can manage this situation by run subjob:

in parent job you make a loop over you connection settings and pass them as parameters to the child job
you must have unchecked Die on error in tRunJob component
you can also control error code from subjob and log warnings if code not equal to 0

topic Re: How to Try Catch openning MySQL Connections? in Talend Studio

How to Try Catch openning MySQL Connections?

Re: How to Try Catch openning MySQL Connections?