topic Re: I/O Error: DB server closed connection in Talend Studio

I/O Error: DB server closed connection

Anonymous — Sat, 16 Nov 2024 11:03:23 GMT

Hello,
I am getting below error message while using tMSSqlConnection.
Starting job EndToEndReconciliation at 15:48 08/09/2015.
connecting to socket on port 3614
connected
Exception in component tMSSqlConnection_3
java.sql.SQLException: I/O Error: DB server closed connection.
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2311)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:610)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.tMSSqlConnection_3Process(EndToEndReconciliation.java:316)
at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.runJobInTOS(EndToEndReconciliation.java:585)
at oi_xlh_ops.endtoendreconciliation_0_1.EndToEndReconciliation.main(EndToEndReconciliation.java:442)
Caused by: java.io.IOException: DB server closed connection.
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:848)
disconnected
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.TdsCore.nextToken(TdsCore.java:2206)
... 9 more
Job EndToEndReconciliation ended at 15:48 08/09/2015.

Thanks in advance for your help.
Sam

Re: I/O Error: DB server closed connection

Anonymous — Wed, 09 Sep 2015 09:14:23 GMT

Hi sam,
Do you enable force encryption(ssl required) on SQL server? Can you connect to SQL server from management studio successfully without using Talend Tool?
Best regards
Sabrina

Re: I/O Error: DB server closed connection

Anonymous — Wed, 09 Sep 2015 18:20:20 GMT

Hello Sabrina,
Thank you for your reply.
Yes I am able to connect to SQL Server from management studio without using Talend tool.
I have 4 different servers and I am able to use 2 in Talend and for other 2 I am getting this error though I have all the required permission for all 4 servers.
Thanks,
Sam

Re: I/O Error: DB server closed connection

Anonymous — Thu, 10 Sep 2015 09:14:20 GMT

Hi sam,
What does your job design look like? Are you using "Use or register a shared DB Connection" in it? Have you tried to set up DB connection in metadata to see if it works?
Best regards
Sabrina

Re: I/O Error: DB server closed connection

Anonymous — Thu, 10 Sep 2015 17:47:26 GMT

Hello Sabrina,

I am using just tMSSqlconnection. I am not using " Use or register a shared DB Connection ".

I have tried to set up DB connection in metadata and its working for the server which was already working with tMSSqlconnection but I am getting error for the server which was not working with tMSSqlconnection.

Please check the images in attachments.

Thanks,
Sam

Re: I/O Error: DB server closed connection

Anonymous — Mon, 14 Sep 2015 08:26:50 GMT

Hi,

I have tried to set up DB connection in metadata and its working for the server which was already working with tMSSqlconnection but I am getting error for the server which was not working with tMSSqlconnection.

Do you mean server A is Ok but not server B? Can you connect your server B successing without using Talend Tool?
Best regards
Sabrina

Re: I/O Error: DB server closed connection

Anonymous — Mon, 14 Sep 2015 20:35:19 GMT

Hi,
Yes I am able to connect to Server B without using Talend Tool.

Sam

Re: I/O Error: DB server closed connection

Anonymous — Thu, 17 Sep 2015 10:55:59 GMT

Hi Talend Team,
Can you please update on this ,i also faced same issue.

Re: I/O Error: DB server closed connection

Anonymous — Thu, 24 Dec 2015 12:28:02 GMT

Hi Talend,
I am also facing same issue.
Can you help us to get what is going wrong?
Thanks,
Revathy

Re: I/O Error: DB server closed connection

Anonymous — Fri, 25 Dec 2015 03:58:23 GMT

Hi Revathy,
What's your sql server version? On which talend build version you got this issue? What does your job look like?
Best regards
Sabrina

Re: I/O Error: DB server closed connection

swatisood8 — Tue, 29 Sep 2020 21:33:50 GMT

Hi All,

I found a solution for this. Not sure if it is still relevant. Posting for all the people who might need this information in the future.

In case we are connecting to a Microsoft SQL Server from Talend which has forced encryption(ssl required) enabled at the server side, then we need to add Additional JDBC parameters while establishing the connection.

The additional parameters are : "encrypt=true;trustServerCertificate=true;ssl=require"

I have tested in one of the sample jobs and it works fine for me. If I do not add these additional parameters, then I will get DB connection closed error. Image attached.

Hope this helps.

Regards,

Swati Sood

Re: I/O Error: DB server closed connection

Tarun2 — Thu, 09 Sep 2021 22:36:03 GMT

Hi Swati,

I faced the same issue. And your post was helpful to resolve this. Thank You!

Re: I/O Error: DB server closed connection

Anonymous — Fri, 10 Sep 2021 06:18:34 GMT

Hello,

That is really good answer, have you thought of entering our competition?

https://community.talend.com/s/blog/aGn5b000000CaZw/getting-smart-about-talend-tip-of-the-day

Best regards

Sabrina