Help Center/ DataArts Studio/ FAQs/ DataArts Migration (Real-Time Jobs)/ What Should I Do If Error Message "java.sql.SQLRecoverableExeception: IO Error: Socket read timed out" Is Displayed During Incremental Data Reading from Oracle?
Updated on 2025-11-17 GMT+08:00
View PDF
Share

What Should I Do If Error Message "java.sql.SQLRecoverableExeception: IO Error: Socket read timed out" Is Displayed During Incremental Data Reading from Oracle?

Symptom

During the incremental data reading from Oracle, the JobManager or TaskManager log contains error message "java.sql.SQLRecoverableExeception: IO Error: Socket read timed out".

Possible Causes

  • The Oracle database is overloaded and cannot process requests in a timely manner.
  • The Oracle database is faulty and cannot process requests.

Solution

  • Add the following two timeout intervals in the job configuration: 
    oracle.jdbc.ReadTimeout    300000                                  oracle.net.CONNECT_TIMEOUT 60000          (This is a recommended value. You can increase it as needed.)
  • Contact the Oracle DBA to check whether the database is running properly. If the database is running properly, resume or restart the job.