Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-09-08 08:03 PM

I/O Error: DB server closed connection

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
Labels (4)
Labels
466 Views
0 Likes
1 Solution

Accepted Solutions
swatisood8
Contributor II
Contributor II
‎2020-09-29 05:33 PM

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.

0693p000009qAQvAAM.png

 

Hope this helps.

 

 

Regards,

Swati Sood

 

View solution in original post

466 Views
0 Likes
12 Replies
Anonymous
Not applicable
‎2015-09-09 05:14 AM
Author

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
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-09 02:20 PM
Author

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
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-10 05:14 AM
Author

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
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-10 01:47 PM
Author

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                                                  
0683p000009MBYH.png 0683p000009MBYL.png 0683p000009MBIP.png
                                                                           
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-14 04:26 AM
Author

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
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-14 04:35 PM
Author

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

Sam
346 Views
0 Likes
Anonymous
Not applicable
‎2015-09-17 06:55 AM
Author

Hi Talend Team,
Can you please update on this ,i also faced same issue.
346 Views
0 Likes
Anonymous
Not applicable
‎2015-12-24 07:28 AM
Author

Hi Talend,
I am also facing same issue.
Can you help us to get what is going wrong?
Thanks,
Revathy
346 Views
0 Likes
Anonymous
Not applicable
‎2015-12-24 10:58 PM
Author

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
346 Views
0 Likes