Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gurus,
We are using Talend 5.5.1.r118616 version of the TOS and using sql server 2012 as the DB. Many a times, we are getting the following errors while reading/writing to a DB table. These errors are very frequent, we consulted the DBA as well but every time, it comes out that there no network or DB server glitch.
Error 1
Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid state, the Connection object is closed.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1699)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2401)
at etl.j_e_smt_stt_rt_22_0.j_e_smt_stt_rt.tStatCatcher_1Process(j_e_sm_spt.java:27766)
at etl.j_e_art_stt_rt_22_0.j_e_st_stt_rt.runJobInTOS(j_e_smart_stdeqpt_rt.java:31539)
at etl.j_e_srt_stt_rt_22_0.j_e_st_stt_rt.runJob(j_e_sm.java:30368)
at etl.j_extt_rt_0_4.j_et_rt.tRunJob_2Process(j_extract.java:5177)
at etl.j_ext_rt_0_4.j_etract_rt.tJava_5Process(j_extract.java:4430)
at etl.j_extt_rt_0_4.j_ect_rt$3.run(j_extract_rt.java:16978)
Exception in component tRunJob_2
Error 2
Exception in component tMSSqlInput_2
java.sql.SQLException: I/O Error: Connection reset
Please throw some light on this as it is getting very difficult to load the DB.
Regards,
Ashish