One Star

Error tMSSQLInput - Problem with java ?

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
2 REPLIES
One Star

Re: Error tMSSQLInput - Problem with java ?

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
One Star

Re: Error tMSSQLInput - Problem with java ?

Hi Pedro,
I tried to pass the following java parameter to the sql server connection: -Djsse.enableCBCProtection=false
It was explained here: http://www.aquaclusters.com/app/home/project/public/aquadatastudio/discussion/General+Discussions/po...
it ran this morning, but I'll have to wait for a few successfull runs to be sure that it's working correctly
thanks though !
laloune