Hello everyone,
i get sporadically the following error in my job:
Exception in component tMSSqlInput_1
java.sql.SQLException: I/O Error: Connection reset
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2311)
at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:765)
at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:581)
at m2rent.facts_opos_0_1.Facts_OPOS.tMSSqlInput_1Process(Facts_OPOS.java:2380)
at m2rent.facts_opos_0_1.Facts_OPOS.runJobInTOS(Facts_OPOS.java:5241)
at m2rent.facts_opos_0_1.Facts_OPOS.runJob(Facts_OPOS.java:5049)
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.tRunJob_1Process(Facts_OPOS_Superjob.java:518)
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.runJobInTOS(Facts_OPOS_Superjob.java:989)
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.main(Facts_OPOS_Superjob.java:767)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.io.DataInputStream.readFully(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:881)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
at net.sourceforge.jtds.jdbc.ResponseStream.readLong(ResponseStream.java:333)
at net.sourceforge.jtds.jdbc.TdsData.readData(TdsData.java:677)
at net.sourceforge.jtds.jdbc.TdsCore.tdsRowToken(TdsCore.java:3007)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2270)
... 8 more
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.tRunJob_1Process(Facts_OPOS_Superjob.java:536)
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.runJobInTOS(Facts_OPOS_Superjob.java:989)
at m2rent.facts_opos_superjob_0_1.Facts_OPOS_Superjob.main(Facts_OPOS_Superjob.java:767)
I read someplace that this could come from the jvm 1.6+
did you encounter this problem already with SQL Server ?
Thanks in advance for your support,
laloune
Hi Laloune
Connection reset of SQL Server is a frequent issue which may be caused by Firewall, Network connection, wrong connection information or too many SQL SERVER connections at the same time.
Because of so many possibilities, it is difficult for users to find the root reason. The situation also occurs in JDBC java program. Please recheck all these stuff above.
Regards,
Pedro
