多数据源配置从库连接sqlserver报错,com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establis

一开始我自己本地配置如下:
在这里插入图片描述
微软家的sqlserver驱动不好用,maven的驱动如下:
在这里插入图片描述
然后在本地网段一致的情况下测试是没有问题的,当部署线上环境启动服务时,加载数据源的时候,当加载到sqlserver的数据源的时候就开始异常了,异常信息如下:

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error
javax.net.ssl.SSLHandshakeException: The server selected,,,

网上有说修改JDK什么的解决:
在这里插入图片描述
这肯定不中用,说什么JDK版本的问题,也不是这样,后面换了驱动才解决了。

尝试更换 jtds驱动,maven依赖如下:

<dependency>
<groupId>net.sourceforge.jtds</groupId>
<artifactId>jtds</artifactId>
<version>1.2.4</version>
</dependency>

在这里插入图片描述
在这里插入图片描述
再重新启动,好了。

The message you're referring to is a warning in the MySQL logs, specifically related to establishing an SSL (Secure Sockets Layer) connection without verifying the server's identity. Here's what it means: When you connect to a MySQL server using SSL, it's important to ensure that you are connecting to a trusted server and not an imposter. The warning "Establishing SSL connection without server's identity verification is not recommended" indicates that the client is attempting to establish a secure connection but isn't verifying the authenticity of the server certificate. This could potentially expose your data to man-in-the-middle attacks. The reasons for this warning are: 1. Security: Verifying the server's identity ensures that you're connecting to the correct database and not an attacker masquerading as the server. It prevents unauthorized access or eavesdropping. 2. Data Integrity: SSL encryption also provides integrity, meaning that data exchanged between the client and server cannot be tampered with if the certificate is genuine. To address this warning, you should consider these options: - Obtain and install the server's trusted certificate, if it's missing or out of date. - Use SSL/TLS configuration settings that enforce client authentication, so both client and server certificates need to be validated. - Relax the security settings only when connecting to a trusted development or internal network where such verification is unnecessary. Here are some related questions: 1. What is SSL/TLS and why is it used in MySQL connections? 2. How can I obtain and install a server certificate for my MySQL setup? 3. What are the consequences of ignoring SSL warnings during database interactions?
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

焚目圣僧渡众生

你的 一角将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值