I/O Error: DB server closed connection

[Anonymous]

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

[swatisood8 · Accepted solution]

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

[Tarun2]

Hi Swati,

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

[Anonymous]

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