Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response
book
Article ID: KB0079550
calendar_today
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. ++++++++++++
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).
Issue/Introduction
Intermittent JDBC Connectivity Error with SQL server: SQL Server returned an incomplete response