topic [resolved] Close the database connection on Job Error/fail in Talend Studio

[resolved] Close the database connection on Job Error/fail

Anonymous — Fri, 31 May 2013 21:15:41 GMT

Hi All,
How to close the database connection in the Talend job on job erros. In our job we open a database connection with tMSSqlConnection and at the end of the job we close it. But if some thing goes wrong in the middle of the job, how to close the database connection?
Do talend job will close automatically on error/expcetion ?
I can check on every component on component error and close the connection, but just wondering is there any easy way to close all connections on job exception/error.
Thanks
Ramesh

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Sat, 01 Jun 2013 13:32:12 GMT

You can use the tPost component to do that.
tPost will always executed even if the job fails.
tPost -> OnComponentOK -> tMSSqlClose

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Mon, 03 Jun 2013 04:31:43 GMT

Hi,
Add the reference tPostjob and How to use the tPrejob and tPostjob components into forum. Hope it will be useful.
Best regards
Sabrina

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Mon, 03 Jun 2013 14:09:15 GMT

Thanks,
Yes, I am using the tPostJob to close the database connection, now it cleared my doubt that tPostJob will run even on job fail also.
And one more question is the tPostJob runs even if we check the checkbox (die on error) on any component?
Thanks
Ramesh

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Tue, 04 Jun 2013 03:42:07 GMT

Hi,

And one more question is the tPostJob runs even if we check the checkbox (die on error) on any component?

tPostJob and tPreJob can run even if checkout "die on error" on any component, because they are enforcement and can run under any situation in job .
Best regards
Sabrina

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Tue, 04 Jun 2013 14:17:17 GMT

Thank you verymuch Sabrina.
Ramesh

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Wed, 05 Jun 2013 04:05:18 GMT

Hi,
You are welcome, feel free post your issue on forum.
Best regards
Sabrina

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Wed, 09 Sep 2015 03:50:36 GMT

May I ask. what to put on code in dynamic settings for toracleclose component.
Thanks,
duffney

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Wed, 09 Sep 2015 07:57:49 GMT

Hi duffney,
Would you mind giving us more information about your issue? You want to use dynamic setting(Component List) in component toracleClose?
Best regards
Sabrina

Re: [resolved] Close the database connection on Job Error/fail

Anonymous — Fri, 19 Feb 2016 08:53:18 GMT

Good morning,
can you please explain me the best practices for using tMSSQLConnection and tMSSQLCommit in ESB jobs, starting with tESBProviderRequest? I have the following doubts related to the topic above:
tPostjob does not work in ESB jobs, it is never triggered. Neither, OnSubjobOk/Error is triggered from tESBProviderRequest. Instead, we use tLogCatcher to catch exceptions and we put tESBProviderFault there. So should we also close the connection there in case of failure? Will the connection remain open forever if we dont close it in this section, or will it recycle then the job is invoked by another request (so that it remains registered within the TalendESBJobFactory? If it remains open, what happends when the underlying network connection gets broken, will it reconnect?
We use the following structure of the web services:
tMSSQLConnection -- onSubJobOK --> tESBProviderRequest --> my logic --> tESBProviderResponse
tLogCatcher --> tXMLMap --> tESBProviderFault or Response (depending on situation)
The same for tRouteInput jobs.
Thanks a lot. Michal
P.S. I know this is a Talend DI section, but the question seems to be relevant to the topic to me 🙂