topic Re: Sql server socket connection reset error in Talend Studio

Sql server socket connection reset error

Ameyy — Sat, 16 Nov 2024 00:06:25 GMT

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

Re: Sql server socket connection reset error

gjeremy1617088143 — Fri, 28 May 2021 07:50:22 GMT

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

Re: Sql server socket connection reset error

Anonymous — Mon, 31 May 2021 03:42:42 GMT

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