Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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