Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response
Article ID: KB0079550
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | 5.x |
Description
How to resolve following intermittent JDBC Connectivity error while connecting to SQLServer Database:
+++++++++++
"JDBC error reported: (SQLState = 08S01) - com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed.
++++++++++++
+++++++++++
"JDBC error reported: (SQLState = 08S01) - com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed.
++++++++++++
Issue/Introduction
Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response
Environment
ALL
Resolution
Update the JDBC Driver to 4.2 or later version
Remove old jar files (sqljdbc4.jar, sqljdbc41.jar) so that BW can loads the correct one (sqljdbc42.jar).
Remove old jar files (sqljdbc4.jar, sqljdbc41.jar) so that BW can loads the correct one (sqljdbc42.jar).
Additional Information
https://blogs.msdn.microsoft.com/dataaccesstechnologies/2016/11/30/intermittent-jdbc-connectivity-issue-the-driver-could-not-establish-a-secure-connection-to-sql-server-by-using-secure-sockets-layer-ssl-encryption-error-sql-server-returned-an-incomplete-respons/
Feedback
Yes
No
Powered by
