Connection Reset Error

[sbhadra]

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.

[Prakhar1]

Could you please share you job flow ?

[gjeremy1617088143]

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