topic Re: Connection Reset Error in Talend Studio

Connection Reset Error

Prasanna3 — Fri, 15 Nov 2024 23:34:57 GMT

Hi Team,

We are using azure server to process the feeds into database everytime we are getting connection reset error

And do we have any retry connection parameters in talend if yes please suggest me

Can someone please tell me how to resolve that ?

Thanks,

Prasanna

Re: Connection Reset Error

Anonymous — Thu, 28 Oct 2021 02:08:23 GMT

No a parameter or a direct way can be used to retry the connection, this post might be helpful, using tLoop to retry the DB connection until it is successful.

Regards

Shong

Re: Connection Reset Error

gjeremy1617088143 — Thu, 28 Oct 2021 08:51:26 GMT

Hi, for a sql server database for example : you can check the state of the connection with :

((java.sql.Connection)conn_tDBConnection_1).isValid(3000)

((java.sql.Connection)conn_tDBConnection_1).isClosed()

if your db connection is in a preJob and there is no component after you can relaunch the connection with :

tDBConnection_1Process(globalMap)

Send me love and kudos