Troubleshooting
Problem
After upgrading the SQL Server JDBC driver, an exception is generated:
The test connection operation failed for data source data_source_name on server server1 at node node_name with the following exception: java.sql.SQLException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:e819b48f-3494-4bac-a2ee-27d188f3436b". DSRA0010E: SQL State = 08S01, Error Code = 0. View JVM logs for further details.
The test connection operation failed for data source data_source_name on server server1 at node node_name with the following exception: java.sql.SQLException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:e819b48f-3494-4bac-a2ee-27d188f3436b". DSRA0010E: SQL State = 08S01, Error Code = 0. View JVM logs for further details.
Cause
The exception is caused by the secured SSL connection the SQL Server which is requiring TLSv1.2, but CPE server is issuing a protocol that is deprecated, thus the SSL handshake is failing.
Resolving The Problem
Force the CPE server to use TLSv1.2 by adding the JVM runtime argument -Dcom.ibm.jsse2.overrideDefaultTLS=true
Reference
https://www.ibm.com/support/knowledgecenter/SSYKE2_8.0.0/com.ibm.java.security.component.80.doc/security-component/jsse2Docs/matchsslcontext_tls.html
Related Information
Document Location
Worldwide
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"ARM Category":[{"code":"a8m50000000Chv3AAC","label":"Database->SQL"}],"ARM Case Number":"TS004524225","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
14 July 2021
UID
ibm16370087