sql server jdbc

驱动

<dependency>
	<groupId>com.microsoft.sqlserver</groupId>
	<artifactId>mssql-jdbc</artifactId>
	<version>6.2.0.jre8</version>
</dependency>

SSL连接出错

[08S01] 驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接。
错误:“The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]”。 ClientConnectionId:deff0711-853e-45ef-8817-b9db5fba7c14
The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12].

解决方案
修改/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/security/java.security文件

jdk.tls.disabledAlgorithms=SSLv3, RC4,  MD5withRSA, \
    DH keySize < 1024, EC keySize < 224, DES40_CBC, RC4_40, \
    include jdk.disabled.namedCurves

jdk.tls.legacyAlgorithms= \
        K_NULL, C_NULL, M_NULL, \
        DH_anon, ECDH_anon, \
        RC4_128, RC4_40, DES_CBC, DES40_CBC
posted @ 2023-06-28 13:16  fight139  阅读(33)  评论(0编辑  收藏  举报