Error tMSSQLInput - Problem with java ?

Anonymous — Mon, 13 Aug 2012 07:47:38 GMT

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

Re: Error tMSSQLInput - Problem with java ?

Anonymous — Tue, 14 Aug 2012 06:00:05 GMT

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

Re: Error tMSSQLInput - Problem with java ?

Anonymous — Tue, 14 Aug 2012 07:45:57 GMT

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/post/25/Java+6u29+bug+prevents+SSL+connection+to+SQL+Server+2008+R2
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

topic Error tMSSQLInput - Problem with java ? in Talend Studio

Error tMSSQLInput - Problem with java ?

Re: Error tMSSQLInput - Problem with java ?

Re: Error tMSSQLInput - Problem with java ?