topic Re: [resolved] SSL and JDBC in Talend Studio

[resolved] SSL and JDBC

Anonymous — Sat, 16 Nov 2024 13:39:38 GMT

Hi,
We access a SQL server that has SSL implemented on it. When I try to access the server using tMSSqlConnection, I get the error :-
Exception in component tMSSqlConnection_1
java.sql.SQLException: I/O Error: DB server closed connection.
Is there a way to get the JDBC working with SSL?
We are on Talend 2.4.1 - Maybe we need to upgrade?
Thanks,

Re: [resolved] SSL and JDBC

Anonymous — Wed, 02 Dec 2009 22:05:55 GMT

Hi,
Some update - I have tried
integratedSecurity=true;encrypt=true;trustServerCertificate=true;
in the 'Additional JDBS Parameters" but still no joy.

Re: [resolved] SSL and JDBC

Anonymous — Thu, 03 Dec 2009 01:05:26 GMT

Hi,
I found the soluiton for me. In the 'Additional JDBS Parameters', I entered 'ssl=require;'

Re: [resolved] SSL and JDBC

Anonymous — Tue, 06 Sep 2011 21:52:56 GMT

When I tried to connect to SQL Server with SSL, the tMSSqlConnection returns: java.sql.SQLException: I/O Error: DB server closed connection.
No matter what I entered in the 'Additional JDBC Parameters' (e.g. "integratedSecurity=true;encrypt=true;trustServerCertificate=true;" or "integratedSecurity=true;encrypt=true;trustServerCertificate=true;ssl=require;" or "ssl=require;" or "ssl=true;" ect. It doesn't work to me.
Anyone has any idea for that? thanks!