SQL Server连接断断续续 [英] SQL Server connectivity is getting dropped intermittent

问题描述

在群集环境中的一个节点中，我发现间歇性地断开了连接。 

我通过设置以下JVM进行了临时修复参数。

- Djdk.tls.client.protocols = TLSv1

但由于某些其他应用程序依赖性，此解决方案无法继续使用。

还有其他方法可以永久解决此问题。错误日志如下所示。

使用的Java版本 - openjdk版本1.8.0_191

jdbc驱动程序 -   sqljdbc42.jar 

DB - MS SQL Server 2014

错误日志：

错误[PooledThread [ [] [PlatformClusterEventSender]接收事件时出错：com.microsoft.sqlserver.jdbc.SQLServerException：驱动程序无法使用安全套接字层（SSL）加密与SQL Server建立安全的
连接。错误："SQL Server返回了不完整的响应。连接已关闭。 

由以下原因引起：com.microsoft.sqlserver.jdbc.SQLServerException：驱动程序无法使用安全套接字层（SSL）加密与SQL Server建立安全连接。
错误："SQL Server返回了不完整的响应。该连接已关闭。 

解决方案

请看一下这个链接，可能会对你有所帮助：

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 /

谢谢，

Lokesh Vij

In one of the node in a clustered environment I could find that the connectivity is getting dropped intermittently. 

I had given a temporary fix by setting the below JVM parameter.

-Djdk.tls.client.protocols=TLSv1

But this solution cannot be used further due to some other application dependency.

Is there any other way in which this issue can be solved permanently. The error log is provided below.

Java version used - openjdk version 1.8.0_191

jdbc driver - sqljdbc42.jar 

DB - MS SQL Server 2014

ERROR LOG:

ERROR [PooledThread[142]] [PlatformClusterEventSender] Error while receiving event: 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. 

Caused by: 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. 

解决方案

Please have a look at this link, may be it can help you:

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/

Thanks,

Lokesh Vij

这篇关于SQL Server连接断断续续的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！