topic Re: Connection Reset Error in Talend Studio

Connection Reset Error

sbhadra — Sat, 16 Nov 2024 00:13:03 GMT

Hi Team,

We are running one job in production environment. While running the job, the first two queries run properly and all the data are being transferred however, when the third query is about to run we are getting an error "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

We are currently using tsqldwhconnection and tsqldwhinput to connect and run the queries. We also ran the query and it takes less than a minute to give away the result. Please suggest if any component changes needs to be done so that we can overcome this issue.

Re: Connection Reset Error

Prakhar1 — Tue, 27 Apr 2021 07:34:37 GMT

Could you please share you job flow ?

Re: Connection Reset Error

gjeremy1617088143 — Tue, 27 Apr 2021 07:51:25 GMT

Hi you can check at any time the state of your connection in java :

If your connection component name is tDBConnection_1 then you can write :

System.out.println(((java.sql.Connection)globalMap.get("conn_tDBConnection_1")).isClosed());

with this boolean you can reactivate your connection for example:

if(((java.sql.Connection)globalMap.get("conn_tDBConnection_1")).isClosed())

{

tDBConnection_1Process(globalMap);

}

your tDbconnection have to be placed a the end of a tprejob.

Send me Love and Kudos