Sql server socket connection reset error

[Ameyy]

Getting this error.. when loading data from sql server to oracle.

com.Microsoft.sqlserver.jdbc.SQLServer exception: Java.net.socket exception. Connection reset. It happens after a hour of loading data. Any idea why and where can I fix this

[gjeremy1617088143]

You ca try to catch this error then :

java.sql.Connection conn_tDBConnection_1.isValid(10) to see if your connection is till ok.

Then if you have your tdbconnection at the end of a prejob and if your connection is not ok you can call it at any time to process : tDBConnection_1Process(globalMap).

and after you run the rest of the job

Send me Love and Kudos

[Anonymous · Accepted solution]

Hello,

Could you please try to set JDBC provider as Microsoft instead of open source JTDS to see if it works?

We will appreciate it a lot if you could post your job design screenshots here.

Best regards

Sabrina