Connection Reset Error

[Prasanna3]

Hi Team,

W​e 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​

[Anonymous]

Hi

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

[gjeremy1617088143]

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)

or

((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